Updated

Drizzle ORM

Lightweight TypeScript ORM that stays close to SQL; schema defined in TypeScript.

12 makers' products we track use Drizzle ORM. For database access & ORMs it's 2nd most chosen of 3 options: 12 of the 50 makers' products we know the database access & ORMs of (24%). 152 open-source projects also declare it in their code. What makers like most: It is lightweight and type-safe, and feels straightforward next to bulkier TypeScript ORMs. Their most common complaint: Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it. On GitHub, 146 public pull requests moved projects to Drizzle ORM from tools we list, and 32 moved them away.

Open sourceSelf-hostableFree tier

Profile checked

Works with AI agents:llms.txtCLI
Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

How makers use Drizzle ORM

Makers' products we track use Drizzle ORM for database access & ORMs (12), most often alongside Next.js (83%), Vercel (42%), Resend (42%).

What Drizzle ORM is used for

Database Access & ORMs · SQL-shaped ORM →A thin, SQL-like TypeScript ORM that runs well on serverless and edge runtimes.Trade-off: Closer to SQL means you need to know SQL, and there are fewer guides and integrations than for Prisma.
Prisma37Drizzle ORM12SQLAlchemy1Kysely0TypeORM0Makers' products on each, for database access & ORMs

Drizzle ORM vs the alternatives makers chose

For database access & ORMs, 12 of the 50 makers' products we know the choice of picked Drizzle ORM (24%), behind Prisma (74%).

OptionMakers' productsOpen source
Prisma37 74%YesCompare →
Drizzle ORM12 24%Yes
SQLAlchemy1 2%Yes

For database access & ORMs: how many of the 50 makers' products we know the database access & ORMs of chose each option.

Often paired with

Share of the 12 makers' products on Drizzle ORM that show this choice.

When to use Drizzle ORM, and when not

Pick Drizzle ORM if

Something else fits better if

  • You want one schema file that generates types, migrations and a readable query API: Prisma.
  • You already write SQL comfortably and only want types around it, no schema layer: Kysely.
  • Your backend is Python and not Django: SQLAlchemy.
From each decision's guide, written from what makers' products chose and why.

Drizzle ORM is a TypeScript library for working with SQL databases. You get typed queries without a separate schema language or code generator. Tables are declared as ordinary TypeScript, and queries read almost like the SQL they produce.

More about Drizzle ORM

There are two layers. The core is a SQL-like query builder (select, insert, joins, subqueries) that maps closely to the generated SQL; the Queries API on top fetches nested relations and, according to the docs, always compiles to exactly one SQL statement. Drizzle has no dependencies of its own and talks to the database through the standard driver you choose, with support for PostgreSQL, MySQL, SQLite, SingleStore, SQL Server and CockroachDB and hosted options such as Neon, Supabase, PlanetScale, Turso and PGlite.

Migrations come from the companion CLI, Drizzle Kit. It can generate SQL migration files from changes to your TypeScript schema and apply them (generate and migrate), push the schema straight to the database for fast iteration (push), or introspect an existing database into a TypeScript schema (pull). It also ships Drizzle Studio for browsing data, seeding helpers, and generators for Zod, Valibot and other validation schemas. Everything runs inside your app; there is no hosted service.

Limits: because the API stays close to SQL, you need to know SQL to use it well. The project is moving to v1.0 (currently a release candidate), which restructures the migrations folder, rewrites Drizzle Kit's snapshot format and introduces Relational Queries v2, so existing projects face an upgrade step.

How Drizzle ORM itself is built

1 tools, from its own code, website and Product Hunt page.

Drizzle ORM pros and cons

What makers like most: It is lightweight and type-safe, and feels straightforward next to bulkier TypeScript ORMs. Their most common complaint: Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it.

Pros

  • It is lightweight and type-safe, and feels straightforward next to bulkier TypeScript ORMs. PHHN
  • drizzle-kit push speeds prototyping, migrations deploy cleanly, and there is no generated client package to rebuild. PHHN
  • It works well with serverless and edge databases such as Neon, Cloudflare D1 and PGlite. PHHNHN 2
  • Newer coding agents now default to it when choosing a JavaScript ORM. HNHN 2

Cons and watch-outs

  • Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it. HNHN 2HN 3
  • Its own operator-style query syntax limits what you can express compared with writing SQL, such as full-text search. HNHN 2

Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.

5.0★ from 11 reviews on Product Hunt ↗

What Hacker News says about Drizzle ORM

On Hacker News, 16% of comments about Drizzle ORM recommend it and 7% criticize it: net praise +10%, 3rd best liked of 4 tools HN discusses for database access & ORMs.

By year

YearComments choosing it, per monthNet praise
20230.30%
20240.5−10%
20251.3+19%
2026 (8 mo)2.4+14%

