back
loading skill details...
|
Type-safe D1 databases with Drizzle ORM, migrations, and batch API patterns for Cloudflare Workers. Includes schema definition, Drizzle Kit migrations, relations, and D1-specific batch API for transactions (D1 doesn't support SQL BEGIN) Prevents 18 documented errors including transaction failures, cascade data loss, 100-parameter limits, foreign key issues, and nested migration discovery Supports dynamic query building, upserts, logging, and Drizzle Studio for visual database browsing Critical D1 rules: use db.batch() for transactions, test migrations locally first, use integer with mode: 'timestamp' for dates, chunk bulk inserts under 100 parameters Drizzle ORM for Cloudflare D1 Status: Production Ready ✅ Last Updated: 2026-02-03 Commands Command Purpose /db-init Set up Drizzle ORM with D1 (schema, config, migrations) /migrate Generate and apply database migrations /seed Seed database with initial or test data Latest Version: drizzle-orm@0.45.1, drizzle-kit@0.31.8, better-sqlite3@12.5.0 Dependencies: cloudflare-d1, cloudflare-worker-base Quick Start (5 Minutes)
don't have the plugin yet? install it then click "run inline in claude" again.