Schema Migration

What problem does it solve?

This Skill automates the creation of safe, zero-downtime database schema migrations, including rollback procedures, to prevent data loss and minimize application downtime.

Core Features & Use Cases

• Zero-Downtime Migrations: Generates SQL for safe schema changes that avoid locking critical tables for extended periods.
• Rollback Procedures: Automatically creates corresponding DOWN migrations for easy reversion if issues arise.
• Backward-Compatibility: Assesses and ensures compatibility with older application versions using patterns like expand-and-contract.
• Use Case: When adding a new column to a high-traffic users table, this Skill will generate a multi-phase migration to add the column as nullable, backfill data, and then make it non-nullable, all while minimizing user impact.

Quick Start

Use the schema migration skill to create a migration for adding a new email_verified boolean column to the users table.