drizzle▌

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

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

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

Type-safe SQL ORM for TypeScript with zero runtime overhead and edge-runtime optimization. \n \n Supports PostgreSQL, MySQL, and SQLite with compile-time type inference from schema definitions; no code generation required \n Includes relational queries, transactions, filtering, joins, pagination, and aggregation with SQL-like syntax \n Drizzle Kit provides schema migrations, introspection, and a built-in database GUI (Drizzle Studio) \n Significantly smaller bundle size (~35KB vs ~230KB) and fas

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

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