Drizzle ORM — TypeScript SQL That Feels Like SQL

Overview

Drizzle is a TypeScript ORM with no runtime query engine: the schema is plain TypeScript, queries compile to SQL strings, and result types are inferred from the schema. It supports PostgreSQL, MySQL, SQLite and SingleStore families, including serverless drivers (Neon, Turso/libSQL, Cloudflare D1, PGlite). Two query styles exist side by side: the SQL-like builder (db.select().from()) and the relational API (db.query.users.findMany({ with })).

drizzle-orm (runtime) and drizzle-kit (CLI for migrations and Studio) are versioned separately. This skill covers the stable line, drizzle-orm@0.45 and drizzle-kit@0.31. A 1.0 release candidate is published under the rc npm tag (it changes the relational API, "RQB v2"); do not install it unless the project already uses it.

Instructions

Install

npm install drizzle-orm pg
npm install -D drizzle-kit tsx @types/pg
# other drivers: mysql2, better-sqlite3, @libsql/client, @neondatabase/serverless, @electric-sql/pglite

Schema