drizzle-migrations

Migration-first database development workflow using Drizzle ORM for TypeScript/JavaScript projects. Use this skill when: Critical Rule : Schema changes ALWAYS start with migrations, never code-first. ❌ WRONG : Writing TypeScript schema first ✅ CORRECT : Write SQL migration first Create descriptive SQL migration file: Naming Convention : Drizzle Kit generates TypeScript types from SQL: What This Creates : Snapshots enable schema drift detection: Snapshots in Version Control : Now write TypeScript schema that mirrors SQL migration: Key Points : Structure schemas for maintainability: index.ts (export all): school/index.ts : Validate schema consistency in CI/CD: CI Checks Explained : Before production, test migration on staging: Staging Checklist : TypeScript: TypeScript: TypeScript: Apply rollback: Error : Schema drift detected Solution : Error : Migration fails with data constraint violation Solution : Error : TypeScript types don't match database Solution : - 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...