Prisma Postgres
Production-ready Postgres, already wired to your stack
Managed Postgres for TypeScript and AI apps, with Prisma Compute to host your app (Node.js, Bun or Next.js) next to it in one project. Any Postgres client works; Prisma ORM is optional. Start on the free plan, no credit card.
Free tier with a hard cap. No credit card.
- Free preview databases per feature branch, for the ones you declare
- Billed per operation, with a hard spend limit on paid plans
- Predictable pricing with spend limits, no surprise bills
databaseready
Production databaseus-west-1
postgres://…@db.prisma.io:5432
Connection pool included
Environments
mainproduction
pr-214own db
pr-207own db
daily backup
A database that ships with the rest of your stack
When your database and your hosting come from separate vendors, the things that should be automatic (a database for every preview, end-to-end test setups, single-config deploys) turn into work you have to do.
A preview database per feature branch
Predictable pricing with spend limits
Per-operation billing with spend limits
Standard Postgres, no lock-in
Previews, deploys and config that come with the app
Prisma Postgres runs on the same platform as Compute, so the features below come from one platform doing what two vendors can't.
previews
shared test db
production
pr-214own db
pr-207own db
A database per preview
With deploy on push, every feature branch (any branch except the default) gets a preview with its own services and, for databases declared in the Composer module, its own new database. Production data is not copied.
module.ts
export default module(, ({ provision }) => {
const db = provision(postgres());
provision(web, { deps: { db } });
});
One config for both halves
The same Composer module.ts declares your app and your database. No two-vendor wiring, no dashboards to keep in sync.
usage
Operationsspend limit
this monthyour cap
Free tierhard cap
no credit card
Predictable pricing
Operation-based pricing with spend limits you set yourself. A quiet month costs almost nothing, a busy one never surprises you.
compliance
Daily backups on paid plans
Encrypted in transit and at rest
Full tenant isolation
Compliance
Every plan
GDPR
Business
HIPAASOC 2 Type IIISO 27001
Production-ready from day one
Daily backups on paid plans, encryption at rest and in transit, full tenant isolation. GDPR on every plan. HIPAA, SOC 2 Type II and ISO 27001 on Business.
psql
$pg_dumpin or outpgvector
Any ORM
Prisma ORMDrizzleKyselyTypeORM
Any auth
BetterAuthClerkNextAuth
Standard Postgres, no lock-in
Standard Postgres underneath: leave with pg_dump; the Composer module is a TypeScript file in your repo, not a runtime. Standard SQL and wire protocol, with extensions like pgvector.
Built to work with the rest of Prisma
Prisma Postgres runs on the same platform as Compute, and the schema you define in Prisma ORM drives your migrations and your typed client. The more of the stack you use, the less there is to wire together.
Best together. Swappable when needed.
Swap any layer. It still works.
Golden path
Everything wired for you: one config, a preview with its own declared databases for each feature branch, and the app next to its database.
Driven by— all equally supported.
Compare Prisma
How Prisma Postgres and Prisma Compute compare with Neon, Supabase and other places to run a TypeScript app and its database, including where another pick is better.
- App hosting platforms with managed Postgres compared (2026)Prisma Compute, Railway, Render, Fly.io, Supabase, Neon and Vercel compared for an app next to managed Postgres.
- Where to host a TypeScript frontend, a Node API and PostgresHosting a TypeScript frontend, a Node API and their Postgres database from one GitHub repository.
- Choosing hosting and Postgres after your first 100 paying usersWhat to run the app and the database on once real users arrive.
- Neon vs Prisma Postgres for hosting and the database in one placeNeon alternatives when the app and its database should live in one project.
- Netlify alternatives for a full-stack TypeScript app with PostgresWhere to move a TypeScript app with Postgres when Netlify stops fitting.
- Move a local Postgres database online (2026)Prisma Postgres, Neon, Render, Railway and Supabase compared for taking a laptop Postgres database online with pg_dump and pg_restore.
- Migrate a local Postgres database to Prisma PostgresThe docs guide for copying a local PostgreSQL database into Prisma Postgres with pg_dump and pg_restore over the direct connection.
FAQ
Yes. The Free plan costs $0, needs no credit card and includes 200,000 operations a month across up to 50 databases in a workspace. An operation is one query, read or write, and usage resets at the start of each calendar month. On the Free plan, idle databases cost nothing and you never wake one by hand: the next query does it. Backups and spend limits start on the Starter plan at $10 a month.
Your workspace's databases stop accepting queries until the allowance resets at the start of the next month, or until you upgrade, which usually restores access within a minute. If you need time to export your data first, you can lift the limit for 24 hours from the Console, once per workspace. Paid plans bill operations beyond the included amount at your plan's rate, with a spend limit that is on by default.
Yes. Run
npx create-db and you get a Postgres database and its connection string in seconds, with no account and no credit card. Add --json when a coding agent needs machine-readable output. The database is deleted after 24 hours unless you claim it: open the claim link from the output and sign in, and it moves into your workspace under that plan's limits.Yes, through Prisma's hosted MCP server at https://mcp.prisma.io/mcp, which you connect with your Prisma sign-in. In Claude Code, run
claude mcp add --transport http prisma https://mcp.prisma.io/mcp. Cursor adds it from its MCP settings or a one-click link, and Codex through the Prisma plugin. An agent can then create databases, inspect the schema, run SQL, apply schema changes and, on paid plans, restore a backup into a new database. For scripts, there is also a REST API that uses a workspace service token. To keep test writes away from customer data, see hosting a TypeScript test app with a separate database.In the Prisma Console: open your project, select Connect to your database, then Generate new connection string. You get two connection strings. Use the pooled one as
DATABASE_URL for your app and serverless functions, and the direct one for migrations, Prisma Studio and pg_dump. SSL is required, so keep sslmode=require in the URL. npx create-db also prints a connection string. Once connected, the query-monitoring guide explains how to inspect slow SQL and existing indexes.Yes, on every plan, including Free. Enable it with
CREATE EXTENSION IF NOT EXISTS vector; from any Postgres client or a migration, then store embeddings in vector columns and run similarity search with pgvector's distance operators. Prisma ORM works with vector columns through raw SQL or TypedSQL, and Prisma Studio can't open tables that contain them yet. See the full list of supported extensions.Yes, every paid plan includes daily automatic backups. Starter and Pro keep them for 7 days and Business keeps them for 30; the Free plan has none. You restore a backup from the database's Backups tab in the Console, or ask an agent to restore one into a new database through the MCP server. Point-in-time restore is not available yet. To keep your own copy, run
pg_dump against the direct connection string, on any plan with available usage.Six: San Francisco (us-west-1), North Virginia (us-east-1), Paris (eu-west-3), Frankfurt (eu-central-1), Tokyo (ap-northeast-1) and Singapore (ap-southeast-1). You pick the region for each database when you create it in the Console, through MCP or with
npx create-db --region. Without the flag, npx create-db picks the region closest to you. For deployed apps, see choosing app and database regions.Yes, on the Business plan at $129 a month, with a signed Business Associate Agreement (BAA). HIPAA is not available on the Free, Starter or Pro plans. For comparison, Supabase only offers HIPAA from its Team plan at $599 a month, plus a paid HIPAA add-on. Business also includes SOC 2 Type II and ISO 27001, and GDPR applies on every plan, including Free. See HIPAA on the Business plan for the BAA and scope. Audit reports and control details are in the Prisma Trust Center.
Trusted by 500K+ TypeScript developers
“Prisma makes database management incredibly easy. Prisma's built-in type safety helps us avoid mistakes that happen with manual setups.”
“We chose Prisma because it provides us with type safety directly from the database. It has helped us tremendously to catch possible errors early on.”
“Prisma Postgres has really good DX. It's easy, simple, straightforward. I don't spend time on deployment. It just works.”
“Prisma is the best ORM I have ever used, I never want to use anything else again. The excellent developer experience with its incredible TypeScript support sold me at first.”
“Prisma has a low learning curve. Productivity becomes higher because it gets combined with end-to-end type-safety using TypeScript.”
Ricardo AlmeidaSoftware Engineer, Grover“Prisma has been an absolute game changer for Memberstack. It has helped us move faster while also improving product stability.”
“Prisma makes database management incredibly easy. Prisma's built-in type safety helps us avoid mistakes that happen with manual setups.”
“We chose Prisma because it provides us with type safety directly from the database. It has helped us tremendously to catch possible errors early on.”
“Prisma Postgres has really good DX. It's easy, simple, straightforward. I don't spend time on deployment. It just works.”
“Prisma is the best ORM I have ever used, I never want to use anything else again. The excellent developer experience with its incredible TypeScript support sold me at first.”
“Prisma has a low learning curve. Productivity becomes higher because it gets combined with end-to-end type-safety using TypeScript.”
Ricardo AlmeidaSoftware Engineer, Grover“Prisma has been an absolute game changer for Memberstack. It has helped us move faster while also improving product stability.”
“We've proudly built the core of our APIs on top of Prisma, and we are very happy that we did. It doesn't make us jump through unnecessary hoops to get normal work done and generally just works.”
“Prisma's approach to type-safe ORM is next-level. It provides full type-safety without any codegen or messy types and interfaces to write and maintain.”
Pieter VenterSr. Software Engineer, Invisible“Prisma is a professional enterprise-ready tool that is easy to start using, ramp up and scale. It is the type of tool developed for the software engineers of today.”
“The combination of Prisma, TypeScript and our pretty thorough coverage with integration tests gives us the confidence to refactor critical parts of our code.”
Thibaut NguyenCTO, Poppy“I chose Prisma because of its clean API, nice developer experience and type safety. It helped me ship v1 of Instatus really fast.”
“This is the fastest I've ever developed in my life, by far. The tooling has dramatically cut down on the amount of time I've had to spend.”
Sean EmmerCTO & Co-Founder, Pearly Plan“We've proudly built the core of our APIs on top of Prisma, and we are very happy that we did. It doesn't make us jump through unnecessary hoops to get normal work done and generally just works.”
“Prisma's approach to type-safe ORM is next-level. It provides full type-safety without any codegen or messy types and interfaces to write and maintain.”
Pieter VenterSr. Software Engineer, Invisible“Prisma is a professional enterprise-ready tool that is easy to start using, ramp up and scale. It is the type of tool developed for the software engineers of today.”
“The combination of Prisma, TypeScript and our pretty thorough coverage with integration tests gives us the confidence to refactor critical parts of our code.”
Thibaut NguyenCTO, Poppy“I chose Prisma because of its clean API, nice developer experience and type safety. It helped me ship v1 of Instatus really fast.”
“This is the fastest I've ever developed in my life, by far. The tooling has dramatically cut down on the amount of time I've had to spend.”
Sean EmmerCTO & Co-Founder, Pearly PlanPostgres that ships with the rest of your stack
Prisma Postgres is the data half of a TypeScript platform. Use it on its own with any ORM and any host, or pair it with Compute and your app and database become one deploy and one config, with a preview and its own declared databases for each feature branch.
- Free preview databases that come with your app's previews
- Predictable pricing with spend limits
- Standard Postgres underneath, no lock-in