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, SQLite, MongoDB and CockroachDB.
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.
schema.prisma
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 String13 content String?14 published Boolean @default(false)15 author User? @relation(fields: [authorId], references: [id])16 authorId Int?17}Supported Languages
Supported Databases
index.tsx
1await prisma.user2 .findUnique({3 where: { email: 'ada@prisma.io' }4 })5 .posts({6 where: {7 title: {8
9 }10 }11 })contains
endsWith
equals
gt
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.
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 ClientAuto-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
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.
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.
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.
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.
Newsletter
Stay up to date with the latest features and changes to Prisma
Find Us
Prisma © 2018-2022.
Made with ❤️ in Berlin and worldwide