forge-migrations

What problem does it solve?

It prevents AI-generated database migrations from causing production incidents like long table locks, full-table rewrites, unsafe index creation, or irreversible schema changes during live traffic.

Core Features & Use Cases

• Lock-free, zero-downtime migration patterns: Guides safe sequencing for Postgres and MySQL (including concurrent index creation and NOT VALID + VALIDATE foreign keys/constraints).
• Safe schema evolution with reversibility: Enforces immutability after merge, timestamped ordering, and explicit down steps that fail loudly for irreversible actions.
• Operationally correct backfills: Requires batched data updates (and running large backfills outside migration tools) to reduce WAL/lock pressure.

Quick Start

Ask the AI to rewrite the migration as safe, zero-downtime steps for Postgres or MySQL, including backfill strategy, concurrent indexes, NOT VALID + VALIDATE constraints/foreign keys, and an explicit reversible down plan.