Migrating Oracle To Postgres Stored Procedures

This automates the tedious work of converting Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL during database migrations. It reads from a specific directory structure, translates Oracle syntax while preserving method signatures and type-anchored parameters, and writes each migrated procedure to its own file in the Postgres output directory. The skill applies Oracle-compatible collation rules and leverages the orafce extension where it helps. What's useful here is that it handles the fiddly bits like keeping input parameters type-anchored while using explicit types for output parameters, which is exactly the kind of inconsistency that trips people up when doing this manually. If you're migrating an Oracle database with hundreds of stored procedures, this will save you from a lot of repetitive, error-prone conversion work.

skills.sh installs: 1.8K
GitHub stars: 41K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add github/awesome-copilot --skill migrating-oracle-to-postgres-stored-procedures --agent claude-code

Installs into .claude/skills of the current project.

Files

Migrating Stored Procedures from Oracle to PostgreSQL

Translate Oracle PL/SQL stored procedures and functions to PostgreSQL PL/pgSQL equivalents.

Workflow

Progress:
- [ ] Step 1: Read the Oracle source procedure
- [ ] Step 2: Translate to PostgreSQL PL/pgSQL
- [ ] Step 3: Write the migrated procedure to Postgres output directory

Step 1: Read the Oracle source procedure

Read the Oracle stored procedure from .github/oracle-to-postgres-migration/DDL/Oracle/Procedures and Functions/. Consult the Oracle table/view definitions at .github/oracle-to-postgres-migration/DDL/Oracle/Tables and Views/ for type resolution.

Step 2: Translate to PostgreSQL PL/pgSQL

Apply these translation rules:

SKILL.md on GitHub