backend-migrations
Create and manage database migrations with proper rollback methods, focused changes, and zero-downtime deployment considerations. Use this skill when creating new database migration files, modifying table schemas, adding or removing columns, creating or dropping indexes, or managing database version control. When working with migration directories, schema definition files, or database change scripts. When implementing backwards-compatible database changes for production deployments. When separating schema changes from data migrations.
When & Why to Use This Skill
This Claude skill streamlines the creation and management of backend database migrations, ensuring all schema changes follow industry best practices for stability and scalability. It focuses on generating precise migration files, implementing robust rollback methods, and facilitating zero-downtime deployments through backwards-compatible changes and the separation of schema and data migrations.
Use Cases
- Schema Evolution: Automatically generate migration scripts for adding, removing, or modifying table columns and data types while adhering to project-specific standards.
- Zero-Downtime Deployment Planning: Design backwards-compatible database changes that allow application code and database schemas to be updated without service interruption.
- Database Version Control: Maintain a clean and organized migration history within directories like /migrations or /db/migrate, ensuring consistent environments across the development lifecycle.
- Safe Rollback Procedures: Create reliable 'down' migration methods to ensure that any database change can be safely reverted in the event of a deployment failure.
- Integrity and Performance Optimization: Manage the addition or removal of database indexes and foreign key constraints to optimize query performance and maintain data relationships.
| name | Backend Migrations |
|---|---|
| description | Create and manage database migrations with proper rollback methods, focused changes, and zero-downtime deployment considerations. Use this skill when creating new database migration files, modifying table schemas, adding or removing columns, creating or dropping indexes, or managing database version control. When working with migration directories, schema definition files, or database change scripts. When implementing backwards-compatible database changes for production deployments. When separating schema changes from data migrations. |
Backend Migrations
This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend migrations.
When to use this skill
- When creating new database migration files
- When modifying existing table schemas (adding/removing columns, changing types)
- When adding or removing database indexes
- When creating or modifying foreign key constraints
- When implementing database schema versioning
- When working with migration directories (e.g.,
migrations/,db/migrate/) - When writing rollback/down migration methods
- When planning zero-downtime deployments with backwards-compatible schema changes
- When separating schema changes from data transformation scripts
- When naming migration files with descriptive, clear names
Instructions
For details, refer to the information provided in this file: backend migrations