skills.rest
Rashidrxq
RashidrxqCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-postgres

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

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

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 database provisioning: Create temporary Prisma Postgres databases with create-db (or create-pg/create-postgres aliases), 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. - Project linking and connections: 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 needs a throwaway Postgres database for a CI preview. They run npx create-db@latest --ttl 2h --json to get a connection string that auto-deletes after two hours. ## Quick Start Ask the assistant to create a temporary 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 command line?▼

Run npx create-db@latest to provision a database instantly, with aliases create-pg and create-postgres available. Use flags like --region, --ttl, --json, or --env to control region, auto-deletion time, output format, and .env writing.

How to 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 flags non-interactively, then run prisma generate and prisma migrate dev.

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

The Management API at api.prisma.io/v1 exposes REST endpoints authenticated by service tokens or OAuth. The @prisma/management-api-sdk wraps it with typed methods, OAuth login flows, and automatic token refresh for TypeScript apps.

Do temporary create-db databases get deleted automatically?▼

Yes, databases created with create-db are temporary and auto-delete after about 24 hours unless claimed via the claim URL in the output. You can shorten this with the --ttl flag, such as --ttl 2h.

Which adapter should I use for Prisma Postgres connections?▼

For standard Node.js apps, use @prisma/adapter-pg with the direct TCP URL including sslmode=require. For edge or serverless runtimes, use @prisma/adapter-ppg with @prisma/ppg only when you need the Prisma Postgres serverless driver.

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; later API calls show only metadata and a valueHint. Store the value immediately in a secret store and never log the creation response.

Related Skills

Explore More Software Engineering Skills→
HollowvynHollowvyn

prisma-orm

Generate type-safe Prisma clients and manage schema migrations for TypeScript.

Official
Advanced
NarixHineNarixHine

prisma-postgres-setup

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

Community
Advanced
yeohj0710yeohj0710

prisma-postgres

Coordinate Prisma Postgres provisioning and management across 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