Oracle PL/SQL 저장 프로시저를 PostgreSQL PL/pgSQL로 마이그레이션합니다. Oracle 특화 구문을 변환하고, 메서드 시그니처와 타입 앵커 파라미터를 보존하며, 적절히 orafce를 활용하고 Oracle 호환 텍스트 정렬을 위해 COLLATE "C"를 적용합니다. 데이터베이스 마이그레이션 중 Oracle 저장 프로시저나 함수를 PostgreSQL로 변환할 때 사용하세요.
이 스킬은 Oracle PL/SQL 저장 프로시저 및 함수를 PostgreSQL PL/pgSQL로 자동 변환하여 데이터베이스 마이그레이션을 간소화합니다. Oracle 특화 구문(예: %TYPE, %ROWTYPE, 특정 내장 함수)을 PostgreSQL 호환 코드로 번역하며, 메서드 시그니처와 타입 앵커 파라미터를 보존하여 마이그레이션 후에도 코드 일관성을 유지합니다. 또한 orafce 확장 모듈을 적절히 활용하여 Oracle 호환 함수를 제공하고, Oracle 텍스트 정렬 동작을 모방하기 위해 COLLATE "C"를 적용합니다. 이는 Oracle에서 PostgreSQL로의 이전(예: AWS DMS, 자체 마이그레이션) 과정에서 PL/SQL 로직을 수동으로 재작성하는 비용과 오류 가능성을 크게 줄여 줍니다. 모든 CLI 환경과 주요 AI 에이전트(Claude Code, Cursor 등)에서 사용 가능하며, 입력된 Oracle PL/SQL 코드 스니펫을 분석하여 PostgreSQL로 변환합니다.
npx skills add https://github.com/github/awesome-copilot/tree/main/skills/migrating-oracle-to-postgres-stored-proceduresInstalled? Explore more 코딩 & 개발 skills: steipete/bluebubbles, steipete/eightctl, steipete/blucli · View all 6 →
Oracle PL/SQL 저장 프로시저를 PostgreSQL PL/pgSQL로 마이그레이션합니다. Oracle 특화 구문을 변환하고, 메서드 시그니처와 타입 앵커 파라미터를 보존하며, 적절히 orafce를 활용하고 Oracle 호환 텍스트 정렬을 위해 COLLATE "C"를 적용합니다. 데이터베이스 마이그레이션 중 Oracle 저장 프로시저나 함수를 PostgreSQL로 변환할 때 사용하세요.
This repo contains 20 individual skills — each has its own dedicated page.
Use this skill when the user explicitly asks to map, document, or onboard into an existing codebase. Trigger for prompts like "map this codebase", "document this architecture", "onboard me to this repo", or "create codebase docs". Do not trigger for routine feature implementation, bug fixes, or narrow code edits unless the user asks for repository-level discovery.
Add educational comments to the file specified, or prompt asking for file to comment if one is not provided.
Patterns and techniques for adding governance, safety, and trust controls to AI agent systems. Use this skill when: - Building AI agents that call external tools (APIs, databases, file systems) - Implementing policy-based access controls for agent tool usage - Adding semantic intent classification to detect dangerous prompts - Creating trust scoring systems for multi-agent workflows - Building audit trails for agent actions and decisions - Enforcing rate limits, content filters, or tool restrictions on agents - Working with any agent framework (PydanticAI, CrewAI, OpenAI Agents, LangChain, AutoGen)
Patterns and techniques for evaluating and improving AI agent outputs. Use this skill when: - Implementing self-critique and reflection loops - Building evaluator-optimizer pipelines for quality-critical generation - Creating test-driven code refinement workflows - Designing rubric-based or LLM-as-judge evaluation systems - Adding iterative improvement to agent outputs (code, reports, analysis) - Measuring and improving agent response quality
Check any AI agent codebase against the OWASP Agentic Security Initiative (ASI) Top 10 risks. Use this skill when: - Evaluating an agent system's security posture before production deployment - Running a compliance check against OWASP ASI 2026 standards - Mapping existing security controls to the 10 agentic risks - Generating a compliance report for security review or audit - Comparing agent framework security features against the standard - Any request like "is my agent OWASP compliant?", "check ASI compliance", or "agentic security audit"
Comprehensive AI prompt engineering safety review and improvement prompt. Analyzes prompts for safety, bias, security vulnerabilities, and effectiveness while providing detailed improvement recommendations with extensive frameworks, testing methodologies, and educational content.
Instrument a webapp to send useful telemetry data to Azure App Insights
Serves as a reviewer of the codebase with instructions on looking for Apple App Store optimizations or rejection reasons.
Comprehensive project architecture blueprint generator that analyzes codebases to create detailed architectural documentation. Automatically detects technology stacks and architectural patterns, generates visual diagrams, documents implementation patterns, and provides extensible blueprints for maintaining architectural consistency and guiding new development.
Triage and resolve Arch Linux issues with pacman, systemd, and rolling-release best practices.
Creates, reads, updates, and deletes Arize AI integrations that store LLM provider credentials used by evaluators and other Arize features. Supports any LLM provider (e.g. OpenAI, Anthropic, Azure OpenAI, AWS Bedrock, Vertex AI, Gemini, NVIDIA NIM). Use when the user mentions AI integration, LLM provider credentials, create integration, list integrations, update credentials, delete integration, or connecting an LLM provider to Arize.
Creates and manages annotation configs (categorical, continuous, freeform label schemas) and annotation queues (human review workflows) on Arize. Applies human annotations to project spans via the Python SDK. Use when the user mentions annotation config, annotation queue, label schema, human feedback, bulk annotate spans, update_annotations, labeling queue, annotate record, or human review.
Creates, manages, and queries Arize datasets and examples. Covers dataset CRUD, appending examples, exporting data, and file-based dataset creation using the ax CLI. Use when the user needs test data, evaluation examples, or mentions create dataset, list datasets, export dataset, append examples, dataset version, golden dataset, or test set.
Handles LLM-as-judge evaluation workflows on Arize including creating/updating evaluators, running evaluations on spans or experiments, managing tasks, trigger-run operations, column mapping, and continuous monitoring. Use when the user mentions create evaluator, LLM judge, hallucination, faithfulness, correctness, relevance, run eval, score spans, score experiment, trigger-run, column mapping, continuous monitoring, or improve evaluator prompt.
Creates, runs, and analyzes Arize experiments for evaluating and comparing model performance. Covers experiment CRUD, exporting runs, comparing results, and evaluation workflows using the ax CLI. Use when the user mentions create experiment, run experiment, compare models, model performance, evaluate AI, experiment results, benchmark, A/B test models, or measure accuracy.
Adds Arize AX tracing to an LLM application for the first time. Follows a two-phase agent-assisted flow to analyze the codebase then implement instrumentation after user confirmation. Use when the user wants to instrument their app, add tracing from scratch, set up LLM observability, integrate OpenTelemetry or openinference, or get started with Arize tracing.
Generates deep links to the Arize UI for traces, spans, sessions, datasets, labeling queues, evaluators, and annotation configs. Produces clickable URLs for sharing Arize resources with team members. Use when the user wants to link to or open a trace, span, session, dataset, evaluator, or annotation config in the Arize UI.
Optimizes, improves, and debugs LLM prompts using production trace data, evaluations, and annotations. Extracts prompts from spans, gathers performance signal, and runs a data-driven optimization loop using the ax CLI. Use when the user mentions optimize prompt, improve prompt, make AI respond better, improve output quality, prompt engineering, prompt tuning, or system prompt improvement.
Downloads, exports, and inspects existing Arize traces and spans to understand what an LLM app is doing or debug runtime issues. Covers exporting traces by ID, spans by ID, sessions by ID, and root-cause investigation using the ax CLI. Use when the user wants to look at existing trace data, see what their LLM app is doing, export traces, download spans, investigate errors, or analyze behavior regressions.
Aspire skill covering the Aspire CLI, AppHost orchestration, service discovery, integrations, MCP server, VS Code extension, Dev Containers, GitHub Codespaces, templates, dashboard, and deployment. Use when the user asks to create, run, debug, configure, deploy, or troubleshoot an Aspire distributed application.
Send and manage iMessages via BlueBubbles, including attachments, tapbacks, edits, replies, and groups.
Control Eight Sleep pods (status, temperature, alarms, schedules).
BluOS CLI (blu) for discovery, playback, grouping, and volume.
Create, search, and manage Bear notes via grizzly CLI.
Capture frames or clips from RTSP/ONVIF cameras.
Search GIF providers with CLI/TUI, download results, and extract stills/sheets.