Prisma Client

Learn what Prisma Client is, how to generate it, and where to go next for querying, relations, and transactions. Applies to Prisma ORM v7.

Learn how to set up Prisma Client. Applies to Prisma ORM v7.

Learn how prisma generate works, how to configure the generator output, and how to import the generated Prisma Client. Applies to Prisma ORM v7.

Learn how to set up and use read replicas with Prisma Client. Applies to Prisma ORM v7.

Learn how to set up Prisma Client. Applies to Prisma ORM v6.

This page explains how to generate Prisma Client. It also provides additional context on the generated client, typical workflows and Node.js configuration. Applies to Prisma ORM v6.

How to create and use an instance of PrismaClient in your app. Applies to Prisma ORM v6.

Prisma ORM's query engine creates a connection pool to store and manage database connections. Applies to Prisma ORM v7.

This page explains how database connections are handled with Prisma Client and how to manually connect and disconnect your database. Applies to Prisma ORM v7.

Configure Prisma Client with PgBouncer and other poolers: when to use pgbouncer=true, required transaction mode, prepared statements, and Prisma Migrate workarounds. Applies to Prisma ORM v7.

Databases connections. Applies to Prisma ORM v6.

Prisma ORM's query engine creates a connection pool to store and manage database connections. Applies to Prisma ORM v6.

This page explains how database connections are handled with Prisma Client and how to manually connect and disconnect your database. Applies to Prisma ORM v6.

Configure Prisma Client with PgBouncer and other poolers: when to use pgbouncer=true, required transaction mode, prepared statements, and Prisma Migrate workarounds. Applies to Prisma ORM v6.

Learn how to set up and use read replicas with Prisma Client. Applies to Prisma ORM v6.

Learn how to use Prisma ORM without Rust engines. Applies to Prisma ORM v6.

How to perform CRUD with Prisma Client. Applies to Prisma ORM v7.

Use Prisma Client to aggregate, group by, count, and select distinct. Applies to Prisma ORM v7.

Learn how to use full-text search with Prisma Client for PostgreSQL and MySQL. Applies to Prisma ORM v7.

How to perform CRUD with Prisma Client. Applies to Prisma ORM v6.

This page explains how to exclude sensitive fields from Prisma Client. Applies to Prisma ORM v6.

Use Prisma Client to aggregate, group by, count, and select distinct. Applies to Prisma ORM v6.

This page explains how to use client extensions to add computed fields to Prisma models. Applies to Prisma ORM v6.

This page explains how to wrap Prisma Client in custom models. Applies to Prisma ORM v6.

This page explains the transactions API of Prisma Client. Applies to Prisma ORM v6.

This page explains how to search for text within a field. Applies to Prisma ORM v6.

This page explains how to add custom validation to Prisma Client. Applies to Prisma ORM v6.

Extend the functionality of Prisma Client. Applies to Prisma ORM v7.

Extend the functionality of Prisma Client, query component. Applies to Prisma ORM v7.

Extend the functionality of Prisma Client. Applies to Prisma ORM v6.

Extend the functionality of Prisma Client, query component. Applies to Prisma ORM v6.

Share extensions or import shared extensions into your Prisma project. Applies to Prisma ORM v7.

Learn how to implement RBAC, ABAC, and ReBAC authorization in your Prisma applications. Applies to Prisma ORM v7.

Share extensions or import shared extensions into your Prisma project. Applies to Prisma ORM v6.

Learn how to implement RBAC, ABAC, and ReBAC authorization in your Prisma applications. Applies to Prisma ORM v6.

Learn how to deploy database changes with Prisma Migrate. Applies to Prisma ORM v7.

Learn how to deploy database changes with Prisma Migrate. Applies to Prisma ORM v6.

Learn how to deploy a Next.js application based on Prisma Client to Vercel. Applies to Prisma ORM v7.

Learn how to deploy your Prisma ORM-backed applications to AWS Lambda with AWS SAM, Serverless Framework, or SST. Applies to Prisma ORM v7.

Learn how to deploy Node.js and TypeScript applications that are using Prisma Client to Netlify. Applies to Prisma ORM v7.

Learn how to deploy a Next.js application based on Prisma Client to Vercel. Applies to Prisma ORM v6.

Learn how to deploy your Prisma ORM-backed applications to AWS Lambda with AWS SAM, Serverless Framework, or SST. Applies to Prisma ORM v6.

