db-migration-oracle-postgres

What problem does it solve?

This Skill eliminates the high risk and manual effort of migrating Ruby on Rails applications from Oracle Database to PostgreSQL, which involves complex schema type mapping, PL/SQL logic conversion, adapter swaps, and safe production cutover to avoid data loss, broken functionality, or numeric precision errors.

Core Features & Use Cases

• Schema & Data Conversion: Uses ora2pg to automatically map Oracle types (NUMBER, VARCHAR2, CLOB/BLOB) to PostgreSQL equivalents (BIGINT/DECIMAL, VARCHAR, TEXT/BYTEA) and convert schema, sequences, indexes, and bulk data.
• PL/SQL Logic Porting: Guides manual translation of Oracle PL/SQL packages, triggers, and hierarchical queries (CONNECT BY) to PostgreSQL's PL/pgSQL and WITH RECURSIVE syntax, with guidance to move database logic to Ruby where testable and maintainable.
• Zero-Downtime Cutover: Implements dual-write cutover patterns to validate data consistency before switching primary databases, with guardrails to avoid common pitfalls like untranslated PL/SQL packages or NUMBER precision drift. Use case: A Rails team with an enterprise app on Oracle can use this Skill to plan and execute a full migration to PostgreSQL in 4-12 weeks, avoiding costly rework from untranslated database logic or data type mismatches.

Quick Start

Use the db-migration-oracle-postgres skill to build a full migration plan for your Rails app moving from Oracle to PostgreSQL, including ora2pg configuration, PL/SQL audit steps, and dual-write cutover procedures.