Index of every page on this site: llms.txt
All skills
github avatar

/migrating-oracle-to-postgres-stored-procedures

@f10fdb8 official
by githubgithub/awesome-copilot41k stars
5,399
Run it yourself

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 explicit collation mapping (`COLLATE "C"` only when appropriate, locale collations when required). Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Use this Skill: https://skilld.dev/gh/github/awesome-copilot/migrating-oracle-to-postgres-stored-procedures

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

SKILL.md

≈116 tokens for metadata: the name and description. ≈664 when used: this file.

Description uses 5.8% of example budget

Before choosing a Skill, your Agent reads its name and description. All available Skills share that space.

  • A shorter description leaves more room for other Skills. This entry exceeds our 1% size suggestion.

In our Claude Code example, all Skill names and descriptions share 8,000 characters. This Skill uses ≈466 characters, or 5.8%.

The 1% threshold is a size suggestion. Longer descriptions can still fit.

Your model, settings, and other Skills decide how much text your Agent can read.

Example settings and source

The example uses a 200k-token context and default Claude Code settings. The count includes the name, description, separators, and when_to_use when present. Codex also counts local file paths.

Skit's source and limits: Codex 0.160.1, Claude Code 2.1.292.

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.
  • Apply collation intentionally when ordering text:
    • Use COLLATE "C" only when Oracle-compatible binary ordering is required and no other sort order is specified.
    • If Oracle used explicit linguistic sorting (for example NLS_SORT = French), map to an explicit PostgreSQL locale collation instead of "C".
    • Use SELECT collname, collprovider, collcollate, collctype FROM pg_collation ORDER BY collname; to discover collations in the target environment.
  • Treat UNION ALL as a review checkpoint. Validate plan quality per branch and restructure if combined-branch planning causes regressions (for example, unexpected sequential scans on large tables).
  • Leverage the orafce extension when it improves clarity or fidelity.

Consult the PostgreSQL table/view definitions at .github/oracle-to-postgres-migration/DDL/Postgres/{ProjectName}/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/{ProjectName}/Procedures and Functions/{PACKAGE_NAME_IF_APPLICABLE}/. One procedure per file.

{ProjectName} is the project's assembly/folder name with spaces normalized to - (e.g. MyApp.DataAccess). This matches the path used by the agent and other migration skills.

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

1 warning20d5 checks · Risk SAFE
  • Gen Agent Trust Hub20d

    The skill is a legitimate tool for database migration that processes source code files. It presents a minor indirect prompt injection surface because it reads external SQL files without explicit boundary markers.

  • Socket20d

    No alerts

  • Snyk20d

    Risk: LOW · No issues

  • Runlayer8mo

    1/1 file flagged

  • ZeroLeaks7mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at f10fdb8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 months ago
  • Database
  • oracle
  • postgres
  • plsql
  • plpgsql
  • migrations
  • stored-procedures
  • orafce

README badge

README badge for github/awesome-copilot/migrating-oracle-to-postgres-stored-procedures

Translates Oracle PL/SQL stored procedures and functions to PostgreSQL PL/pgSQL, preserving type-anchored parameters and method signatures while applying Oracle-compatible text sorting with COLLATE "C". Targets database migrations where Oracle procedures need PostgreSQL equivalents, using the orafce extension where it improves fidelity.

Generated from the current SKILL.md.

Does this skill preserve Oracle-specific features like type-anchored parameters?
Yes. Input parameters keep their type-anchored form (e.g., table_name.column_name%TYPE), while output parameters are converted to explicit types (NUMERIC, VARCHAR, INTEGER) for PostgreSQL compatibility.
What happens with Oracle syntax that has no direct PostgreSQL equivalent?
The skill translates Oracle-specific syntax to PostgreSQL equivalents and leverages the orafce extension where it improves clarity or fidelity to the original behavior.
Does this skill handle text sorting differences between Oracle and PostgreSQL?
Yes. It applies COLLATE "C" when ordering by text fields to maintain Oracle-compatible sorting behavior.
Will method signatures or control flow be altered during migration?
No. The skill preserves original method signatures, control flow logic, and exception handling as-is while translating syntax.
Does this generate COMMENT or GRANT statements?
No. The skill does not generate COMMENT or GRANT statements; it focuses on translating the procedure logic itself.

Generated from the current SKILL.md. These answers refresh after source changes.