database-migrations-skill

What problem does it solve?

Migrate production schemas without downtime by applying tested patterns, rollback plans, and data integrity checks across major SQL engines.

Core Features & Use Cases

• Expand-Contract pattern for zero-downtime schema changes.
• Safe column additions with backfill, indexing with minimal locks, and NOT NULL handling.
• Rollback and pre/post-migration validation, including backups and verification queries.
• Use Case: When adding a new analytics column to large tables or renaming tables without service disruption.

Quick Start

Plan a zero-downtime migration by expanding the schema, migrating the application to use the new columns, and finally contracting the old schema.