Overview

This skill helps create and manage database migrations by generating complete migration files that follow your project's database framework conventions. It covers analysis of schema changes, script generation for up and down migrations, and testing strategies to minimize risk and downtime.

How This Skill Works

First, analyze the required schema changes and data transformation needs while assessing risk and performance impact. Then generate up and down migration scripts with proper indexing, constraints, and data migration steps, including rollback procedures and validation hooks. Finally, apply a testing strategy on staging to confirm correctness and plan deployment steps.

When to Use It

• Planning a schema change that touches multiple tables
• Transforming data with migrations that require data migration logic
• Implementing atomic, reversible migrations with rollback procedures
• Pursuing zero-downtime deployment strategies for large datasets
• Testing migrations in a staging environment before production

Quick Start

1. Step 1: Analyze required schema changes and data transformation needs
2. Step 2: Generate up and down migration scripts with indexing, constraints, and rollback logic
3. Step 3: Test on staging, verify data integrity, and document deployment steps

Best Practices

• Ensure migrations are atomic and reversible
• Add proper error handling and validation
• Include progress monitoring for large datasets
• Include proper indexing and constraint management
• Plan rollback procedures and timing for zero-downtime deployment

Example Use Cases

• Adding a new indexed column to users and creating a corresponding down script
• Splitting a denormalized address field into a separate table with data migration logic
• Converting a varchar date field to a timestamp with a data migration
• Performing zero-downtime schema changes using online index builds and careful versioning
• Testing and validating migrations on staging before production rollout

Frequently Asked Questions