Next-generation Node.js and TypeScript ORM

Prisma unlocks a new level of developer experience when working with databases thanks to its intuitive data model, automated migrations, type-safety & auto-completion.

Quickstart Playground

30k+Stars on GitHub

250k+Active developers

“Our setup with Prisma enabled us to generate everything from code and ensure our developers can iterate very quickly.”

Lasse AbelsenDevOps Engineer at Tryg

“The flexibility of moving fast and changing the product based on user feedback fast was crucial”

Serghei GhidoraTech Lead at Elsevier

“Prisma helps us unify data access from multiple enterprise systems into a single API. It means we can move very quickly whilst staying flexible.”

Tom HutchinsonHead of Mobile at Rapha

Prisma schema

Data model you can read

The Prisma schema is intuitive and lets you declare your database tables in a human-readable way — making your data modeling experience a delight. You define your models by hand or introspect them from an existing database.

Learn more about Prisma Schema

Supported Languages

JavaScript

TypeScript

Prisma in your stack ->

Prisma in your stack ->

Prisma Client

Type-safe database client

Prisma Client is a query builder that’s tailored to your schema. We designed its API to be intuitive, both for SQL veterans and developers brand new to databases. The auto-completion helps you figure out your query without the need for documentation.

Explore Prisma Client Playground

Extra ergonomy in VS Code

Auto-completion, linting, formatting and more help Prisma developers in VSCode stay confident and productive.

Download Prisma VSCode Extension ->

Make fewer errors with TypeScript

Prisma provides the strongest type-safety guarantees of all the ORMs in the TypeScript ecosystem.

Read comparison with TypeORM

Auto-generated

Easy Relation API

Advanced Pagination

Nested Writes

Raw Database Access

Sorting and Filtering

Transactions

Aggregations

Case-insensitive Mode

Select Distinct

Helpful Error Messages

SQL Query Logging

JSON Field Support

Native Database Types

Custom Generators

Middleware

Prisma Migrate

Hassle-free migrations

Prisma Migrate auto-generates SQL migrations from your Prisma schema. These migration files are fully customizable, giving you full control and ultimate flexibility — from local development to production environments.

Learn more Playground

Prisma Studio

Visual database browser

Prisma Studio is the easiest way to explore and manipulate data in your Prisma projects. Understand your data by browsing across tables, filter, paginate, traverse relations and edit your data with safety.

Learn more

How does Prisma fit in your stack?

Prisma is a server-side library that helps developers read and write data to the database in an intuitive, efficient and safe way.

The ORM that plays well with your favorite framework

Easy to integrate into your framework of choice, Prisma simplifies database access, saves repetitive CRUD boilerplate and increases type safety. Its the perfect companion for building production-grade, robust and scalable web applications.

Browse examples on GitHub More about Prisma in your stack

Optimize Prisma for production workflows

Gain better reliability, collaboration, and visibility when working with your database.

Serverless functions made easy

When used with the ORM, the Data Proxy manages a connection pool to avoid running out of connections during traffic spikes. It also drastically reduces Prisma Clients bundle size and makes your Serverless function start up faster.

Collaborate safely with your team

Invite your colleagues and collaborate with appropriate permissions. Manage and verify your application data in the cloud with the Data Browser. Then test and troubleshoot Prisma queries directly from your browser using the Query Console.

Discover the Data Platform