AgentSkillsCN

Backend Migrations

创建可逆、专注的数据库迁移,采用恰当命名、版本控制实践和零停机部署考虑。在创建或编辑database/migrations/中的迁移文件时使用此技能,当编写模式更改(创建/修改表、列、索引、外键)、实现迁移回滚方法、管理数据库版本控制、在大表上添加或修改索引,或分离模式更改与数据迁移以实现更安全部署时使用。

SKILL.md
--- frontmatter
name: Backend Migrations
description: Create reversible, focused database migrations with proper naming, version control practices, and zero-downtime deployment considerations. Use this skill when creating or editing migration files in database/migrations/, when writing schema changes (creating/modifying tables, columns, indexes, foreign keys), when implementing migration rollback methods, when managing database version control, when adding or modifying indexes on large tables, or when separating schema changes from data migrations for safer deployments.

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 migration files in database/migrations/ directory
  • When editing existing migration files (with caution for deployed migrations)
  • When writing table creation or modification logic using Schema builder
  • When implementing migration rollback/down methods for reversibility
  • When adding or modifying database columns, indexes, or constraints
  • When creating or dropping foreign key relationships
  • When renaming tables or columns
  • When adding indexes to tables, especially large production tables
  • When separating schema changes from data migrations
  • When considering zero-downtime deployment strategies for migrations
  • When writing data migrations or seeders that modify existing records
  • When planning backwards-compatible database changes

Instructions

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