skills.rest
nethangabrielb
nethangabrielbCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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/nethangabrielb/tasks-app-practical-exam --skill prisma-postgres-nethangabrielb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/nethangabrielb/tasks-app-practical-exam/tree/main/packages/database/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/nethangabrielb/tasks-app-practical-exam --skill prisma-postgres-nethangabrielb

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—Prisma Console, the create-db CLI, the Platform CLI, and the Management API—each with different auth flows, flags, and one-time credential handling. This Skill consolidates the correct commands, endpoints, and workflows so you avoid misconfigured connections, lost credentials, and outdated API assumptions. ## Core Features & Use Cases - Instant Provisioning: Create temporary or persistent Prisma Postgres 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 workspace, project, branch, and database automation. - Connection & Linking Guidance: Link existing databases with prisma postgres link, configure direct TCP connections with sslmode=require, and choose between @prisma/adapter-pg and serverless drivers. - Use Case: You are bootstrapping a CI preview environment. Run npx create-db@latest --json --ttl 2h to provision a throwaway database, capture the connection string, and let it auto-delete after the pipeline finishes. ## Quick Start Ask the AI to provision 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 available. Use flags like --region, --json, --env, and --ttl to control region, output format, env file writing, and auto-deletion timing.

How do I 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 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 is the REST surface at https://api.prisma.io/v1 for workspace, project, and database operations with service token or OAuth auth. The @prisma/management-api-sdk 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 auto-delete after roughly 24 hours. Use the claim URL from the output to keep the database permanently, or set a shorter lifetime with --ttl like 30m or 2h.

Which Prisma adapter should I use for Prisma Postgres connections?▼

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 see my connection string or service token again after creation?▼

Connection credentials and workspace service tokens are returned exactly once at creation and later reads show only metadata or a valueHint. Store the value immediately in a secret store and never log the full creation response.

Related Skills

Explore More Software Engineering Skills→
Mohamedghaly140Mohamedghaly140

prisma-postgres-setup

Provision Prisma Postgres databases and retrieve direct connection strings via the Management API.

Community
Advanced
kaxuna1kaxuna1

prisma

Generate a type-safe Prisma ORM layer for PostgreSQL in Node.js backends.

Community
Intermediate
byEduardabyEduarda
1

prisma-postgres

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

Community
Intermediate
MapleTechLabsMapleTechLabs
1.6k

clickhousectl-cloud-deploy

Automate ClickHouse deployment to managed ClickHouse Cloud services.

Official
Intermediate