Enforces best practices for creating reversible, zero-downtime database schema evolutions and data migrations.
The Backend Migration Standards skill equips Claude with rigorous protocols for managing database evolution across various ecosystems like Alembic, Rails, and Sequelize. It ensures that every schema change is reversible, follows strict naming conventions, and implements zero-downtime strategies such as concurrent indexing and multi-step column removal. By prioritizing data integrity and deployment safety, this skill helps developers avoid common pitfalls like table locking, inconsistent versioning, or destructive changes in production environments.
Key Features
01Mandatory rollback (down) implementation for all migrations
02Idempotent batch processing for large-scale data migrations
03Concurrent index creation patterns for PostgreSQL and MySQL
0481 GitHub stars
05Zero-downtime deployment strategies for complex schema changes
06Standardized naming conventions and logical file organization
Use Cases
01Implementing non-blocking index additions on large production tables
02Creating new database migration files with automatic rollback support
03Executing complex data transformations without service interruption
