Definition

What is Prisma?

TypeScript-first ORM that lets you define your schema once and get type-safe database queries, automatic migrations, and a visual database GUI.

Prisma is the dominant TypeScript ORM in 2026, used by most Next.js production apps. You declare your data model in a `schema.prisma` file using a clean declarative syntax; Prisma generates a fully-typed client and handles migrations. Query patterns: `prisma.user.findUnique({ where: { id }, select: { name: true } })` — the return type narrows automatically based on your `select`. Supports PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. Prisma Studio (a built-in GUI at `npx prisma studio`) is the easiest way to inspect/edit data during development. Pros: best-in-class TypeScript inference, mature migrations, large community. Cons: ORM overhead can be noticeable on high-cardinality queries (most Next.js apps will never feel this), some N+1 queries until you learn the includes pattern, adds ~10-20 MB to your serverless bundle. For most SaaS use cases in 2026, Prisma is the right default; alternatives like Drizzle ORM and Kysely fit specific perf-sensitive niches.

Learn more

Related terms

See it in action

Try InBuild free — no credit card required.