migrating-oracle-to-postgres-stored-procedures
Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL
by githubFree
Description
migrating-oracle-to-postgres-stored-procedures is an agent skill from the github/awesome-copilot collection for translating Oracle PL/SQL stored procedures and functions into PostgreSQL PL/pgSQL. The migration follows three steps. The agent reads the Oracle source procedure from the migration project's DDL folder, and it consults the table and view definitions to resolve the types each parameter and variable uses. It then translates the code to PL/pgSQL, converting Oracle-specific syntax and keeping the method signatures and type-anchored parameters so that callers continue to work. It writes the migrated procedure to the PostgreSQL output directory. Stored procedures hold business logic, and differences in how the two databases handle types, nulls, dates and error handling can change results without any error being raised, so the translated procedures should be checked against the original with tests. The skill is useful for teams moving an Oracle database to PostgreSQL that have many procedures to convert. The agent's translation is a starting point, and it should be reviewed by someone who knows the business rules, particularly for procedures that handle money or records. The skill is installed with the skills CLI from the github/awesome-copilot repository. Its skills.sh page showed about 1.8K installs and passing results from three security audits at the time of the scan.…
Highlights
- Translates PL/SQL to PL/pgSQL
- Keeps method signatures and type-anchored parameters
- Uses table and view definitions for types
- Writes migrated procedures to the output directory
- Installs with the skills CLI
Ratings & Reviews
No ratings yet
Be the first to rate migrating-oracle-to-postgres-stored-procedures.
People also visit
creating-oracle-to-postgres-master-migration-plan
Discovers all projects in a .NET solution
planning-oracle-to-postgres-migration-integration-testing
Creates an integration testing plan
reviewing-oracle-to-postgres-migration
Identifies Oracle-to-PostgreSQL migration risks
scaffolding-oracle-to-postgres-migration-test-project
Scaffolds an xUnit integration test project targeting Oracle in .NET solutions
creating-oracle-to-postgres-migration-integration-tests
Creates integration test cases targeting Oracle for .NET data access artifacts
migrating-oracle-to-postgres-stored-procedures FAQ
What does it convert?
Oracle PL/SQL stored procedures and functions into PostgreSQL PL/pgSQL.
Does the conversion keep callers working?
It keeps the method signatures and type-anchored parameters, so existing callers can continue to use them.
Can the translation be trusted as is?
No. Test the translated procedures against the original and have someone who knows the business rules review them.
How do I install it?
Run npx skills add https://github.com/github/awesome-copilot --skill migrating-oracle-to-postgres-stored-procedures.
What security audits does it have?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best migrating-oracle-to-postgres-stored-procedures alternatives?
Popular alternatives to migrating-oracle-to-postgres-stored-procedures include creating-oracle-to-postgres-master-migration-plan, creating-oracle-to-postgres-migration-bug-report and planning-oracle-to-postgres-migration-integration-testing. See all migrating-oracle-to-postgres-stored-procedures alternatives