skills.homes logoskills.homescapability registry
home/categories/sql-databases/github-awesome-copilot-skills-migrating-oracle-to-postgres-stored-procedures-skill-md
cd ..
sql-databasesdatabases

migrating-oracle-to-postgres-stored-procedures

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

View Sourcesql-databases
github
maintainer
github
Updated 3/10/2026
Stars
29277
Forks
3455
quick start

Installation and usage

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use migrating-oracle-to-postgres-stored-procedures