How do I install the Migrating Oracle To Postgres Stored Procedures skill?

Run npx skillmds@latest add github/migrating-oracle-to-postgres-stored-procedures in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Migrating Oracle To Postgres Stored Procedures safe to use?

SkillMD's automated safety review verdict for this skill is PASS. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Migrating Oracle To Postgres Stored Procedures?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Migrating Oracle To Postgres Stored Procedures free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Migrating Oracle To Postgres Stored Procedures?

GitHub (Microsoft) (@github) published this skill as a verified publisher. Their other Agent Skills are listed on their SkillMD profile.

Migrating Oracle To Postgres Stored Procedures by github

Name: Migrating Oracle To Postgres Stored Procedures
Rating: 4.5 (4 reviews)
Author: GitHub (Microsoft)

Migrating Oracle To Postgres Stored Procedures

Translates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL, preserving method signatures and type-anchored parameters while applying Oracle-compatible sorting and leveraging orafce.

GitHub (Microsoft) Updated Jul 6, 2026 36.2k repo stars

File contents

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.

---name: migrating-oracle-to-postgres-stored-proceduresdescription: Translates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL, preserving method signatures and type-anchored parameters while applying Oracle-compatible sorting and leveraging orafce.---# Migrating Stored Procedures from Oracle to PostgreSQLTranslate 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.

Frequently asked questions