---

name: Backend Migrations description: Create and manage database migrations following best practices for reversibility, zero-downtime deployments, and safe schema changes. Use this skill when creating new database migrations, writing migration up/down methods, implementing schema changes (adding/removing tables, columns, indexes, constraints), performing data migrations or transformations, refactoring database structure, implementing backwards-compatible migrations, creating indexes on large tables, renaming database objects, or working with migration files in directories like migrations/, db/migrate/, alembic/versions/, or similar. Use when working with ORMs like Sequelize, TypeORM, Prisma, SQLAlchemy, ActiveRecord, Django ORM, or raw SQL migration files.

When to use this skill

• When creating new database migration files
• When implementing migration up/down (or upgrade/downgrade) methods
• When adding, removing, or modifying database tables
• When adding, removing, or modifying database columns
• When creating, dropping, or modifying indexes or constraints
• When performing data migrations or transformations
• When refactoring database structure
• When implementing backwards-compatible schema changes
• When creating indexes on large tables (considering concurrent options)
• When renaming tables, columns, or other database objects
• When working with migration directories (migrations/, db/migrate/, alembic/versions/)
• When working with ORMs like Sequelize, TypeORM, Prisma, SQLAlchemy, ActiveRecord, Django ORM
• When writing raw SQL migration files

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.

Instructions

For details, refer to the information provided in this file: backend migrations