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。

查看原文