drizzle-orm
Installation
SKILL.md
Drizzle ORM — schema as code, type-safe queries, drizzle-kit migrations
Drizzle is the SQL-transparent TypeScript ORM: you declare tables in plain .ts, the query
builder emits SQL you can read, and there is no codegen client to regenerate. It runs in
edge/serverless runtimes. You own the schema, the queries, and the drizzle-kit workflow here —
the database engine, the ORM-agnostic migration strategy, and Prisma live in sibling skills.
Decide first
Three decisions before you write a line. Each branches, so use the table.
| Decision | Pick | Why |
|---|---|---|
| Drizzle vs Prisma | Drizzle when you want SQL you can read, no codegen step, edge runtime | Prisma's generated client + schema.prisma DSL is the opposite trade — use ../prisma-orm/SKILL.md if that is the ask |
| Version | 0.45.x + drizzle-kit@0.31.x for production |
npm latest is drizzle-orm@0.45.2; the 0.45 line has been latest since 2025-12-04 (checked 2026-06-02) |
| Version | 1.0.0-rc.x (npm rc tag = 1.0.0-rc.3, 2026-05-18) for a NEW edge-first project |
v1 has moved past beta into release candidates with Relations v2 — close to stable, but still pin an exact rc and expect late API churn |
| Driver entrypoint | match it to your DB/host (see below) | Each driver has its own drizzle-orm/<driver> import and its own client |