backend migration standards

SKILL.md

Apply these rules when creating or modifying database migrations. Migrations are permanent records of schema evolution and must be treated with extreme care.

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.

Reversibility is Mandatory: Every migration MUST have a working rollback method. Test the down migration immediately after writing the up migration. If a change cannot be reversed safely (e.g., dropping a column with data), document why in comments and consider a multi-step approach.

通過可逆更改、正確的命名約定和零停機部署策略來創建和管理數據庫遷移。在創建數據庫遷移文件、修改架構、添加或刪除表/列、管理索引或處理數據遷移時使用此技能。在處理遷移文件（例如 db/migrate/、migrations/、alembic/、sequelize 遷移）、架構更改、數據庫版本控制、回滾實現時，或者在部署期間需要確保向後兼容性時應用。用於涉及數據庫結構更改、索引創建、約束脩改或數據轉換腳本的任何任務。 來源：microck/ordinary-claude-skills。

查看原文