drizzle

Drizzle ORM schema definitions, type inference, and query patterns for PostgreSQL databases. Location: src/database/schemas/_helpers.ts ID prefixes make entity types distinguishable. For internal tables, use uuid . Always use db.select() builder API. Never use db.query.* relational API ( findMany , findFirst , with: ). The relational API generates complex lateral joins with json_build_array that are fragile and hard to debug. When you need a parent record with its children, use two queries instead of relational with: : See the db-migrations skill for the detailed migration guide. - Enforces snake_case naming (tables plural, columns lowercase), helper functions for timestamps, and ID prefixes for entity type distinction - Provides type inference patterns ( $inferInsert , $inferSelect ) and schema validation via createInsertSchema - Requires db.select() builder API for all queries; explicitly forbids the relational API ( findMany , with: ) due to fragile lateral join generation - Covers common patterns: junction tables with composite keys, explicit JOINs with object selection, aggregations via groupBy , and one-to-many relationships via separate queries - Config: drizzle.config.ts - Schemas: src/database/schemas/ - Migrations: src/database/migrations/ - Dialect: postgresql with strict: true - timestamptz(name) : Timestamp with timezone - createdAt() , updatedAt() , accessedAt()...