drizzle▌

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

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.

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

neon-drizzle

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

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

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