drizzle-orm

name	drizzle-orm
description	Use when: define type-safe schemas, migrations, and queries with Drizzle ORM and full TS inference.

Goal: end-to-end type safety from schema to query result.

Use for:

• modeling tables, relations, and constraints in TypeScript
• generating and applying migrations safely
• writing queries with inferred result types

Workflow:

1. Define tables and columns in the schema with explicit types.
2. Declare relations for type-safe joins and nested reads.
3. Generate migrations from the schema; review the SQL.
4. Apply migrations through the migrator, not ad hoc edits.
5. Query with the typed builder; let result types infer.
6. Derive insert/select types from the schema for app code.

Patterns:

• single source of truth: the schema drives types and migrations
• relations for typed joins instead of manual mapping
• prepared statements for hot queries
• transactions for multi-step writes

Rules:

• never hand-edit applied migrations; create a new one
• review generated SQL before running it
• derive types from the schema; do not duplicate them
• scope transactions tightly around the related writes