migration-checker

Database migration safety checks review schema changes for dangerous operations like adding non-nullable columns, dropping or renaming columns, and type changes that risk data loss. This Skill audits your migrations against ORM and migration tooling such as Prisma, Alembic, TypeORM, Rails, Flyway, and Liquibase to flag risky patterns and enforce backwards compatibility, rollback capability, and zero-downtime deployment practices.

Common unsafe patterns include direct addition of non-nullable fields, unsupervised column renames and drops, concurrent constraint changes, and unbatched data transformations. Migration review identifies these patterns and enforces safer alternatives like multi-step field addition, concurrent index creation, and batched data migrations to maintain data integrity while minimizing deployment downtime.

Rollback validation ensures each migration step can be reversed without data loss or corruption. This Skill reviews migrations to confirm explicit rollback procedures exist, data preservation logic is sound, and the sequence supports safe reversal if production issues occur during or after deployment.

Yes. This Skill supports schema changes and data migrations across popular frameworks including Prisma, Alembic, TypeORM, Rails, Flyway, and Liquibase. It analyzes migration files to detect unsafe operations and recommend safe multi-step alternatives regardless of your tooling choice.

Direct column renames and drops cause downtime and data loss. Safe migration patterns perform rename or restructure as multiple coordinated steps: create the new column, backfill data, update application code, then drop the old column. This maintains backwards compatibility and allows rollback without data restoration.

Migration review identifies unsafe patterns and provides specific guidance on safe multi-step alternatives without requiring a full rewrite. You receive a rollout plan showing concurrent index creation, batched transformations, and explicit rollback procedures to apply to your existing migration strategy.