drizzle-migrations

SKILL.md

Migration-first database development workflow using Drizzle ORM for TypeScript/JavaScript projects.

SQL migrations are the single source of truth; always write migrations before TypeScript schema definitions to prevent schema drift across environments

Includes complete workflow: design SQL migration, generate TypeScript definitions via drizzle-kit, create snapshots, implement schema, organize by domain, and validate in CI/CD

Covers common patterns for adding columns, creating junction tables, modifying types, and adding constraints with corresponding TypeScript implementations

Provides staging testing checklist, rollback strategy, and troubleshooting guidance for schema drift, migration failures, and type synchronization issues

Drizzle ORM Database Migrations (TypeScript)

Migration-first database development workflow using Drizzle ORM for TypeScript/JavaScript projects.

When to Use This Skill

Use this skill when:

Working with Drizzle ORM in TypeScript/JavaScript projects

Need to create or modify database schema

Want migration-first development workflow

Setting up new database tables or columns

Need to ensure schema consistency across environments

Core Principle: Migration-First Development

Critical Rule: Schema changes ALWAYS start with migrations, never code-first.