What problem does it solve? Setting up and managing Prisma Postgres databases involves multiple surfaces—Prisma Console, the create-db CLI, the Management API, and its TypeScript SDK—and choosing the wrong workflow or mishandling one-time credentials leads to lost connection strings and broken environments. ## Core Features & Use Cases - Instant Provisioning: Create temporary or persistent Prisma Postgres databases with create-db (aliases create-pg, create-postgres), including region selection, TTL, JSON output, and .env writing. - Programmatic Management: Use the Management API at https://api.prisma.io/v1 or the typed @prisma/management-api-sdk with service tokens or OAuth for workspace, project, branch, and database automation. - Project Linking & Connections: Link existing databases with prisma postgres link, configure direct TCP connections with sslmode=require, and choose between @prisma/adapter-pg and the serverless @prisma/adapter-ppg. - Use Case: A backend engineer needs a Postgres database for a CI preview environment. They run npx create-db@latest --ttl 2h --json to provision a temporary instance, capture the connection string, and let it auto-delete after the pipeline finishes. ## Quick Start Ask the AI to provision a new Prisma Postgres database using create-db and write the connection string into your project's .env file.
