Prisma Postgres
Connect to Prisma Postgres from Prisma ORM, serverless runtimes, and PostgreSQL clients.
Prisma Postgres is a managed PostgreSQL database with built-in connection pooling, query caching, and edge runtime support. Use this page to choose a connection path and get started quickly.
What's included
Everything below is included with every Prisma Postgres database. No extra services to configure.
- Connection pooling — A dedicated PgBouncer instance runs alongside your database. You don't need to set one up or manage it. Works automatically for serverless and edge deployments. See Connection pooling.
- Query caching — Add a
cacheStrategyto any Prisma ORM query to cache results at the edge, using TTL or stale-while-revalidate. See Caching. - Edge and serverless support — Connect from Cloudflare Workers, Vercel Edge Functions, and other edge runtimes via the serverless driver, which uses HTTP instead of TCP.
- Automated backups — Daily backups with point-in-time recovery. See Backups.
Getting started
Create a database
New to Prisma Postgres? Start here.
Create a temporary database with create-db
Create a temporary Prisma Postgres database in one command.
Prisma Postgres quickstart with Prisma ORM
Set up Prisma ORM and connect it to Prisma Postgres.
Get your connection string
In Prisma Console, open your database and click Connect to your database to copy connection URLs.
Choose a connection type
Prisma ORM (recommended default)
Use Prisma ORM for migrations and type-safe queries.
Any PostgreSQL client or ORM
Use Prisma Postgres with psql, GUI tools, node-postgres, or other ORMs.
Kysely quickstart
Connect Prisma Postgres from Kysely.
Drizzle ORM quickstart
Connect Prisma Postgres from Drizzle ORM.
TypeORM quickstart
Connect Prisma Postgres from TypeORM.
Connecting to your database
Choose the right connection string for Prisma ORM, PostgreSQL tools, and serverless runtimes.
Serverless and edge runtimes
Use the serverless driver for HTTP/WebSocket connectivity in edge or constrained runtimes.
Local development
Run Prisma Postgres locally with prisma dev, then switch to cloud when ready.
Manage
- Connecting to your database
- Connection pooling
- Caching
- Backups
- PostgreSQL extensions
- Troubleshooting
- FAQ
Billing and limits
Prisma Postgres uses usage-based pricing and includes spend controls.
In Prisma Console, you can track usage, set spend limits, and view billing details.
Technical details
Prisma Postgres is based on PostgreSQL v17 and uses a unikernel-based architecture.
Learn more: Prisma Postgres: Building a modern PostgreSQL service.
Postgres, PostgreSQL, and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada and are used with permission.