In their words

  • “lately I've been happy with Drizzle for TS. It's very performant and expressive.” HN, Jul 2026
  • “Something like oRPC + Drizzle that lets you pipe data from your database to frontend with full typing” HN, Mar 2026
  • “I quickly hit several limitations of Drizzle and I abandonned the project.” HN, Apr 2026

Hacker News comments January 2023 to August 2026 that name Drizzle ORM in a sentence like "I use" or "we moved to", Claude read a sample of 64 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.

Reliability and open issues

The most wanted open issue on GitHub has 497 👍.

Most wanted on GitHub

Open on 2026-10-04 in drizzle-team/drizzle-orm, with activity in the last year — issues and feature requests by 👍.

Who switches

More projects move to Drizzle ORM: 146 pull requests in, 32 out; the most come from Prisma and leave for Prisma.

Moving to Drizzle ORMMoving away
Drizzle ORM
Prisma → Drizzle ORM140 PRs
Kysely → Drizzle ORM6 PRs
Drizzle ORM → Prisma27 PRs
Drizzle ORM → Kysely5 PRs

Public pull requests on GitHub since Oct 2024 whose title says "X to Y" — real code changes moving a project from one tool to another, by developers in general.

Who uses it

12 makers' products, each linked to the source that shows it, and 152 open-source projects that declare it in their code. The best known on Product Hunt: SnowSEO (1,033 followers), Rybbit (1,023 followers), Fuser (487 followers), Vouch (321 followers), EmailCatcher (307 followers). 1 of the makers' products is gone now (domain lapsed, up for sale or taken down); it chose Drizzle ORM while live.

The maker says so 11Job posting 1Declared in code 153How evidence is collected →
Dokploy
DokploySelf-hostable deployment platform for applications and databases across multiple servers…

“Drizzle ORM has been a game-changer for Dokploy. As a developer focused on efficient and reliable data handling, Drizzle's seamless integration into my workflow.”

Database Access & ORMsMaker says so +1 · source ↗
Vouch
VouchBetter than your ATS, meet your hiring assistant

“The best and most dev friendly ORM we've used. We actually started on prisma, but their `migrate dev` functionality started to take minutes per deployment. Drizzle helps you avoid it, and locally their `push` functionality is great for rapid prototyping, and their `migrate` and `deploy` function works flawlessly. Also it does not require generating a local package, just an amazing developer experience. I hope to donate when the company gets a bit more revenue hehe.”

Database Access & ORMsMaker says so · source ↗
Sonofa
SonofaTransform your reading into listening with AI

“Drizzle ORM challenges MongoDB's schema-less claim. Schemas are beneficial, provided there's an effective solution for schema delta generation and migration scripts. Drizzle ORM did it.”

Database Access & ORMsMaker says so · source ↗
OpenWhispr
OpenWhispr100% local open source AI speech-to-text model

“We love Drizzle + SQLite for keeping notes on-device and our data code straightforward!”

Database Access & ORMsMaker says so · source ↗
Flows
FlowsThe better way to build product adoption

“Drizzle allows us to easily manage database migrations and access data in type safe manner. Even our "raw sql only" guy likes it!”

Database Access & ORMsMaker says so · source ↗
SnowSEO
SnowSEORank #1 in search & AI, while you sleep

“Huge shoutout to DrizzleORM, made it easier to work with complex queries.”

Database Access & ORMsMaker says so · source ↗
EmailCatcher
EmailCatcherEmail collection box for your website.

“I prefer Drizzle ORM because it’s lightweight and focuses on type safety with TypeScript. It’s a lot easier to use than bulkier ORMs, and it gives me confidence that I won’t run into unexpected runtime errors.”

Database Access & ORMsMaker says so · source ↗
Launch Code
Launch CodeGone · domain no longer exists, Oct 2026Take Control of Your Course Revenue | a nextjs boilerplate

“Drizzle makes my serverless database handling easy. It's as fast as Prisma!”

Database Access & ORMsMaker says so · source ↗
Penify
PenifyBlog platform for everyone. Create your own blog effortless.

“Drizzle ORM is amazing. It allows building database queries effortless. Is lightning fast and should be used by every Type Safety projects.”

Database Access & ORMsMaker says so · source ↗
dory
doryAI-native SQL client for humans and agents. Query, explore, visualize, and open agent da…Database Access & ORMsIn its code · source ↗
Dyad
DyadFree, open-source desktop AI app builder for macOS, Windows and Linux that runs locally…Database Access & ORMsIn its code · source ↗
elmo
elmoOpen-source Answer Engine Optimization (AEO) and Generative Engine Optimization (GEO) pl…Database Access & ORMsIn its code · source ↗
evlog
evlogDigging through logs is not observability. It's hope — wide events, structured errors, T…Database Access & ORMsIn its code · source ↗
nao
nao👾 nao is an open source analytics agent. (1) Create context with nao-core cli, (2) depl…Database Access & ORMsIn its code · source ↗

