Database Migration Manager

Overview

Database Migration Manager handles the complexity of evolving your database schema over time. It generates migration files, plans safe execution strategies, and ensures data integrity throughout the process.

Key Features

• Migration Generation: Creates timestamped migration files with both up and down scripts. Supports SQL migrations and ORM-specific formats (Prisma, Knex, Drizzle, Alembic).
• Breaking Change Detection: Identifies migrations that could break existing queries or application code, such as column renames, type changes, or NOT NULL additions on populated tables.
• Zero-Downtime Strategies: For production databases, suggests multi-step migration patterns (expand-contract) that avoid locking tables or breaking running applications.
• Rollback Planning: Every migration comes with a tested rollback script. Complex migrations include data preservation steps to ensure no information is lost during rollback.

Supported Databases

PostgreSQL, MySQL, SQLite, and SQL Server. ORM support includes Prisma, Drizzle, Knex, TypeORM, SQLAlchemy, and Django ORM. Each generates idiomatic migration files for the target platform.

Safety Measures

All destructive operations require double confirmation. The skill checks for foreign key dependencies before DROP operations and warns about data loss. A dry-run mode shows exactly what SQL will execute.