Db Migration

DB Migration (OTW)

Scope

Use this skill for any change touching:

• src/db/schema.ts
• drizzle/*.sql
• drizzle/meta/*
• migration apply commands (drizzle:migrate:*)

Procedure

1. Update schema definitions in src/db/schema.ts.
2. Choose migration mode:
   • schema diff: pnpm drizzle:generate
   • custom data migration: pnpm drizzle:generate:custom
3. Review generated SQL for destructive or unexpected statements.
4. Apply locally with pnpm drizzle:migrate:local.
5. Validate affected API and UI behavior.
6. Apply remotely with pnpm drizzle:migrate:remote only after local validation.
7. Commit schema and migration artifacts together.

Safety Rules