backend-migrations

mshafei721 的头像作者 mshafei721

通过可逆更改、正确的命名约定和零停机部署注意事项创建和管理数据库迁移。在创建新的数据库迁移、修改架构更改、添加或删除表/列、创建索引或管理数据迁移时使用此技能。处理 migrations/、db/migrate/、alembic/ 或 prisma/migrations/ 目录中的文件时。在编写向上/向下迁移方法、规划生产部署的架构更改或检查迁移文件以确保安全性和回滚功能时。

📖 中文导读:通过可逆更改、正确的命名约定和零停机部署注意事项创建和管理数据库迁移。在创建新的数据库迁移、修改架构更改、添加或删除表/列、创建索引或管理数据迁移时使用此技能。处理 migrations/、db/migrate/、alembic/ 或 prisma/migrations/ 目录中的文件时。在编写向上/向下迁移方法、规划生产部署的架构更改或检查迁移文件以确保安全性和回滚功能时。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: Backend Migrations description: Create and manage database migrations with reversible changes, proper naming conventions, and zero-downtime deployment considerations. Use this skill when creating new database migrations, modifying schema changes, adding or removing tables/columns, creating indexes, or managing data migrations. When working on files in migrations/, db/migrate/, alembic/, or prisma/migrations/ directories. When writing up/down migration methods, planning schema changes for production deployments, or reviewing migration files for safety and rollback capability.

When to use this skill:

  • When creating new database migration files
  • When modifying existing migrations before deployment
  • When adding, altering, or dropping database tables or columns
  • When creating or removing database indexes
  • When working on files in migrations/, db/migrate/, alembic/, or prisma/migrations/ directories
  • When writing rollback/down methods for migrations
  • When planning schema changes that need to be backwards compatible
  • When separating schema changes from data migrations
  • When creating indexes on large tables with concurrent options
  • When naming migration files descriptively
  • When reviewing migrations for zero-downtime deployment safety

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