drizzle-orm-d1

Status : Production Ready ✅ Last Updated : 2026-02-03 ✅ Use db.batch() for transactions - D1 doesn't support SQL BEGIN/COMMIT (see Issue #1) ✅ Test migrations locally first - Always --local before --remote ✅ Use integer with mode: 'timestamp' for dates - D1 has no native date type ✅ Use .$defaultFn() for dynamic defaults - Not .default() for functions ✅ Set migrations_dir in wrangler.jsonc - Points to ./migrations ❌ Never use SQL BEGIN TRANSACTION - D1 requires batch API ❌ Never use drizzle-kit push for production - Use generate + apply ❌ Never mix wrangler.toml and wrangler.jsonc - Use wrangler.jsonc only Features: Build queries conditionally with .$dynamic() : ⚠️ D1 Upsert Caveat: Target must be a unique column or primary key. This skill prevents 18 documented issues: Error : D1_ERROR: Cannot use BEGIN TRANSACTION Source : Why : Drizzle uses SQL BEGIN TRANSACTION , but D1 requires batch API instead. Prevention : Use db.batch([...]) instead of db.transaction() Error : FOREIGN KEY constraint failed: SQLITE_CONSTRAINT Source : Why : Drizzle uses PRAGMA foreign_keys = OFF; which causes migration failures. Prevention : Define foreign keys with cascading: .references(() => users.id, { onDelete: 'cascade' }) Error : Error: No such module "wrangler" Source : Why : Importing from wrangler package in runtime code fails in production. Prevention : Use import { drizzle } from...