What problem does it solve?
Database schema and data changes often break applications, cause downtime, or leave teams without a reliable rollback path when something goes wrong.
Core Features & Use Cases
- Cross-ORM migration patterns: Guides migration approaches for Sequelize, TypeORM, and Prisma, including how to define up/down behavior.
- Safe schema transformations: Covers adding columns with defaults, renaming via multi-step compatibility strategies, and changing column types using intermediate columns and backfills.
- Data transformation and integrity: Provides patterns for complex record reshaping and for reversing transformations during rollback.
- Rollback strategies: Includes transaction-based rollback and checkpoint/backup-table rollback to recover from migration verification failures.
- Zero-downtime deployments: Implements blue-green and backward-compatible rollout phases (add new columns, backfill, dual-write/read, then remove old columns).
Use this Skill when you must refactor a production database schema (e.g., renaming fields, changing data types, moving data formats) while keeping the system working and ensuring you can revert safely.
Quick Start
Use the database-migration skill when planning a schema refactor and ask it to produce a zero-downtime migration plan with a rollback procedure for your specific ORM and database change.
