Prisma Postgres

Prisma Postgres is a managed PostgreSQL service built for modern app development. Use this page to choose a connection path and get started quickly.

Getting started

Create a database

New to Prisma Postgres? Start here.

<Cards> <Card href="/postgres/npx-create-db" title="Create a temporary database with create-db"> Create a temporary Prisma Postgres database in one command. </Card> <Card href="/prisma-orm/quickstart/prisma-postgres" title="Prisma Postgres quickstart with Prisma ORM"> Set up Prisma ORM and connect it to Prisma Postgres. </Card> </Cards>

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.

<Cards> <Card href="/prisma-orm/quickstart/prisma-postgres" title="Prisma Postgres quickstart"> Get started with the recommended Prisma ORM workflow. </Card> </Cards>

Any PostgreSQL client or ORM

Use Prisma Postgres with psql, GUI tools, node-postgres, or other ORMs.

<Cards> <Card href="/prisma-postgres/quickstart/kysely" title="Kysely quickstart"> Connect Prisma Postgres from Kysely. </Card> <Card href="/prisma-postgres/quickstart/drizzle-orm" title="Drizzle ORM quickstart"> Connect Prisma Postgres from Drizzle ORM. </Card> <Card href="/prisma-postgres/quickstart/typeorm" title="TypeORM quickstart"> Connect Prisma Postgres from TypeORM. </Card> <Card href="/postgres/database/direct-connections" title="Direct TCP connections"> Use standard PostgreSQL connection strings over TCP. </Card> </Cards>

Serverless and edge runtimes

Use the serverless driver for HTTP/WebSocket connectivity in edge or constrained runtimes.

• Serverless driver (@prisma/ppg)

Local development

Run Prisma Postgres locally with prisma dev, then switch to cloud when ready.

• Local development

Optimize and manage

• Connection pooling
• Caching
• Backups
• PostgreSQL extensions
• Troubleshooting
• FAQ

Billing and limits

Prisma Postgres uses usage-based pricing and includes spend controls.

• Pricing
• Operations-based billing explained
• FAQ: estimating costs

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.

:::info[Note] Postgres, PostgreSQL, and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada and are used with permission. :::