Prisma ORM
One schema. Every query type-safe.
Define your data model once, and Prisma ORM generates a typed client where every query, migration and type is checked against it.
Works with Postgres, MySQL, SQLite, MongoDB and more.
- Autocomplete over your own models, and mistakes caught before they ship
- Migrations that refuse to run when they would destroy data
- Free, open source, trusted by 500K+ developers
generator client {
provider =
}
model User {
id String @id @default(cuid())
email String @unique
DateTime
posts Post[]
}
model Post {
String @id
author User @relation
}
Schema valid
Without a typed schema, your data layer is guesswork
When your data model lives across loosely-typed files and hand-written SQL, mismatches surface at runtime instead of in your editor, and nothing can check a change against the schema before it runs. That is true when you write the change, and it is far more dangerous when an agent does.
Prisma ORM exists to change that.
One schema your whole stack reads
Every query checked before it ships
Migrations that refuse to destroy data
The same client over any database
A schema your whole stack reads
Your data model is written once and read everywhere: by you, by your agent, and by every other Prisma product.
1model User {
2id String @id
3email String @unique
4posts Post[]
5}
6model Post {
7id String @id
8author User @relation
9 Boolean
10}
Declarative schema
Define your data model in one dense, machine-readable file. Easy for you to scan, easy for your agent to parse and edit reliably.
const users = await
db.user.findMany(
where
select
include
)
users: User[]
Type-safe client
A fully typed query client generated from your schema. Autocomplete everywhere, and mistakes caught before they ship instead of in production.
$prisma db execute--json
{
"code":P2002
"meta": { }
"message":
"remediation":
}
Built for agents, not just humans
Errors carry stable codes, structured details, and remediation hints. Your agent reads what went wrong and fixes it, through a clean CLI and Management API.
Migrations your agent can run without breaking production
Migrations are where agentic development gets dangerous — it's the moment an agent can alter or delete data irrecoverably. Prisma makes them safe to delegate.
Change your models and Prisma generates the migration in TypeScript you can read and edit, not SQL you have to decipher. Every step is verified before and after it runs, and the result must match your schema to be applied.
Because life is rarely a straight line, migrations are tracked as a graph, like git: roll back, branch, and named refs point at multiple environments. Your agent drives the whole lifecycle through a predictable CLI — plan, apply, inspect — without ever hand-writing SQL, and never "drop the database and start over."
- 20260703091500_init
- 20260709142233_add_users
- 20260715103010_add_sessions
- 20260721164512_add_posts
- 20260726093214_add_indexesproduction
- 20260729111045_add_tags
- 20260730093214_index_tags
- 20260730101422_add_commentspreview
Fast feedback makes your agent faster, and more reliable
Prisma ORM is built to give your agent feedback at every step so it can iterate to success without human intervention. The more feedback it gets from its environment, and the sooner it gets it, the fewer attempts it takes to reach correct, verified code.
$prisma migrate plan
schema drift detectedrejected
schema.prismaedited
$prisma migrate plan
verified· schema in sync
Expert from the first prompt
Setting up a project installs the Prisma skills for your coding agent, so it knows the right patterns before it writes a line.
The type system catches mistakes instantly
Every query is checked against your schema before it ships. Wrong column, wrong type, missing relation — your agent finds out instantly, not in production.
Errors built to be read by agents
When something fails at runtime, the error carries a stable code, structured details, and remediation hints. Your agent reads what went wrong and fixes it.
Guardrails before anything touches your data
Queries and migrations are verified against your schema before execution. A drifted schema or an invalid plan is rejected up front, with an error that says why.
Built to work with the rest of Prisma
The schema you write for the ORM is the same schema your database and hosting read. Adopt the ORM and you've already laid the foundation for the rest of the stack, with no rework when you're ready to expand.
Best together. Swappable when needed.
Swap any layer. It still works.
Everything wired for you: one config, per-PR branching across app and database, and no network hop between them.
Trusted by 500K+ TypeScript developers
“Prisma makes database management incredibly easy. Prisma's built-in type safety helps us avoid mistakes that happen with manual setups.”
“We chose Prisma because it provides us with type safety directly from the database. It has helped us tremendously to catch possible errors early on.”
“We are able to take advantage of caching to speed up queries and reduce latency, making them lightning fast.”
Blake CarrollCTO, Solin“Prisma is the best ORM I have ever used, I never want to use anything else again. The excellent developer experience with its incredible TypeScript support sold me at first.”
“Prisma has a low learning curve. Productivity becomes higher because it gets combined with end-to-end type-safety using TypeScript.”
Ricardo AlmeidaSoftware Engineer, Grover“Prisma has been an absolute game changer for Memberstack. It has helped us move faster while also improving product stability.”
“Prisma makes database management incredibly easy. Prisma's built-in type safety helps us avoid mistakes that happen with manual setups.”
“We chose Prisma because it provides us with type safety directly from the database. It has helped us tremendously to catch possible errors early on.”
“We are able to take advantage of caching to speed up queries and reduce latency, making them lightning fast.”
Blake CarrollCTO, Solin“Prisma is the best ORM I have ever used, I never want to use anything else again. The excellent developer experience with its incredible TypeScript support sold me at first.”
“Prisma has a low learning curve. Productivity becomes higher because it gets combined with end-to-end type-safety using TypeScript.”
Ricardo AlmeidaSoftware Engineer, Grover“Prisma has been an absolute game changer for Memberstack. It has helped us move faster while also improving product stability.”
“We've proudly built the core of our APIs on top of Prisma, and we are very happy that we did. It doesn't make us jump through unnecessary hoops to get normal work done and generally just works.”
“Prisma's approach to type-safe ORM is next-level. It provides full type-safety without any codegen or messy types and interfaces to write and maintain.”
Pieter VenterSr. Software Engineer, Invisible“Prisma is a professional enterprise-ready tool that is easy to start using, ramp up and scale. It is the type of tool developed for the software engineers of today.”
“The combination of Prisma, TypeScript and our pretty thorough coverage with integration tests gives us the confidence to refactor critical parts of our code.”
Thibaut NguyenCTO, Poppy“I chose Prisma because of its clean API, nice developer experience and type safety. It helped me ship v1 of Instatus really fast.”
“This is the fastest I've ever developed in my life, by far. The tooling has dramatically cut down on the amount of time I've had to spend.”
Sean EmmerCTO & Co-Founder, Pearly Plan“We've proudly built the core of our APIs on top of Prisma, and we are very happy that we did. It doesn't make us jump through unnecessary hoops to get normal work done and generally just works.”
“Prisma's approach to type-safe ORM is next-level. It provides full type-safety without any codegen or messy types and interfaces to write and maintain.”
Pieter VenterSr. Software Engineer, Invisible“Prisma is a professional enterprise-ready tool that is easy to start using, ramp up and scale. It is the type of tool developed for the software engineers of today.”
“The combination of Prisma, TypeScript and our pretty thorough coverage with integration tests gives us the confidence to refactor critical parts of our code.”
Thibaut NguyenCTO, Poppy“I chose Prisma because of its clean API, nice developer experience and type safety. It helped me ship v1 of Instatus really fast.”
“This is the fastest I've ever developed in my life, by far. The tooling has dramatically cut down on the amount of time I've had to spend.”
Sean EmmerCTO & Co-Founder, Pearly PlanStart with the ORM. Keep everything else within reach.
Prisma ORM is part of a TypeScript stack built to work together end-to-end. Adopt the ORM today and the rest of the platform clicks in when you're ready, with no schema rework.
- Free and open source, your schema is yours forever
- Add a database and hosting when you're ready, with no rework
- The TypeScript stack 500K+ developers already trust