Prisma Postgres
Overview
Prisma Postgres is a managed PostgreSQL database service that easily lets you create a new database, interact with it through Prisma ORM, and build applications that start small and cheap but can scale to millions of users.
It supports the following workflows:
- Schema migrations and queries (via Prisma ORM)
- Connection pooling and caching (via Prisma Accelerate)
- Real-time database change events (via Prisma Pulse)
Prisma Postgres is currently in Early Access and not yet suitable for production use. It doesn't perform any automated backups and thus there's a risk of total data loss.
Getting started with Prisma Postgres
The easiest way to get started with Prisma Postgres is the Quickstart.
Technical details
Here's an overview of the technical details of your Prisma Postgres instances:
- PostgreSQL version: 16
- Storage: Max 1GB
Architecture
Prisma Postgres uses a unique architecture to deliver unmatched efficiency, safety and ease of use. It is deployed on bare metal servers using unikernels (think: "hyper-specialized operating systems").
Learn more about the architecture in our announcement article.
Pricing
Prisma Postgres has a pay-as-you-go pricing model for storage and queries and is billed through Prisma Accelerate and Pulse. More details on our pricing page.
Temporary limitations
Here's a list of limitations that Prisma Postgres currently has. All of these are temporary and will be lifted in the future.
No automated backups (risk of total data loss)
Prisma Postgres doesn't perform automated backups yet. Hence, there's a risk of total data loss.
No direct TCP connection
You can only interact with Prisma Postgres through Prisma Accelerate's connection pool using HTTP. This means:
- You have to use Prisma ORM with the Accelerate Client extension to interact with Prisma Postgres from your application. Other ORMs and DB libraries like TypeORM, Sequelize or knex.js are not yet supported.
- You have to use Prisma Studio if you want to visually explore and edit your data. Other database GUIs like Postico or TablePlus are not yet supported.
Same resource allocation regardless of pricing plan
It's not yet possible to configure the size and resource allocation of your Prisma Postgres instance. All instances will have the same technical details, regardless of the pricing plan you chose.