数据与分析
create-migration
Create a new database migration following project naming and safety rules. Use when the user asks to add a migration or create a migration for a schema change.
girijashankarj · 已有 AI 审核记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add girijashankarj/cursor-handbook --skill create-migration技能说明
name: create-migration description: Create a new database migration following project naming and safety rules. Use when the user asks to add a migration or create a migration for a schema change.
Skill: Create migration
Trigger
When the user asks to add a migration, create a migration for a schema change, or "migrate the DB."
Steps
- Clarify — Confirm the change (new table, new column, index, constraint); ensure backward compatible where possible.
- Naming — Use format
YYYYMMDDHHMMSS_descriptive_action.sql(or project equivalent). - UP — Write the forward migration (ADD COLUMN with default, CREATE INDEX CONCURRENTLY where supported).
- DOWN — Write the rollback; test that DOWN reverts UP cleanly.
- Review — No raw DELETE; use soft delete if needed; parameterized only; add index for new FK/filters.
If a step fails
| Step | Failure | Recovery |
|---|---|---|
| Step 4 | DOWN does not revert UP cleanly | Fix DOWN to match UP; test both directions; document manual steps if schema change is irreversible |
| Step 5 | Review finds unsafe patterns | Rewrite migration; no raw DELETE; use soft delete; add defaults for new columns |
Rules
- Follow
.cursor/rules/database/migration-rules.mdcand schema-design rules. - Every table must have id, created_at, updated_at, and soft-delete column per project config.