skills.rest
AlvaroCG123
AlvaroCG123COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

Updated Aug 10, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/AlvaroCG123/BancoAtividade --skill prisma-postgres-alvarocg123
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/AlvaroCG123/BancoAtividade/tree/main/AtividadeBanco/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/AlvaroCG123/BancoAtividade --skill prisma-postgres-alvarocg123

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 throwaway databases. 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), 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 & Connections: Link existing databases with prisma postgres link, configure direct TCP connections, and choose between @prisma/adapter-pg and serverless drivers. - Use Case: You need a Postgres database for a CI preview. Run npx create-db@latest --ttl 2h --json to get a connection string that auto-deletes, or claim it via the URL to keep it permanently. ## Quick Start Ask the assistant to create a new Prisma Postgres database in the us-east-1 region and write the connection string into your .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 to control region, lifetime, 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, then run prisma generate and prisma migrate dev.

What is the difference between create-db and the Prisma Management API?▼

create-db provisions instant temporary databases that auto-delete after about 24 hours unless claimed. The Management API at api.prisma.io/v1 provides durable workspace, project, branch, and database management for backend automation using service tokens or OAuth.

Does Prisma Postgres support direct TCP connections?▼

Yes, Prisma Postgres exposes direct endpoints at db.prisma.io:5432 and pooled endpoints at pooled.db.prisma.io:5432. Use sslmode=require in the connection URL and prefer @prisma/adapter-pg for standard Node.js apps.

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 in a secret store and never log the full creation response.

When should I use @prisma/management-api-sdk instead of raw API calls?▼

Use the SDK when you need typed endpoint methods and built-in OAuth with token refresh via createManagementApiSdk. For simple server-to-server calls with an existing token, createManagementApiClient with a Bearer token is sufficient.

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
NarixHineNarixHine

prisma-postgres-setup

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

Community
Advanced
MeoBakaMeoBaka

aws-secrets-rotation

Automate AWS Secrets Manager credential rotation with Lambda templates.

Community
Advanced
modu-aimodu-ai
1.2k

moai-platform-database-cloud

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

Official
Intermediate