Migrating Oracle To Postgres Stored Procedures

This automates the tedious work of converting Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL during database migrations. It reads from a specific directory structure, translates Oracle syntax while preserving method signatures and type-anchored parameters, and writes each migrated procedure to its own file in the Postgres output directory. The skill applies Oracle-compatible collation rules and leverages the orafce extension where it helps. What's useful here is that it handles the fiddly bits like keeping input parameters type-anchored while using explicit types for output parameters, which is exactly the kind of inconsistency that trips people up when doing this manually. If you're migrating an Oracle database with hundreds of stored procedures, this will save you from a lot of repetitive, error-prone conversion work.

Install to Claude Code

npx -y skills add github/awesome-copilot --skill migrating-oracle-to-postgres-stored-procedures --agent claude-code