Lightweight TypeScript ORM that stays close to SQL; schema defined in TypeScript.
Works with AI agents:llms.txtCLIDrizzle 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.
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.
1 tools, from its own code, website and Product Hunt page.
10 makers' products, each linked to the source that shows it, and 136 open-source projects that declare it in their code.
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 ↗
RybbitThe open source Google Analytics replacement“Drizzle kit push is amazing. no need for migrations”
Database Access & ORMsMaker says so · source ↗
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 ↗
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 ↗
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 ↗
WaffleAI website builder“Drizzle ORM makes database interactions easy.”
Database Access & ORMsMaker says so · source ↗
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 ↗“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 ↗
Launch CodeTake 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 ↗
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 ↗Open source: a project that declares Drizzle ORM as a dependency in its public code — verifiable, but not necessarily a live product.
8 makers on why they use Drizzle ORM, in their own words on Product Hunt.
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.
VouchSep 2026 ↗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.
EmailCatcherSep 2026 ↗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.
SonofaSep 2026 ↗Drizzle ORM is amazing. It allows building database queries effortless. Is lightning fast and should be used by every Type Safety projects.
Drizzle allows us to easily manage database migrations and access data in type safe manner. Even our "raw sql only" guy likes it!
FlowsSep 2026 ↗Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.
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. Open a row to see the pull requests.
Prisma → Drizzle ORM140 PRs
Kysely → Drizzle ORM6 PRsDrizzle ORM → Prisma27 PRsDrizzle ORM → Kysely5 PRsDrizzle 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 ↗
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 ↗
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 ↗
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 ↗
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 ↗
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 ↗
Yes — it is free, open-source software.
Open source, and you can self-host it. source ↗
It serves an llms.txt docs index; it has an official CLI (drizzle-kit).
10 makers' products we track, each with a source, and 136 open-source projects declare it in their code. source ↗
Astro
SQLAlchemy
TypeORM
Sequelize