What problem does it solve?
Database and schema changes are high-risk operations that can cause downtime, data loss, or application errors if dependencies, data transformations, and rollback paths are not carefully planned. This Skill structures discovery, impact analysis, dependency mapping, phased execution, and rollback strategies so teams can perform migrations safely across environments.
Core Features & Use Cases
- Discovery & Inventory: Identify database type, ORM/migration tooling, existing migrations, and the precise schema elements affected.
- Impact & Dependency Analysis: Surface affected tables, constraints, views, stored procedures, downstream services, and code paths that must be updated.
- Phased Expand-Migrate-Contract Plan: Produce ordered phases with pre-conditions, ordered steps, verification checks, duration estimates, and explicit rollback steps.
- Rollback & Safety: Define rollback triggers, exact undo steps, data recovery guidance, and points of no return for each phase.
- Output Delivery: Emit a comprehensive MIGRATION-PLAN.md with a pre-flight checklist useful for staging and production rollouts.
- Use Case Example: Preparing a zero-downtime migration to add a non-nullable column, including dual-writing, backfill in batches, and final schema cleanup.
Quick Start
Ask the skill to produce a phased migration plan for migrating the users table to a new schema including backfill, verification checks, and rollback procedures.
