skills.homes logoskills.homescapability registry
home/categories/sql-databases/comeonoliver-skillshub-skills-github-awesome-copilot-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
ComeOnOliver
maintainer
ComeOnOliver
Updated 3/23/2026
Stars
26
Forks
7
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