skills.rest
Akhand0ps
Akhand0psCOMMUNITY
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 31, 2026
Search Tags:#oauth#orm#prisma#postgres#database provisioning#management api#create-db
One-click install
npx skills add https://github.com/Akhand0ps/vecta --skill prisma-postgres-akhand0ps
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/Akhand0ps/vecta/tree/main/packages/db/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/Akhand0ps/vecta --skill prisma-postgres-akhand0ps

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. ## Core Features & Use Cases - Instant Provisioning: Create temporary or persistent databases with create-db, create-pg, or the @prisma/cli database commands, including region selection, TTL, and JSON output for CI. - Programmatic Management: Use the Management API or @prisma/management-api-sdk with service tokens or OAuth for workspace, project, branch, and database automation. - Connection Setup: Link existing projects with prisma postgres link, configure direct TCP or pooled connections, and choose the right adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A developer bootstrapping a new TypeScript app runs npx create-db@latest --env .env to get a database instantly, then later migrates to the Management API SDK for automated multi-tenant provisioning. ## Quick Start Ask the assistant 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. Use flags like --region, --env to write DATABASE_URL to a file, --json for CI output, or --ttl to control auto-deletion.

How do I provision Prisma Postgres programmatically in TypeScript?▼

Install @prisma/management-api-sdk and use createManagementApiClient with a service token, or createManagementApiSdk for OAuth with token refresh. The create-db npm package also exposes create() and regions() functions for lightweight programmatic provisioning.

What is the difference between create-db and the Prisma Platform CLI?▼

create-db creates temporary databases that auto-delete after about 24 hours unless claimed. The @prisma/cli database commands create persistent databases attached to a Project, with support for connections, usage, backups, and restore operations.

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

Standard Node.js apps should use @prisma/adapter-pg with the direct TCP connection URL including sslmode=require. Edge and serverless runtimes should use @prisma/adapter-ppg with @prisma/ppg only when the Prisma Postgres serverless driver is specifically needed.

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 when returned, and prefer the structured direct and pooled endpoint fields over deprecated flat connection strings.

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

Run prisma postgres link to wire an existing database to your local project, 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→
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
modu-aimodu-ai
1.2k

moai-platform-database-cloud

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

Official
Intermediate