AgentSkillsCN

Backend Migrations

创建与管理数据库迁移，以应对模式变化，确保零停机部署与数据完整性。当创建迁移文件、修改数据库模式、增删表/列/索引，或使用Alembic、Flyway、Liquibase等迁移工具，或特定框架的迁移系统（Django迁移、Rails迁移、Prisma迁移）时，使用此技能。在实现可逆迁移，采用up/down方法，将数据迁移与模式变化分开处理，为大表创建索引，或规划面向高可用系统的向后兼容模式变化时，应用此技能。此技能确保迁移版本可控、专注、安全回滚，与CI/CD流水线及零停机部署策略兼容。

SKILL.md
--- frontmatter
name: Backend Migrations
description: Create and manage database migrations for schema changes, ensuring zero-downtime deployments and data integrity. Use this skill when creating migration files, modifying database schemas, adding or altering tables/columns/indexes, or working with migration tools like Alembic, Flyway, Liquibase, or framework-specific migration systems (Django migrations, Rails migrations, Prisma migrations). Apply this skill when implementing reversible migrations with up/down methods, handling data migrations separately from schema changes, creating indexes on large tables, or planning backwards-compatible schema changes for high-availability systems. This skill ensures migrations are version-controlled, focused, safe to rollback, and compatible with CI/CD pipelines and zero-downtime deployment strategies.

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 for schema changes
  • •When adding, removing, or modifying database tables, columns, or constraints
  • •When creating or dropping indexes, foreign keys, or unique constraints
  • •When working with migration tools like Alembic, Flyway, Liquibase, Django migrations, or Rails migrations
  • •When implementing reversible migrations with proper up/down or forward/backward methods
  • •When separating schema changes from data migrations for safety
  • •When planning zero-downtime deployments requiring backwards-compatible changes
  • •When creating indexes on large tables using concurrent/online index creation
  • •When modifying migration files in migrations/, db/migrate/, or similar directories
  • •When setting up migration version control and naming conventions
  • •When implementing migration testing in staging environments
  • •When handling migration rollbacks or fixing failed migrations

Instructions

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