skills.rest
UdayPandey01
UdayPandey01COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

2|Updated Feb 22, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection strings#create-db
One-click install
npx skills add https://github.com/UdayPandey01/Healix --skill prisma-postgres-udaypandey01
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/UdayPandey01/Healix/tree/main/core/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/UdayPandey01/Healix --skill prisma-postgres-udaypandey01

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @prisma/management-api-sdk, create-db, 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 for workspace, project, branch, and database automation with service tokens or OAuth. - 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 backend developer 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 agent to provision a new Prisma Postgres database in a specific region 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`, `--json`, `--env`, and `--ttl` to control region, output format, env file writing, and auto-deletion time.

How do I provision Prisma Postgres programmatically in TypeScript?▼

Install `@prisma/management-api-sdk` and use `createManagementApiClient` with an existing service token, or `createManagementApiSdk` for OAuth with token refresh. The SDK exposes typed endpoints for workspaces, projects, databases, and service tokens.

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 Prisma Postgres database to your local project by writing `DATABASE_URL` into your `.env` file.

Does Prisma Postgres support direct TCP connections?▼

Yes, Prisma Postgres exposes a direct endpoint at `db.prisma.io:5432` and a pooled endpoint at `pooled.db.prisma.io:5432`. Use `sslmode=require` in the connection URL and prefer `@prisma/adapter-pg` for standard Node.js applications.

Why did I lose my Prisma Postgres connection string after creation?▼

Connection secrets and service token values are returned exactly once at creation and are redacted in later API responses. Store the URL or token immediately in a secret store, and never log the full creation response.

When should I use the Management API instead of Prisma Console?▼

Use the Management API for backend automation, multi-tenant onboarding, and controlled resource provisioning where interactive workflows are impractical. The Console is better for manual tasks like viewing Studio data, metrics, and connection details.

Related Skills

Explore More Software Engineering Skills→
theslashdojotheslashdojo

schema

Define and manage Prisma database schemas and models.

Official
Intermediate
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
curiositechcuriositech
181

admin-dashboard

Extend admin dashboards with new tabs, metrics, and API endpoints.

Official
Intermediate
yejuneyejune

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

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

Community
Intermediate