skills.rest
sristigupta04
sristigupta04COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

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

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 provides structured guidance for every provisioning and management path so you get a working database with correct credentials and connection strings. ## 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 (https://api.prisma.io/v1) or the typed @prisma/management-api-sdk with service tokens or OAuth for backend automation and multi-tenant onboarding. - Project Linking & Connections: Link existing databases with prisma postgres link, retrieve direct TCP or pooled endpoints, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: You are building a CI preview pipeline. Use npx create-db@latest --json --ttl 2h to spin up an auto-expiring database per pull request, then claim it via the claim URL if it needs to persist. ## 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 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 command line?▼

Run npx create-db@latest to provision a database instantly, with aliases create-pg and create-postgres. Use flags like --region, --json, --env, and --ttl to control region, output format, env file writing, and auto-deletion time.

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 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 wraps it with typed endpoints and optional OAuth token refresh handling for TypeScript apps.

Do temporary create-db databases get deleted automatically?▼

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

Which Prisma adapter should I use for serverless or edge runtimes?▼

For standard Node.js apps, use @prisma/adapter-pg with the direct TCP connection string including sslmode=require. For edge or serverless runtimes, use @prisma/adapter-ppg with @prisma/ppg only when you need the Prisma Postgres serverless driver.

Why can't I see my connection string or service token after creation?▼

Connection credentials and service token values are returned exactly once at creation and are redacted in later reads. Store them immediately in a secret store and never log the full creation response.

Related Skills

Explore More Software Engineering Skills→
prismaprisma
51

prisma-postgres-setup

Provision a Prisma Postgres database via the Management API and connect it locally.

Official
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
MeoBakaMeoBaka

aws-secrets-rotation

Automate AWS Secrets Manager credential rotation with Lambda templates.

Community
Advanced
tjl8787tjl8787

rds

Manage AWS RDS instances for provisioning, backup, restore, and performance optimization.

Community
Advanced