Skip to main content

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:

warning

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.

Limited region support​

Prisma Postgres is gradually rolled out in new regions. If it is not yet available in your preferred region, you can get notified when it becomes available by selecting the respective region in the Region dropdown when setting up your Prisma Postgres instance in the PDP Console.