create-migration
starsforks
How to install create-migration?
girijashankarj/cursor-handbook/create-migration
$npx -y skills add girijashankarj/cursor-handbook --skill create-migrationCreate 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.md
| 1 | # Skill: Create migration |
| 2 | |
| 3 | ## Trigger |
| 4 | When the user asks to add a migration, create a migration for a schema change, or "migrate the DB." |
| 5 | |
| 6 | ## Steps |
| 7 | |
| 8 | 1. **Clarify** — Confirm the change (new table, new column, index, constraint); ensure backward compatible where possible. |
| 9 | 2. **Naming** — Use format `YYYYMMDDHHMMSS_descriptive_action.sql` (or project equivalent). |
| 10 | 3. **UP** — Write the forward migration (ADD COLUMN with default, CREATE INDEX CONCURRENTLY where supported). |
| 11 | 4. **DOWN** — Write the rollback; test that DOWN reverts UP cleanly. |
| 12 | 5. **Review** — No raw DELETE; use soft delete if needed; parameterized only; add index for new FK/filters. |
| 13 | |
| 14 | ## If a step fails |
| 15 | |
| 16 | | Step | Failure | Recovery | |
| 17 | |------|---------|----------| |
| 18 | | Step 4 | DOWN does not revert UP cleanly | Fix DOWN to match UP; test both directions; document manual steps if schema change is irreversible | |
| 19 | | Step 5 | Review finds unsafe patterns | Rewrite migration; no raw DELETE; use soft delete; add defaults for new columns | |
| 20 | |
| 21 | ## Rules |
| 22 | - Follow `.cursor/rules/database/migration-rules.mdc` and schema-design rules. |
| 23 | - Every table must have id, created_at, updated_at, and soft-delete column per project config. |
People who liked this also viewed
6 picksType
- azure-storageAzure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and Data Lake. Answers questions about storage access tiers (hot, cool, cold, archive), when to use each tier,SkillsJul 2026
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.SkillsJul 2026
- supabaseUse when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, SkillsJul 2026
- convex-quickstartCreates or adds Convex to an app. Use for new Convex projects, npm create convex@latest, frontend setup, env vars, or the first npx convex dev run.SkillsJul 2026
- convex-performance-auditAudits Convex performance for reads, subscriptions, write contention, and function limits. Use for slow features, insights findings, OCC conflicts, or read amplification.SkillsJul 2026
- convex-setup-authSets up Convex auth, identity mapping, and access control. Use for login, auth providers, users tables, protected functions, or roles in a Convex app.SkillsJul 2026
