How it works
Tables are defined in TypeScript files, and queries use functions that mirror SQL (select, from, where, join), so anyone who knows SQL can read them. Types flow from the table definitions into every result. drizzle-kit generates and runs migrations from those definitions.
It has no separate engine and very few dependencies, so it runs well in serverless and edge environments such as Cloudflare Workers and Vercel Edge. It supports PostgreSQL, MySQL and SQLite, including hosted flavours such as Neon, Turso and PlanetScale.
Drizzle ORM pros and cons
Pros
- Queries read like SQL, so there is little new to learn
- Small and fast, good on edge and serverless runtimes
- Strong types without a code generation step
Cons
- Younger than Prisma, with fewer guides and integrations
- You need to know SQL to use it well
When to use Drizzle ORM
Pick it when
- TypeScript apps on serverless or edge runtimes
- Developers who like SQL and want types on top of it
Skip it when
- A team that would rather not think in SQL at all
Drizzle ORM pricing
Drizzle ORM vs the alternatives
Related terms
More in Databases and storage
Talking to a database