drizzle▌

You are an expert in Drizzle ORM, TypeScript, and SQL database design with a focus on type safety and performance.

Expert guide for building type-safe database applications with Drizzle ORM. Covers schema definition, relations, queries, transactions, and migrations for all supported databases.

Migration-first database development workflow using Drizzle ORM for TypeScript/JavaScript projects. \n \n SQL migrations are the single source of truth; always write migrations before TypeScript schema definitions to prevent schema drift across environments \n Includes complete workflow: design SQL migration, generate TypeScript definitions via drizzle-kit, create snapshots, implement schema, organize by domain, and validate in CI/CD \n Covers common patterns for adding columns, creating junctio

neon-drizzle

Automatically generates complete CRUD modules for NestJS applications using Drizzle ORM. Creates all necessary files following the zaccheroni-monorepo patterns: feature modules, controllers, services, Zod-validated DTOs, Drizzle schemas, and Jest unit tests.

Location: src/database/schemas/_helpers.ts

Type-safe PostgreSQL applications with Drizzle ORM, migrations, and performance best practices. \n \n Covers schema design, relational queries, transactions, and drizzle-kit workflows (generate, migrate, push, studio) \n Includes decision trees for modeling relationships, diagnosing slow queries, and choosing the right commands \n Emphasizes critical performance patterns: indexing foreign keys, avoiding N+1 queries with relational APIs, and connection pooling \n Provides anti-pattern warnings fo

Drizzle ORM schema definitions, type inference, and query patterns for PostgreSQL databases. \n \n Enforces snake_case naming (tables plural, columns lowercase), helper functions for timestamps, and ID prefixes for entity type distinction \n Provides type inference patterns ( $inferInsert , $inferSelect ) and schema validation via createInsertSchema \n Requires db.select() builder API for all queries; explicitly forbids the relational API ( findMany , with: ) due to fragile lateral join generati

Generate Drizzle ORM schemas for Cloudflare D1 with D1-specific SQLite patterns and constraints. \n \n Handles D1 quirks: enforced foreign keys, no native BOOLEAN/DATETIME types, 100 bound parameter limit, and JSON stored as TEXT \n Produces schema files, type exports, migration commands, and DATABASE_SCHEMA.md documentation \n Includes bulk insert batching logic and D1 runtime query patterns for Workers \n Reference guides cover D1 vs standard SQLite differences, column type patterns, and migra

Type-safe D1 databases with Drizzle ORM, migrations, and batch API patterns for Cloudflare Workers. \n \n Includes schema definition, Drizzle Kit migrations, relations, and D1-specific batch API for transactions (D1 doesn't support SQL BEGIN) \n Prevents 18 documented errors including transaction failures, cascade data loss, 100-parameter limits, foreign key issues, and nested migration discovery \n Supports dynamic query building, upserts, logging, and Drizzle Studio for visual database browsin