Microsoft SQL Server and Azure SQL Support Is Now Generally Available. Learn More in the Blog Post!

Next-generation Node.js and TypeScript ORM

Prisma helps app developers build faster and make fewer errors with an open source database toolkit for PostgreSQL, MySQL, SQL Server, and SQLite.

Try Prisma in the Cloud Try locally

Prisma Schema

Data model
you can read

Central to Prisma is the schema - a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that.

Learn more about Prisma Schema

1datasource db {
2  provider = "sqlite"
3  url      = env("DATABASE_URL")
4}
5
6generator client {
7  provider = "prisma-client-js"
8}
9
10model Post {
11  id        Int @id @default(autoincrement())
12  title     String
13  content   String?
14  published Boolean @default(false)
15  author    User? @relation(fields: [authorId], references: [id])
16  authorId  Int?
17}

Check out an example schema

Supported Languages

JavaScript TypeScript

Supported Databases

PostgreSQL MySQL SQLite SQL Server

MongoDB

1await prisma.user
2  .findUnique({
3    where: { email: 'ada@prisma.io' }
4  })
5  .posts({
6    where: {
7      title: {
8
9      }
10    }
11  })

contains

endsWith

equals

gte

Prisma Client

Type-safe
database client

Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. We designed the API to be intuitive for both SQL veterans and people brand new to databases.

Explore Prisma Client Get started in 5 minutes

Extra ergonomy in Visual Studio Code

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

Download the Prisma VSCode Extension

Make fewer errors with TypeScript

Prisma Client puts extra emphasis on extensive type safety for more productive development in TypeScript.

Type definitions in Prisma Client

Auto-generated

Seamless Relation API

Advanced Pagination

Declarative Nested Writes

Raw Database Access

Sorting and Filtering

Transaction API

Aggregation API

Case-insensitive Mode

Select Distinct

Helpful Error Messages

SQL Query Logging

JSON Field Support

Native Database Types

Middleware Support

Custom Generators

Explore the Prisma Client Documentation

Prisma Migrate

Hassle-free migrations

Based on the Prisma Schema, Prisma Migrate automatically generates SQL database migrations, that are fully customizable. For quick data model prototyping in development,prisma db push lets you make changes to the database without generating migration files.

Learn more

$ npx prisma migrate

Prisma Studio

Visual database browser

The easiest way to explore and manipulate Data in your Prisma projects. Understand your data by browsing across tables and their relations and edit them with safety. Available for macOS, Windows and Linux.

Download

$ npx prisma studio

How does Prisma fit into your stack?

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

Diagram of Prisma in the Server part of Client - Server - Database stack

The ORM that plays well with any framework

Easy to integrate into your framework of choice, Prisma simplifies database access, saves repetitive CRUD boilerplate and increases type safety. It's the perfect database toolkit for building robust and scalable web APIs.

Next.js

Easiest way to work with a database for this popular React framework.

GraphQL

Query databases from your GraphQL servers easily with Prisma.

NestJS

Integrate Prisma with this popular server-side application framework.

Express

Easy way to query databases in this minimalist web framework.

Apollo

Integrate Prisma with one of the most popular GraphQL platforms.

hapi

Query databases with ease from this backend framework.

Browse more examples on GitHubBrowse Examples More about Prisma in your stack

From development to production

Prisma in your application lifecycle

Plan

Model your data in the Prisma schema with ease and in a human-readable format.

Code

Query your data in an intuitive and type-safe way with Prisma Client.

Test

Follow our guides for best practices on unit and integration tests with Prisma.

Deploy

Prisma works with all deployment paradigms, from traditional servers to containers, to serverless.

Monitor

Learn how to monitor and spot performance bottlenecks in your database queries.

Operate

Troubleshoot issues with your database when your application is running in production.

Engage with Prisma Developers

Join the thriving Prisma community

Prisma on Youtube - Livestreams, Events, Tutorials and Talks

Prisma’s YouTube channel is the headquarters for new weekly videos, livestreams, and meetups with Prisma folks and audience members.

Prisma Youtube Channel

Join 40,802 fans on Slack

Engage with a vibrant community of developers and companies adopting Prisma

GitHub

Browse the Prisma source code, send feedback or join the discussion on GitHub.

Send feedback Join the discussion

Prisma Client Prisma Migrate Prisma Studio Prisma 1 Cloud Prisma Data Platform Product Roadmap

Docs Get Started API Reference Examples How to GraphQL Data Guide Enterprise Event

Prisma with Next.js Prisma with GraphQL Prisma with Apollo Prisma with NestJS Prisma with Express Prisma with hapi

Prisma Ambassador Meet the Community Prisma Day Slack GitHub Discussions GraphQL Meetup TypeScript Meetup Advanced TypeScript Trickery Connect Dev Africa

About Jobs We're hiring!Causes Blog Terms & Privacy HTML Sitemap

Stay up to date with the latest features and changes to Prisma

Made with ❤️ in Berlin and worldwide

Next-generation Node.js and TypeScript ORM

Data model
you can read