“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 ↗
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.
Profile checked
Works with AI agents:llms.txtCLIHow 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
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%).
| Option | Makers' products | Open source | |
|---|---|---|---|
| 37 74% | Yes | Compare → | |
| 12 24% | Yes | ||
| 1 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
- 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: Prisma.
- You already write SQL comfortably and only want types around it, no schema layer: Kysely.
- Your backend is Python and not Django: SQLAlchemy.
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
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
| Year | Comments choosing it, per month | Net praise |
|---|---|---|
| 2023 | 0.3 | 0% |
| 2024 | 0.5 | −10% |
| 2025 | 1.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
- [FEATURE]: `CREATE TRIGGER` functions👍 497 · opened Jul 2023 · active Jun 2026
- [FEATURE]: Add a possibility to add a comment on a Table, Column.......👍 207 · opened Jul 2023 · active Sep 2026
- Implement infering table model with relations👍 195 · opened Jun 2023 · active May 2026
- Add proper error handling and wrapping👍 175 · opened Apr 2023 · active Sep 2026
- [FEATURE]: Migration Rollback feature👍 170 · opened May 2024 · active Aug 2026
Who switches
More projects move to Drizzle ORM: 146 pull requests in, 32 out; the most come from Prisma and leave for Prisma.
Prisma → Drizzle ORM140 PRs
- feat(db): migrate ORM from Prisma 7 to Drizzle (zero DDL, behavior parity)laststance/corelive · 2026-09-29
- Migrate from Prisma to Drizzle for schema-per-tenant supportadeel-boson/UPresent · 2026-09-27
- Refactor/prisma to drizzleAmruthaarunachalam/next.js-backend · 2026-09-24
- test(e2e): benchmark and verify the Prisma to Drizzle migration (ENG-2137)Shamiri-Institute/digitalhub · 2026-09-22
- refactor(db): migrate from prisma to drizzle ormcs-esmaeili/lio_back · 2026-09-20
- Migrate jetstream.spec.ts's direct Board query from Prisma to Drizzlemkizka/linkat · 2026-09-19
- feat: migrate from Prisma to Drizzle v1 RC3exKAZUu-Research/trace-dojo · 2026-09-11
- Pr2/prisma to drizzle api jobsusemarble/marble · 2026-09-11
- feat(error-tracker)!: port @context-kit/error-tracker from Prisma to Drizzlequeso/context-kit-packages · 2026-09-11
- switch from the prisma to the drizzle ORMvirtualabishek/24hoursnews · 2026-09-10
Kysely → Drizzle ORM6 PRs
- refactor(api): switch from Kysely and dbmate to Drizzle ORM and drizzle-kityutaasakura96/overload · 2026-09-25
- Add SQL to Kysely generator and upgrade SQL to Drizzle tooldaxt61/multi-tool-site · 2026-09-23
- refactor(db): migrate from kysely to drizzleblinkdisk/blinkdisk · 2026-06-28
- Migrate Playwright tests from Kysely to Drizzle ORM and add CI workflowncrmro/website · 2025-12-24
- Migrate from Kysely to Drizzle ORMncrmro/website · 2025-11-20
- Migrated from Kysely to Drizzle and implemented a Demo modeRaulRohjans/spenser · 2025-08-18
Drizzle ORM → Prisma27 PRs
- feat(db): migrate from Drizzle to Prisma and TypedSQLlaoz40/Horus · 2026-09-17
- Migrate auth (users table) from Drizzle to Prisma, remove Drizzlemouhamed2213/3btrading-erp-crm · 2026-09-08
- Migrate database layer from Drizzle to Prismadinokage/shotgun-mock · 2026-09-07
- Migrated from Drizzle to PrismaAnish-75/backend-exp · 2026-08-20
- chore(backend): migrate drizzle to prisma orm 7jushoo/trade-blotter · 2026-08-20
- feat(drizzle): example application, and two fixes to the prisma example it inherited fromcerbos/query-plan-adapters · 2026-08-10
- ORM migration from Drizzle to Prismaungdev/Integration · 2026-07-06
- refactor: migrate database ORM from Drizzle to Prismajohn-data-chen/sveltekit-starter-kit · 2026-06-12
- refactor(db): migrate ORM from Drizzle to Prismainnovationtreehouse/apps.arbor · 2026-06-09
- feat: Migrate from Drizzle ORM to Prisma 7fatkquladhim/ClassMe · 2026-02-05
Drizzle ORM → Kysely5 PRs
- migration: drizzle to kysely, slim down to data APIdvgamerr-app/aide-collector · 2026-06-17
- refactor(db): switch from drizzle to kysely + atlasponti-studios/hominem · 2026-03-07
- feat: migrate hono example from Drizzle to KyselyAndrey-jpeg/goodie · 2026-03-01
- feat: migrate hono example and docs from Drizzle to KyselyAndrey-jpeg/goodie · 2026-03-01
- refactor!: change drizzle to kysely for internal querieswannabespace/conar · 2025-11-14
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.
“Drizzle kit push is amazing. no need for migrations”
Database Access & ORMsMaker says so · source ↗“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 ↗“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 ↗“We love Drizzle + SQLite for keeping notes on-device and our data code straightforward!”
Database Access & ORMsMaker says so · source ↗“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 ↗“Drizzle ORM makes database interactions easy.”
Database Access & ORMsMaker says so · source ↗“Huge shoutout to DrizzleORM, made it easier to work with complex queries.”
Database Access & ORMsMaker says so · source ↗“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 ↗“Drizzle makes my serverless database handling easy. It's as fast as Prisma!”
Database Access & ORMsMaker says so · source ↗“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 ↗None of these in makers' own words.
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:
Named as the ORM paired with PostgreSQL, sometimes on Neon.10 files
Keep Drizzle schemas and migrations in a dedicated shared database package or directory.7 files
Query through Drizzle rather than raw SQL, and use it exclusively as the ORM.4 files
Drizzle also fronts lightweight SQLite-style stores such as D1, Turso and expo-sqlite.3 files
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.
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 ↗