skills.rest
team-zerolatency
team-zerolatencyCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

Provision and manage Prisma Postgres databases via CLI, Console, and Management API.

Updated Sep 17, 2026
Search Tags:#oauth#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/team-zerolatency/cfta --skill prisma-postgres-team-zerolatency
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/team-zerolatency/cfta/tree/main/packages/database/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/team-zerolatency/cfta --skill prisma-postgres-team-zerolatency

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires create-db, @prisma/management-api-sdk, @prisma/cli, and includes references (resource) components.

What problem does it solve? Setting up and managing Prisma Postgres databases involves multiple surfaces—Console, CLI tools, and APIs—and choosing the wrong workflow wastes time or produces misconfigured connections. This Skill provides structured guidance for every provisioning and management path. ## Core Features & Use Cases - Instant Provisioning: Create temporary databases with npx create-db (aliases create-pg, create-postgres), with flags for region, TTL, JSON output, and .env writing. - Programmatic Management: Use the Management API or @prisma/management-api-sdk for workspace, project, branch, and database automation with service tokens or OAuth. - Connection Setup: Link existing projects with prisma postgres link, configure direct TCP connections, and choose between @prisma/adapter-pg and serverless drivers. - Use Case: A developer bootstrapping a new app runs npx create-db@latest --env .env to get a database instantly, then later migrates to the Management API SDK for multi-tenant provisioning in production. ## 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.

Frequently Asked Questions about prisma-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Prisma Postgres database from the terminal?▼

Run npx create-db@latest to provision a database instantly, with aliases create-pg and create-postgres available. Use flags like --region, --env to write DATABASE_URL to a file, --json for CI output, or --ttl to control auto-deletion timing.

How to provision Prisma Postgres databases programmatically?▼

Use the Management API at https://api.prisma.io/v1 with a service token or OAuth, or install @prisma/management-api-sdk for typed endpoints. The SDK's createManagementApiClient works with existing tokens, while createManagementApiSdk handles OAuth with token refresh.

What is the difference between create-db and prisma postgres link?▼

create-db provisions a new temporary database that auto-deletes after about 24 hours unless claimed. prisma postgres link connects an existing database to your local project by writing DATABASE_URL into your .env file.

Does Prisma Postgres support direct TCP connections?▼

Yes, direct TCP connections use db.prisma.io:5432 with sslmode=require, and pooled connections use pooled.db.prisma.io:5432. For Node.js apps prefer @prisma/adapter-pg; use @prisma/adapter-ppg only for edge or serverless runtimes.

Why did my create-db database get deleted?▼

Databases created with create-db are temporary by default and unclaimed instances auto-delete after roughly 24 hours. Open the claim URL shown in the command output to keep the database permanently, or set a shorter TTL with --ttl.

How do I authenticate with the Prisma Management API?▼

Use a workspace service token sent as a Bearer token for server-to-server operations, or OAuth 2.0 to act on behalf of users. Service token values are returned exactly once at creation, so store them immediately in a secret store.

Related Skills

Explore More Software Engineering Skills→
prismaprisma
51

prisma-postgres-setup

Provision a Prisma Postgres database via the Management API and connect it locally.

Official
Advanced
NarixHineNarixHine

prisma-postgres-setup

Provisions Prisma Postgres databases via the Management API and connects them to local projects.

Community
Advanced
MeoBakaMeoBaka

aws-secrets-rotation

Automate AWS Secrets Manager credential rotation with Lambda templates.

Community
Advanced
yejuneyejune

{{persona::BRAND}}-platform-database-cloud

Compare Neon, Supabase, and Firestore for cloud database selection.

Community
Intermediate