Database

Learn how Prisma Postgres implements foundational database features such as built-in caching, connection pooling, backups, and secure access. These features are powered by Prisma Postgres infrastructure and designed to optimize application performance and reliability.

In this section

Caching

Prisma Postgres supports built-in query caching to reduce database load and improve query performance. You can configure cache behavior using the cacheStrategy option available in all read queries.

Connection pooling

Prisma Postgres provides built-in connection pooling by default, enabled by Prisma Accelerate. By using Prisma Postgres, you get the benefits of connection pooling without having to configure anything. The efficient management of database connections allows the database to process more queries without exhausting the available database connections, making your application more scalable.

Backups

Overview

Local development

Prisma Postgres is a production-grade, cloud-native database and is ideal for staging and production environments. For rapid iteration and isolated testing, you can run a local Prisma Postgres instance (powered by PGlite). This page explains how to install and launch a local Prisma Postgres database.

Direct connections

Overview

Tooling

You can view and edit your data in Prisma Postgres using either Prisma Studio or 3rd party database editors.

Serverless driver

The serverless driver for Prisma Postgres is a lightweight and minimal client library that can talk to Prisma Postgres using raw SQL. You can use it via the @prisma/ppg npm package.

API reference

The Prisma Postgres API reference documentation is based on the following schema:

Error reference

When working with Prisma Postgres, you may encounter errors often highlighted by specific error codes during development and operations.