Updated
Database Access & ORMs · for Next.js

Database Access & ORMs for Next.js: what 34 makers' products chose

Among 34 makers' products built with Next.js that we know the database access & ORMs of, Prisma leads: 24 of them (71%). Next come Drizzle ORM (10).

Schema-first ORM, SQL-shaped query builder, or the platform's own SDK. A schema-first ORM generates types and migrations from one schema file and hides the SQL; a SQL-shaped ORM or query builder keeps queries close to SQL with full types and a smaller runtime; a backend platform (Supabase, Convex, Firebase) comes with its own client, and adding an ORM on top is often unnecessary.

What makers on Next.js chose

OptionNext.js productsAll makers
PrismaSchema-first ORM24 (71%)74%
Drizzle ORMSQL-shaped ORM10 (29%)24%

Live makers' products with a source for both: that they're built with Next.js, and what they use for database access & ORMs. A product using two options counts in both; not market share. "All makers" is the option's share among every maker's product that made this decision.

Which to pick, by situation

  • You want one schema file that generates types, migrations and a readable query APIPrisma 24 here
  • You deploy to serverless or edge functions and want queries that read like SQL, fully typedDrizzle ORM 10 here

Prisma

Schema-first ORM

24 Next.js products here (71%).

llms.txtMCPCLI

Best forA schema-first ORM with generated types and migrations.

Trade-offA generated client and its own schema language sit between you and SQL; complex queries often drop back to raw SQL.

“Since a year I build all my products with Prisma. It is a huge time saver and I like having the overview in one single file. It's migration just works all the time. Thanks Prisma!”

Makers like
  • Types generated from the schema make queries type-safe, catching data bugs at compile time instead of in production. 3 sources
  • One readable schema file drives migrations that are predictable and rarely break production. 3 sources
Makers watch out for
  • Generated queries can be unexpectedly heavy, causing database spikes and connection latency under concurrent load. 2 sources
  • Postgres extensions like pgvector are poorly supported. 1 source
Next.js products on Prisma
Undead Domains
Undead DomainsShare your unused domains and find new ones

“Skipping on ORMs is peak boomer behavior. It's usually between Drizzle and Prisma, I personally prefer Drizzle but wanted to give Prisma another shot for this project. Prisma has a lot of stuff going for it (e.g. prisma schema files are way cleaner and easier to parse than drizzle's) It sucked for PGVector and doesn't do well with Postgres extensions in general tho, would love if the guys over at Prisma could improve that.”

Database Access & ORMsMaker says so · source ↗
inbox-zero
inbox-zeroOpen-source AI email assistant that triages, labels and drafts replies to help clear you…

“Makes writing type-safe SQL code a joy”

Database Access & ORMsMaker says so +1 · source ↗
Leads Ward
Leads WardStop bad leads with AI-powered form filtering for businesses

“My favourite ORM, by far. Prisma helped me have complete control over an area I wasn't really keen on, databases.”

Database Access & ORMsMaker says so · source ↗
Inventory Mate
Inventory MatePain-Free Inventory Planning, Made For E-Commerce

“I did NOT want to use this at the start... but it admittedly was worth the initial bit of learning. Prisma paired with NoSQL like mongoDB was a gamechanger and has saved countless hours when setting up the backend database tables and managing relationships. I honestly love using prims now.”

Database Access & ORMsMaker says so · source ↗
Indie Hacker Stacks
Indie Hacker StacksSee tech stacks of indie products

“Since a year I build all my products with Prisma. It is a huge time saver and I like having the overview in one single file. It's migration just works all the time. Thanks Prisma!”

Database Access & ORMsMaker says so · source ↗
Cal.com
Cal.comOpen-source scheduling platform: a Calendly alternative you can self-host or use hosted,…

“we are using prisma both for our core cal.com repository but also for our platform starter kit”

Database Access & ORMsMaker says so +1 · source ↗
Hardbook
HardbookThe freelancer booking link that signs the contract for you

“When building a relational tool for bookings and contracts, the schema is everything. Prisma makes managing that schema—and migrations—predictable and safe. Tip: Use Prisma Studio locally during beta testing. It’s the fastest way to verify data states without writing SQL queries. Alternatives: Drizzle is catching up, but Prisma’s DX for managing complex relations is still the standard for me.”

Database Access & ORMsMaker says so · source ↗

All of Prisma: who uses it, alternatives →

Drizzle ORM

SQL-shaped ORM

10 Next.js products here (29%).

llms.txtCLI

Best forA thin, SQL-like TypeScript ORM that runs well on serverless and edge runtimes.

Trade-offCloser to SQL means you need to know SQL, and there are fewer guides and integrations than for Prisma.

“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.”

Makers like
  • It is lightweight and type-safe, and feels straightforward next to bulkier TypeScript ORMs. 2 sources
  • drizzle-kit push speeds prototyping, migrations deploy cleanly, and there is no generated client package to rebuild. 2 sources
Makers watch out for
  • Database features like SQLite STRICT tables and deferrable Postgres constraints stay unsupported for years, pushing some projects off it. 3 sources
  • Its own operator-style query syntax limits what you can express compared with writing SQL, such as full-text search. 2 sources
Next.js products on Drizzle ORM
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 ↗
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 ↗
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 ↗
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 ↗
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 ↗
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 ↗

All of Drizzle ORM: who uses it, alternatives →

Also chosen, and not seen yet

Real options for database access & ORMs not seen among these Next.js products yet: Kysely, SQLAlchemy.

Who switches, and to what

Public GitHub pull requests whose title says "X to Y", by developers in general, not only on Next.js.

  • Prisma → Drizzle ORM 140 pull requests · how they moved
  • Drizzle ORM → Prisma 27 pull requests

Getting database access & ORMs right

Keep every schema change in migrations checked into the repo, and run them in CI or on deploy — never by hand in production. If you're on a backend platform, start with its client and add an ORM only when you outgrow it.

  • Editing tables in the production console instead of writing a migration, so the next deploy's migration fails or silently drops the change.
  • Loading related rows one query at a time in a loop, which feels fine on ten rows and times out on a thousand.
  • Adding an ORM on top of a backend platform's client out of habit, then fighting two sources of truth for types and access rules.

The rest of the Next.js stack

What makers' Next.js products chose for their other decisions, the most common pick for each:

Questions

What do most Next.js apps use for database access & ORMs?

Among 34 makers' products built with Next.js that we know the database access & ORMs of, Prisma leads: 24 of them (71%). Next come Drizzle ORM (10).

How this is counted: a product is on Next.js when a live-product source says so (the maker, its website, a customer story or a subprocessor list), and the same for its database access & ORMs. How evidence is collected.