skills.rest
soumeningit
soumeningitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-postgres

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

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

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—Prisma Console, the create-db CLI, the Management API, and its 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 databases with npx create-db, including region selection, TTL, JSON output, and .env writing. - Programmatic Management: Use the Management API or @prisma/management-api-sdk with service tokens or OAuth for workspace, project, branch, and database automation. - Connection & Linking Guidance: Link existing databases with prisma postgres link, configure direct TCP connections, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A developer bootstrapping a new project 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 assistant to provision a new Prisma Postgres database 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. Use flags like --region, --env to write DATABASE_URL to a file, --json for CI output, or --ttl to control auto-deletion.

How do I link an existing Prisma Postgres database to a local project?▼

Run prisma postgres link to wire a local project to an existing database, which updates your .env with DATABASE_URL. For CI, pass --api-key and --database non-interactively, then run prisma generate and prisma migrate dev.

What is the difference between the Management API and the Management API SDK?▼

The Management API at https://api.prisma.io/v1 is the raw REST interface authenticated with service tokens or OAuth. The @prisma/management-api-sdk package wraps it with typed endpoints and optional OAuth token refresh handling.

Do create-db databases expire automatically?▼

Yes, databases created with create-db are temporary and unclaimed instances are auto-deleted after about 24 hours. Use the claim URL shown in the output to keep the database permanently, or set a shorter lifetime with --ttl.

Which adapter should I use for Prisma Postgres connections?▼

Standard Node.js apps should use @prisma/adapter-pg with the direct TCP connection string including sslmode=require. Edge or serverless runtimes should use @prisma/adapter-ppg with @prisma/ppg only when the serverless driver is specifically needed.

Why can't I see my connection string or service token again after creation?▼

Connection credentials and service token values are returned exactly once at creation and later reads show only metadata or a valueHint. Store the value immediately in a secret store and never log the full creation response.

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
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

Implement Prisma ORM for type-safe database access and migrations.

Community
Intermediate
3horizons3horizons

database-management

Monitor Azure PostgreSQL health, connections, backups, and database sizes.

Official
Intermediate
lawalletiolawalletio
3

prisma-postgres

Provision and manage Prisma Postgres databases via Console, create-db, and Management API.

Official
Advanced