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

35k+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 VS Code stay confident and productive.

Download Prisma VS Code 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

Supercharge your Prisma Client

Explore our solutions for global database caching, serverless connection pooling and real-time database events.

Global database cache and connection pooling

Achieve up to 1000x faster database queries with Prisma Accelerate’s global cache. Thanks to its scalable connection pool for serverless and edge environments, you can avoid exhausting your database connections and ensure efficient delivery of all your requests to your users.

Early Access

Real-time database events

Enjoy seamless real-time communication between your database and app with Prisma Pulse, letting you focus on building robust apps while we handle the data syncs for you - like magic.

Get started