skills.rest
singhaditya73
singhaditya73COMMUNITY
Explore all skills by this author →
Website𝕏@aditya_singh73GitHub

prisma-postgres

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

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

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 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 automation and multi-tenant flows. - Project Linking & Connections: Link existing databases with prisma postgres link, configure direct TCP connections with sslmode=require, and choose between @prisma/adapter-pg and @prisma/adapter-ppg. - Use Case: A developer bootstrapping a new app runs npx create-db@latest --env .env to get a connection string immediately, then later migrates to the Management API SDK for production workspace automation. ## 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 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 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 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 package wraps it with typed endpoints and optional OAuth token refresh handling.

Does Prisma Postgres support direct TCP connections?▼

Yes, direct TCP connections use db.prisma.io:5432 with sslmode=require, and pooled connections use pooled.db.prisma.io:5432. Connection secrets are shown once at creation, so store them immediately.

When should I use @prisma/adapter-pg versus @prisma/adapter-ppg?▼

Use @prisma/adapter-pg with the direct TCP URL for standard Node.js applications. Use @prisma/adapter-ppg with @prisma/ppg only for edge or serverless runtimes that need the Prisma Postgres serverless driver.

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. Open the claim URL from the command output to keep the database permanently, or set a shorter TTL with --ttl.

Related Skills

Explore More Software Engineering Skills→
NarixHineNarixHine

prisma-postgres-setup

Provisions Prisma Postgres databases via the Management API and connects them to local projects.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
yeohj0710yeohj0710

prisma-postgres

Coordinate Prisma Postgres provisioning and management across Console, CLI, and API.

Community
Advanced
NaveedTechLabNaveedTechLab
11

infra-deployment-specialist

Automates Docker containerization, Neon PostgreSQL migrations, and application deployment to Hugging Face Spaces.

Community
Advanced