skills.rest
zester4
zester4COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

2|1|Updated Jun 9, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/zester4/zilmate --skill prisma-postgres-zester4
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/zester4/zilmate/tree/main/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/zester4/zilmate --skill prisma-postgres-zester4

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires create-db, @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, REST API, and SDK—and choosing the wrong workflow wastes time or breaks automation. This Skill provides structured guidance for every provisioning and management path. ## Core Features & Use Cases - Instant CLI Provisioning: Create temporary databases with npx create-db using flags like --ttl, --region, --json, and --env for CI-friendly output. - Programmatic Management: Use the Management API with service tokens or OAuth, or the typed @prisma/management-api-sdk with token refresh handling. - Project Linking & Connections: Link existing databases with prisma postgres link, configure direct TCP connections, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A backend developer needs a Postgres database for a CI preview environment. Run npx create-db@latest --json --ttl 2h to get a machine-readable connection string that auto-deletes after two hours. ## Quick Start Ask the assistant to create a temporary Prisma Postgres database in a specific region and write the connection string to 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 command line?▼

Run npx create-db@latest to provision a database instantly. Use flags like --region to pick a location, --env to write DATABASE_URL to a file, --json for machine-readable output, and --ttl to control auto-deletion timing.

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

Use the create-db npm package's create() function, or the Management API at https://api.prisma.io/v1 with a service token. For typed endpoints with OAuth and token refresh, install @prisma/management-api-sdk.

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

Service tokens are created in Prisma Console workspace settings and suit server-to-server operations in your own workspace. OAuth 2.0 redirects users through auth.prisma.io and is best when acting on behalf of users across workspaces.

Does Prisma Postgres work with serverless or edge runtimes?▼

Yes, but adapter choice matters. Standard Node.js apps should use @prisma/adapter-pg with a direct TCP connection string including sslmode=require. Edge or serverless runtimes should use @prisma/adapter-ppg with @prisma/ppg only when the serverless driver is specifically needed.

Why did my temporary Prisma Postgres database get deleted?▼

Databases created with create-db are temporary by default and unclaimed instances auto-delete after roughly 24 hours, or sooner if a --ttl flag was set. Open the claim URL from the command output to keep the database permanently.

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

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

Related Skills

Explore More Software Engineering Skills→
team-zerolatencyteam-zerolatency

prisma-postgres-setup

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

Community
Advanced
kaxuna1kaxuna1

prisma

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

Community
Intermediate
lawalletiolawalletio
3

prisma-postgres

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

Official
Advanced
abdoulayesowabdoulayesow

seri-offline

Integrates a local database with a cloud backend for seamless offline/online sync.

Community
Advanced