skills.rest
jpmartirez
jpmartirezCOMMUNITY
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 1, 2026
Search Tags:#cli#orm#prisma#postgres#database provisioning#management api#create-db
One-click install
npx skills add https://github.com/jpmartirez/kilatis --skill prisma-postgres-jpmartirez
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/jpmartirez/kilatis/tree/main/frontend/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/jpmartirez/kilatis --skill prisma-postgres-jpmartirez

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 it is easy to pick the wrong workflow or mishandle one-time connection secrets. This Skill provides structured guidance for every provisioning and management path. ## Core Features & Use Cases - Instant Provisioning: Create temporary databases with npx create-db using flags like --ttl, --region, --json, and --env for development, demos, and CI previews. - Programmatic Management: Use the Management API or @prisma/management-api-sdk with service tokens or OAuth for backend automation and multi-tenant onboarding. - Project Linking and 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 developer bootstrapping a new Next.js app runs npx create-db@latest --env .env to get a database instantly, then later claims it and links it to a persistent project before deploying. ## Quick Start Ask the assistant 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 an instant database, with aliases create-pg and create-postgres available. Use flags like --region, --env to write DATABASE_URL to a file, --json for CI output, or --ttl to control 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 environments, pass --api-key and --database flags, 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 REST source of truth for workspace, project, branch, and database operations. The @prisma/management-api-sdk wraps it with typed methods and handles OAuth token refresh automatically.

How long do create-db temporary databases last?▼

Databases created with create-db are temporary by default and auto-delete after roughly 24 hours unless claimed. You can set a shorter lifetime with the --ttl flag, such as 30m or 2h, and claim the database via the claim URL to keep it permanently.

Which 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 serverless driver is specifically needed.

Why can't I retrieve my database connection string again after creation?▼

Connection secrets are one-time view: they are revealed only at creation and cannot be re-read from later API requests. Store the connection URL immediately, and prefer the structured endpoints.direct and endpoints.pooled fields over the deprecated flat connectionString.

Related Skills

Explore More Software Engineering Skills→
MahdiaMayatiMahdiaMayati

prisma-postgres-setup

Provision a Prisma Postgres database via the Management API and connect it to a local project.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
david-2814david-2814
3

rds

Automate RDS database administration tasks using the AWS CLI.

Community
Advanced
surfingaliensurfingalien
1

prisma-connection-pool-exhaustion

Diagnose and fix Prisma connection pool exhaustion errors in serverless deployments.

Community
Intermediate