skills.rest
ysfcl
ysfclCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

7|2|Updated Jul 24, 2026
Search Tags:#ORM#Prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/ysfcl/GeoMorphosis --skill prisma-postgres-ysfcl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/ysfcl/GeoMorphosis/tree/main/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/ysfcl/GeoMorphosis --skill prisma-postgres-ysfcl

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, Management API, and SDK—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 Provisioning: Create temporary 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 backend automation and multi-tenant onboarding. - Connection Setup: Link existing projects with prisma postgres link, retrieve direct TCP connection strings, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A developer building a CI preview pipeline can provision a throwaway database per pull request with npx create-db --ttl 2h --json, then claim it later if the branch merges. ## Quick Start Ask the assistant to provision a new Prisma Postgres database in eu-central-1 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. Use flags like --region to pick a location, --env to write DATABASE_URL into a .env file, or --json for machine-readable CI output. Aliases create-pg and create-postgres work identically.

How to provision Prisma Postgres programmatically in Node.js?▼

Install the create-db npm package and call its create() function with a region and userAgent. It returns a connectionString, claimUrl, and deletionDate, with type guards isDatabaseSuccess and isDatabaseError for handling results.

What is the difference between service token and OAuth for the Prisma Management API?▼

Service tokens suit server-to-server operations within your own workspace and are sent as Bearer auth. OAuth 2.0 is for acting on behalf of users across workspaces, requiring an authorize redirect, code exchange, and token refresh handling.

Does create-db support permanent databases?▼

Databases from create-db are temporary by default and auto-delete after about 24 hours unless claimed via the claim URL. For persistent project databases, use the @prisma/cli database create command instead.

Which Prisma adapter should I use for serverless runtimes?▼

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 Prisma Postgres serverless driver is specifically needed.

Why can't I retrieve my Prisma Postgres connection string again?▼

Connection secrets are one-time view: they are revealed only at creation and never re-readable from later API GETs. Store the connection URL immediately when database create or connection create prints it.

Related Skills

Explore More Software Engineering Skills→
nethangabrielbnethangabrielb

prisma-postgres-setup

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

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
akira777777akira777777

neon-object-storage

Provision S3-compatible object storage buckets that branch with Neon Postgres projects.

Community
Intermediate
human-centric-engineeringhuman-centric-engineering

deployment-guide

Generates platform-specific deployment documentation with environment variable checklists and troubleshooting guides.

Official
Intermediate