skills.rest
8ReTid8
8ReTid8COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

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

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 TypeScript SDK—and choosing the wrong workflow wastes time or produces misconfigured connections. This Skill provides consolidated guidance so you pick the right provisioning path and handle connection strings, claim URLs, regions, and auth correctly. ## 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 file writing. - Programmatic Management: Use the Management API (https://api.prisma.io/v1) with service tokens or OAuth, or the typed @prisma/management-api-sdk for token refresh and endpoint calls. - 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 driver. - Use Case: A backend developer needs a Postgres database for a CI preview. They run npx create-db@latest --json --ttl 2h to get a connection string that auto-deletes, then later claim it via the claim URL to keep it permanently. ## Quick Start Ask the assistant 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. Use flags like --region, --json, --env, and --ttl to control region selection, output format, env file writing, and auto-deletion timing.

How do I use the Prisma Management API with a service token?▼

Create a service token in Prisma Console workspace settings, then send it as a Bearer token in the Authorization header to https://api.prisma.io/v1. The API manages workspaces, projects, branches, and databases, with OpenAPI docs at /v1/doc.

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, direct TCP connections use db.prisma.io:5432 with sslmode=require, and pooled connections use pooled.db.prisma.io:5432. Connection secrets are shown only once at creation, so store them immediately.

When should I use @prisma/adapter-pg versus @prisma/adapter-ppg?▼

Use @prisma/adapter-pg with the direct TCP URL for standard Node.js applications. Use @prisma/adapter-ppg with @prisma/ppg only for edge or serverless runtimes that need the Prisma Postgres serverless driver.

Why did my create-db database get deleted?▼

Databases created with create-db are temporary by default and unclaimed databases auto-delete after roughly 24 hours, or sooner if you set a --ttl flag. Open the claim URL from the command output to keep the database permanently.

Related Skills

Explore More Software Engineering Skills→
RashidrxqRashidrxq

prisma-postgres-setup

Provisions a Prisma Postgres database via the Management API and connects it to a local project.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
HuynhSang2005HuynhSang2005

prisma-postgres

Automate Prisma Postgres provisioning and management via Console, CLI, and API.

Community
Advanced
modu-aimodu-ai
1.2k

moai-platform-database-cloud

Guides selection and setup of Neon, Supabase, and Firestore cloud databases.

Official
Intermediate