Learn how to deploy Node.js and TypeScript applications that are using Prisma Client to Netlify. Applies to Prisma ORM v6.

Learn how to deploy your Prisma-backed apps to edge functions like Cloudflare Workers or Vercel Edge Functions. Applies to Prisma ORM v7.

Learn the things you need to know in order to deploy an Edge function that uses Prisma Client for talking to a database. Applies to Prisma ORM v7.

Learn the things you need to know in order to deploy an app that uses Prisma Client for talking to a database to a Cloudflare Worker or to Cloudflare Pages. Applies to Prisma ORM v7.

Learn how to deploy a TypeScript application using Prisma ORM to Deno Deploy. Applies to Prisma ORM v7.

Learn how to deploy your Prisma-backed apps to edge functions like Cloudflare Workers or Vercel Edge Functions. Applies to Prisma ORM v6.

Learn the things you need to know in order to deploy an Edge function that uses Prisma Client for talking to a database. Applies to Prisma ORM v6.

Learn the things you need to know in order to deploy an app that uses Prisma Client for talking to a database to a Cloudflare Worker or to Cloudflare Pages. Applies to Prisma ORM v6.

Learn how to deploy a TypeScript application using Prisma ORM to Deno Deploy. Applies to Prisma ORM v6.

Learn how to deploy a Node.js server that uses Prisma ORM to Heroku. Applies to Prisma ORM v7.

Learn how to deploy a Node.js server that uses Prisma ORM to Koyeb Serverless Platform. Applies to Prisma ORM v7.

Learn how to deploy a Node.js server that uses Prisma ORM to Render. Applies to Prisma ORM v7.

Learn how to deploy a Node.js server that uses Prisma ORM to Sevalla. Applies to Prisma ORM v7.

Learn how to deploy a Node.js server that uses Prisma ORM to Render. Applies to Prisma ORM v6.

Learn how to deploy a Node.js server that uses Prisma ORM to Sevalla. Applies to Prisma ORM v6.

Learn how to configure Prisma Client to log the raw SQL queries it sends to the database and other information. Applies to Prisma ORM v7.

Diagnose application performance with detailed traces of each query. Applies to Prisma ORM v7.

Add metadata to your SQL queries as comments for improved observability, debugging, and tracing. Applies to Prisma ORM v7.

Learn how to configure Prisma Client to log the raw SQL queries it sends to the database and other information. Applies to Prisma ORM v6.

Diagnose application performance with insights into Prisma Client database activity. Applies to Prisma ORM v6.

Diagnose application performance with detailed traces of each query. Applies to Prisma ORM v6.

Add metadata to your SQL queries as comments for improved observability, debugging, and tracing. Applies to Prisma ORM v6.

How to read, write, and filter by Json fields. Applies to Prisma ORM v7.

How to read, write, and filter by scalar lists / arrays. Applies to Prisma ORM v7.

How to read, write, and filter by Json fields. Applies to Prisma ORM v6.

How to read, write, and filter by scalar lists / arrays. Applies to Prisma ORM v6.

Learn how to setup and run unit tests with Prisma Client. Applies to Prisma ORM v7.

Learn how to setup and run integration tests with Prisma and Docker. Applies to Prisma ORM v7.

Learn how to setup and run unit tests with Prisma Client. Applies to Prisma ORM v6.

Learn how to setup and run integration tests with Prisma and Docker. Applies to Prisma ORM v6.

Prisma Client provides full type safety for queries, even for partial queries or included relations. This page explains how to leverage the generated types and utilities. Applies to Prisma ORM v7.

How to use Prisma ORM's type system. Applies to Prisma ORM v7.

Prisma Client provides full type safety for queries, even for partial queries or included relations. This page explains how to leverage the generated types and utilities. Applies to Prisma ORM v6.

How to use Prisma ORM's type system. Applies to Prisma ORM v6.

Learn how to use TypedSQL to write fully type-safe SQL queries that are compatible with any SQL console and Prisma Client. Applies to Prisma ORM v7.

Learn how to use SafeQL and Prisma Client extensions to work around features not natively supported by Prisma, such as PostGIS. Applies to Prisma ORM v7.

Learn how to use TypedSQL to write fully type-safe SQL queries that are compatible with any SQL console and Prisma Client. Applies to Prisma ORM v6.

Learn how to use SafeQL and Prisma Client extensions to work around features not natively supported by Prisma, such as PostGIS. Applies to Prisma ORM v6.