backend-migrations
Create and manage database migrations following best practices for safe schema evolution. Use this skill when creating new database migration files for schema changes. Use this skill when modifying table structures, adding or removing columns, or changing data types. Use this skill when creating or modifying database indexes. Use this skill when implementing reversible migrations with up/down or rollback methods. Use this skill when working with migration files in database change management directories. Use this skill when planning zero-downtime deployments or backwards-compatible schema changes. Use this skill when separating schema changes from data migrations.
When & Why to Use This Skill
This Claude skill automates the creation and management of database migrations, ensuring safe and reversible schema evolution. It helps developers maintain database integrity by following industry best practices for table modifications, index management, and zero-downtime deployment strategies, significantly reducing the risk of manual errors during database versioning.
Use Cases
- Schema Evolution: Automatically generate migration files for adding, removing, or modifying table columns and data types while maintaining data integrity.
- Index Management: Create or modify database indexes to optimize query performance while adhering to standardized naming conventions.
- Reversible Migrations: Implement robust up/down or rollback methods to ensure database changes can be safely reverted in case of deployment issues.
- Zero-Downtime Deployment: Plan and execute complex database changes by separating schema modifications from data migrations to support continuous availability.
- Version Control Integration: Manage migration files within database change management directories to ensure correct execution order and team synchronization.
| name | Backend Migrations |
|---|---|
| description | Create and manage database migrations following best practices for safe schema evolution. Use this skill when creating new database migration files for schema changes. Use this skill when modifying table structures, adding or removing columns, or changing data types. Use this skill when creating or modifying database indexes. Use this skill when implementing reversible migrations with up/down or rollback methods. Use this skill when working with migration files in database change management directories. Use this skill when planning zero-downtime deployments or backwards-compatible schema changes. Use this skill when separating schema changes from data migrations. |
Backend Migrations
When to use this skill
- When creating new database migration files
- When modifying database table schemas, columns, or constraints
- When adding, modifying, or removing database indexes
- When implementing rollback/down migration methods
- When planning migration strategies for zero-downtime deployments
- When separating schema changes from data migrations
- When naming migration files with descriptive, clear names
- When working with migration version control and deployment order
- When considering backwards compatibility in database changes
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.
Instructions
For details, refer to the information provided in this file: backend migrations