Database Migration Skill

Create schema changes with proper migrations.

CRITICAL: Never Write Migrations By Hand

ALWAYS use drizzle-kit generate to create migrations. NEVER write SQL migration files manually.

Why this matters:

• Drizzle tracks schema state via snapshot files in drizzle/meta/
• Hand-written migrations don't update snapshots
• This causes drizzle-kit generate to fail with confusing prompts about tables being "created or renamed"
• It breaks the entire migration system for future changes

If you're tempted to write SQL by hand (e.g., for data migrations), create a separate script in scripts/ instead.

Before Starting