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.
25k+Stars on GitHub
250k+Active developers
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
label_filtering_example
typesafe_database_client
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
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
typesafe_database_client
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
typesafe_database_client
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.

Optimize Prisma for production workflows

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

Serverless functions made easy

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

label_filtering_example

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.

Trusted in production by
  • Gatsby logo
  • Rapha logo
  • Poppy logo
  • Twiga logo
  • Panther logo
  • Grover logo
  • Invisible logo
  • Elsevier logo
  • Tryg logo
  • IHI logo
  • Insta logo
  • Outrider logo
  • Oxio logo
  • Southpole logo
  • Gatsby logo
  • Rapha logo
  • Poppy logo
  • Twiga logo
  • Panther logo
  • Grover logo
  • Invisible logo
  • Elsevier logo
  • Tryg logo
  • IHI logo
  • Insta logo
  • Outrider logo
  • Oxio logo
  • Southpole logo