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:

Translate all Oracle-specific syntax to PostgreSQL equivalents.
Preserve original functionality and control flow logic.
Keep type-anchored input parameters (e.g., PARAM_NAME IN table_name.column_name%TYPE).
Use explicit types (NUMERIC, VARCHAR, INTEGER) for output parameters passed to other procedures — do not type-anchor these.
Do not alter method signatures.
Do not prefix object names with schema names unless already present in the Oracle source.
Leave exception handling and rollback logic unchanged.
Do not generate COMMENT or GRANT statements.
Use COLLATE "C" when ordering by text fields for Oracle-compatible sorting.
Leverage the orafce extension when it improves clarity or fidelity.

Consult the PostgreSQL table/view definitions at .github/oracle-to-postgres-migration/DDL/Postgres/Tables and Views/ for target schema details.

Step 3: Write the migrated procedure to Postgres output directory

Place each migrated procedure in its own file under .github/oracle-to-postgres-migration/DDL/Postgres/Procedures and Functions/{PACKAGE_NAME_IF_APPLICABLE}/. One procedure per file.

Files1

1 files · 1.0 KB

Select a file to preview

Overall Score

76/100

Grade

B

Good

Safety

85

Quality

72

Clarity

82

Completeness

65

Summary

This skill guides an agent through migrating Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. It provides a structured 3-step workflow: read Oracle source code, apply translation rules (handling type anchors, syntax conversion, and collation), and write output to a project-scoped directory structure.

Detected Capabilities

file readfile writesyntax translationproject-scoped file operations

Trigger Keywords

Phrases that MCP clients use to match this skill to user intent.

migrate oracle proceduresconvert plsqloracle to postgresstored procedure migrationpl/pgsql translation

Use Cases

Migrate an Oracle stored procedure to PostgreSQL during a database migration Translate Oracle package functions to PostgreSQL equivalents Preserve parameter type-anchoring and method signatures during conversion Apply Oracle-compatible text sorting with COLLATE "C" in PostgreSQL code Leverage orafce extension for improved compatibility

Quality Notes

Clear workflow structure with 3 discrete steps Well-defined input and output paths scoped to .github/oracle-to-postgres-migration/ Comprehensive translation rules covering type anchoring, method signature preservation, exception handling, and collation Instructions preserve Oracle semantics and functionality during conversion No guidance on error handling if source Oracle code contains unrecognized constructs No guidance on handling Oracle packages with interdependencies Lacks examples of before/after translations for common Oracle-to-PostgreSQL patterns (e.g., DBMS_OUTPUT, RAISE_APPLICATION_ERROR, cursor loops)

Model: claude-haiku-4-5-20251001Analyzed: Jun 26, 2026

Reviews

Add this skill to your library to leave a review.

No reviews yet

Be the first to share your experience.

migrating-oracle-to-postgres-stored-procedures