Database (/docs/postgres/database)

For the complete Prisma documentation index, see llms.txt. A markdown version of any docs page is available by appending .md to its URL.

Overview of Prisma Postgres database operations, connections, pooling, backups, and query analysis.

Location: Postgres > Database

This section covers the operational side of Prisma Postgres: how to connect, how pooling works, how to inspect query behavior, and how to manage your database in development and production.

• Connecting to your database
• Connection pooling
• Query Insights

• Backups
• PostgreSQL extensions
• Serverless driver
• Local Postgres

• Prisma Postgres overview
• Troubleshooting
• FAQ

• Best Postgres for AI apps: Why Prisma Postgres works well for AI and LLM workloads: built-in pooling, edge connectivity, pgvector, and MCP support.
• create-db: Learn how to provision temporary Prisma Postgres databases with create-db
• Error reference: Error reference documentation for Prisma Postgres
• Import from existing database: Choose the right path to import data from PostgreSQL or MySQL into Prisma Postgres.
• Migrate from Early Access: Move your Prisma Postgres Early Access database to a new PostgreSQL 17 database with dump and restore.