skills.rest
Hugo-Ferrari
Hugo-FerrariCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

Updated Aug 19, 2026
Search Tags:#oauth#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/Hugo-Ferrari/finances --skill prisma-postgres-hugo-ferrari
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/Hugo-Ferrari/finances/tree/main/api/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/Hugo-Ferrari/finances --skill prisma-postgres-hugo-ferrari

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 guides you through the correct provisioning and management path for each scenario. ## Core Features & Use Cases - Instant Provisioning: Create temporary databases with npx create-db (aliases create-pg, create-postgres) using flags like --ttl, --json, --env, and --region. - Programmatic Management: Use the Management API at https://api.prisma.io/v1 or the typed @prisma/management-api-sdk with service tokens or OAuth for automation. - Project Linking & Connections: Wire existing databases to local projects with prisma postgres link, and configure direct TCP or serverless driver connections. - Use Case: A backend 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 AI 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`, `--ttl`, `--json`, or `--env .env` to control region, lifetime, output format, and env file writing.

How do I link 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` non-interactively, then run `prisma generate` and `prisma migrate dev`.

What is the difference between the Prisma Management API and the management-api-sdk?▼

The Management API at `https://api.prisma.io/v1` is the raw REST surface authenticated with service tokens or OAuth. The `@prisma/management-api-sdk` npm package wraps it with typed endpoints and optional OAuth token refresh handling.

Do temporary create-db databases get deleted automatically?▼

Yes, databases created with create-db are temporary by default and unclaimed instances are auto-deleted after about 24 hours. Use the claim URL from the output to keep the database permanently, or set a shorter lifetime with `--ttl`.

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 `endpoints.direct` or `endpoints.pooled` fields over deprecated flat fields.

Related Skills

Explore More Software Engineering Skills→
Sahil-ShowketSahil-Showket

prisma-postgres-setup

Provision Prisma Postgres databases via the Management API and connect them to local projects.

Community
Advanced
quanngynxquanngynx

prisma-postgres

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

Community
Intermediate
yejuneyejune

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

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

Community
Intermediate
nadicodeainadicodeai

minecraft-modpack-server

Automate hosting and management of modded Minecraft servers on Linux and macOS.

Official
Advanced