AgentSkillsCN

Backend Migrations

遵循可逆性、零停机部署及版本控制的最佳实践，高效创建并管理数据库迁移。在新建迁移文件、修改数据库架构、增删表或列、管理索引，或执行数据转换等场景中，均可运用此技能。无论是处理迁移文件（migrations/*.ts、migrations/*.sql、*_migration.py）、Prisma 架构变更，还是 Supabase 迁移，抑或是其他各类数据库演进任务，皆可灵活应用。通过可逆迁移方案，配备回滚/降级机制；坚持小而聚焦的单次变更迁移策略；确保零停机部署的兼容性；将架构迁移与数据迁移分离；在大型表上安全地进行并发索引创建；采用清晰且具描述性的命名规范；并严格遵循版本控制的最佳实践——切勿直接修改已部署的迁移文件。

SKILL.md
--- frontmatter
name: Backend Migrations
description: Create and manage database migrations following best practices for reversibility, zero-downtime deployments, and version control. Use this skill when creating migration files, modifying database schemas, adding or removing tables/columns, managing indexes, or performing data transformations. Apply when working on migration files (migrations/*.ts, migrations/*.sql, *_migration.py), Prisma schema changes, Supabase migrations, or any database evolution tasks. This skill ensures reversible migrations with rollback/down methods, small focused single-change migrations, zero-downtime deployment compatibility, separated schema and data migrations, safe concurrent index creation on large tables, clear descriptive naming conventions, and proper version control practices (never modify deployed migrations).

Backend Migrations

When to use this skill:

  • •When creating new database migration files
  • •When modifying existing database schemas (adding/removing tables or columns)
  • •When working on migration files (migrations/.ts, migrations/.sql, *_migration.py)
  • •When adding or modifying database indexes for performance
  • •When performing data migrations or transformations
  • •When implementing rollback/down methods for migrations
  • •When ensuring zero-downtime deployment strategies
  • •When managing schema versioning and migration order
  • •When separating schema changes from data migrations
  • •When working with Prisma migrate, Supabase migrations, or Entity Framework migrations
  • •When creating indexes on large PostgreSQL tables using concurrent options
  • •When planning backwards-compatible schema changes for high-availability systems

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