Open source: a project that declares Drizzle ORM as a dependency in its public code — verifiable, but not necessarily a live product.

What its projects tell coding agents

What open-source projects' AGENTS.md and CLAUDE.md files say about Drizzle ORM, in our words — from the 20 files that name it:

83 of the 107 open-source products built with Drizzle ORM that were worked on in the last 180 days keep instruction files for coding agents — 78%, against 53% of all the projects we read. AGENTS.md is in 77, CLAUDE.md in 48.

1,038words in the median file
pnpmthe package manager most named, in 31 of 78 files
67%say how to test a change
Named more in these files than in other projects' — in how many of the 78:
What AGENTS.md files say about other tools →What open-source products tell their coding agents →

Alternatives to Drizzle ORM

All alternatives by situation →

Questions makers ask about Drizzle ORM

Is Drizzle ORM good for production?

12 makers' products we track run on it, and 1 of them have since gone (the product, not necessarily because of Drizzle ORM). On GitHub, 146 public pull requests moved projects to Drizzle ORM from tools we list, and 32 moved them away. The watch-out makers raise most: Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it.

What is Drizzle ORM used for?

Lightweight TypeScript ORM that stays close to SQL; schema defined in TypeScript. Makers' products we track use it for database access & ORMs (12).

What are the pros and cons of Drizzle ORM?

Pros makers name: It is lightweight and type-safe, and feels straightforward next to bulkier TypeScript ORMs. drizzle-kit push speeds prototyping, migrations deploy cleanly, and there is no generated client package to rebuild. It works well with serverless and edge databases such as Neon, Cloudflare D1 and PGlite. Cons: Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it. Its own operator-style query syntax limits what you can express compared with writing SQL, such as full-text search.

What are the alternatives to Drizzle ORM?

For database access & ORMs, the other options makers' products we track chose most are Prisma (37), SQLAlchemy (1). Open source or self-hostable among them: Prisma, SQLAlchemy. Each alternative, with the situation it fits, is on the Drizzle ORM alternatives page.

Do developers switch to or away from Drizzle ORM?

On GitHub, 146 public pull requests moved projects to Drizzle ORM from tools we list, most from Prisma (140), Kysely (6); 32 moved them away, most to Prisma (27), Kysely (5).

When should you use Drizzle ORM?

You deploy to serverless or edge functions and want queries that read like SQL, fully typed (database access & ORMs). Something else fits better if: you want one schema file that generates types, migrations and a readable query API, pick Prisma; you already write SQL comfortably and only want types around it, no schema layer, pick Kysely.

Which databases and drivers does Drizzle support?

Drizzle works through standard drivers for PostgreSQL, MySQL, SQLite, SingleStore, SQL Server and CockroachDB, with guides for providers such as Neon, Supabase, PlanetScale, Turso, PGlite, Bun SQL and Netlify Database. source ↗

Do I have to write migrations by hand?

No. Drizzle Kit can generate SQL migration files from your schema and apply them, push schema changes directly to the database, or pull an existing database's schema into TypeScript, so it fits both code-first and database-first workflows. source ↗

Is drizzle-kit push safe to use in production?

The docs call push the best approach for rapid prototyping, and note that many teams and solo developers use it as their main migration flow in production. Teams that want reviewable history use generated SQL files instead. source ↗

How do I load related rows without writing joins?

Use the relational Queries API, which returns nested related data without manual joins or mapping and, according to Drizzle, always runs exactly one SQL query. source ↗

What changes when upgrading to Drizzle v1?

Running drizzle-kit up converts the migrations folder to a new per-migration layout; Drizzle Kit moves to DDL snapshots with checks for conflicting migrations across branches, and relational queries move to v2 with a new relations definition. source ↗

Can I use an existing database with Drizzle?

Yes. drizzle-kit pull introspects the database and writes the matching Drizzle schema in TypeScript, so you can keep managing the schema with your existing tools. source ↗

Is Drizzle ORM free?

Yes — it is free, open-source software.

Is Drizzle ORM open source or self-hostable?

Open source, and you can self-host it. source ↗

Can AI coding agents work with Drizzle ORM?

It serves an llms.txt docs index; it has an official CLI (drizzle-kit).

Who uses Drizzle ORM?

12 makers' products we track, each with a source, and 152 open-source projects declare it in their code. The best known of them on Product Hunt: SnowSEO (1,033 followers), Rybbit (1,023 followers), Fuser (487 followers), Vouch (321 followers), EmailCatcher (307 followers). source ↗