Drizzle ORM TypeSafe Database Access

Lightweight, headless TypeScript ORM with zero dependencies. Drizzle excels at:

• Type inference — Full TypeScript types from schema; no generated types or separate schema language
• Relational queries — Fetch nested data with .with() without manual joins
• Prepared statements — Pre-compile queries for repeated execution; significant performance boost
• Migrations — Version-controlled schema changes with drizzle-kit; rollback support
• Transactions — Atomic multi-operation commits with savepoints for nested transactions

Core patterns: one table per file, relational API for nested queries, prepared statements for hot paths, transactions for consistency.

Workflow

When working with Drizzle ORM: