skills.rest
Soares-B
Soares-BCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

Provisions and manages Prisma Postgres databases via CLI, Console, and Management API.

Updated Jul 27, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/Soares-B/Livia-Lace --skill prisma-postgres-soares-b
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/Soares-B/Livia-Lace/tree/main/livia-lace/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/Soares-B/Livia-Lace --skill prisma-postgres-soares-b

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires create-db, @prisma/cli, @prisma/management-api-sdk, 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 or persistent Prisma Postgres databases with create-db, create-pg, or the @prisma/cli platform commands, including region selection, TTL, and JSON output for CI. - Programmatic management: Integrate 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 or pooled connections, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A backend developer needs a Postgres database for a preview deployment. They run npx create-db@latest --json --ttl 2h, get a connection string and claim URL, and wire it into their app's .env in seconds. ## Quick Start Ask the assistant to create a new Prisma Postgres database with 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, or --ttl to control region, output format, env file writing, and auto-deletion time.

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

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

What is the difference between create-db and the Prisma Platform CLI?▼

create-db provisions temporary throwaway databases that auto-delete after about 24 hours unless claimed. The @prisma/cli database commands create persistent databases attached to a project, with support for connections, usage, backups, and restore.

Does the Prisma Management API support OAuth authentication?▼

Yes, the Management API supports both service tokens for server-to-server workspace operations and OAuth 2.0 for acting on behalf of users. The @prisma/management-api-sdk provides createManagementApiSdk with token storage and refresh handling for OAuth flows.

Why is my Prisma Postgres connection string only shown once?▼

Connection create and rotate responses reveal credentials exactly once for security; later reads redact or omit the secret. Store the URL immediately when returned, and prefer the structured direct and pooled endpoint fields over deprecated flat connection strings.

Which adapter should I use for Prisma Postgres in serverless apps?▼

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

Related Skills

Explore More Software Engineering Skills→
Shofikul-Isl4mShofikul-Isl4m

prisma-postgres-setup

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

Community
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
yejuneyejune

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

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

Community
Intermediate