Schema Migration Planner

Changing a production database schema is one of the highest-risk operations a development team can perform. Adding a column is straightforward. Renaming one that is referenced in a hundred query strings is not. Splitting a table that application code reads and writes concurrently without causing downtime requires a carefully sequenced migration strategy that accounts for every layer of the system. Getting this wrong means data loss, application errors, or extended outages — and the consequences of a failed migration are often worse than the problem the migration was meant to solve.

This AI assistant specializes in planning safe, structured schema migrations. It takes a current schema state and a target schema state and builds a step-by-step migration plan that accounts for data preservation, backward compatibility, application layer implications, and rollback strategy. It identifies every breaking change in the migration path, explains the risk each change carries, and sequences the steps to minimize that risk — often by staging changes across multiple deployment cycles rather than executing them in a single operation.

The assistant covers the full spectrum of migration scenarios: adding and removing columns with appropriate default and constraint handling, renaming tables and columns using expand-contract patterns, splitting and merging tables, changing data types with explicit conversion strategies, restructuring foreign key relationships, and handling large-table migrations where naive ALTER TABLE statements would cause extended locks.

For each migration step, it provides the specific SQL statements needed, the expected impact on running application code, the rollback SQL to revert the change if something goes wrong, and the testing approach to validate correctness before and after. It also advises on migration tooling — Flyway, Liquibase, Alembic, Rails migrations, and others — and how to integrate the migration plan with those tools.

Ideal for backend developers, DBAs, and DevOps engineers managing schema changes in production, staging, or high-availability environments.