skills.rest
Sambhav242005
Sambhav242005COMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-postgres

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

Updated Aug 7, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/Sambhav242005/Major-Project --skill prisma-postgres-sambhav242005
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/Sambhav242005/Major-Project/tree/main/apps/web/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/Sambhav242005/Major-Project --skill prisma-postgres-sambhav242005

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @prisma/management-api-sdk, create-db, @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 connection strings and lost credentials. ## Core Features & Use Cases - Instant Provisioning: Create temporary or persistent Prisma Postgres databases with create-db, create-pg, or the @prisma/cli platform commands, including region selection, TTL, and JSON output for CI. - Programmatic Management: Use the Management API or @prisma/management-api-sdk for workspace, project, branch, and database automation with service tokens or OAuth. - Connection & Linking Guidance: 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: A developer bootstrapping a new Next.js app runs npx create-db@latest --env .env to get a database and connection string in seconds, then later automates per-tenant database provisioning through the Management API SDK. ## 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 databases programmatically in TypeScript?▼

Install @prisma/management-api-sdk and use createManagementApiClient with a service token, or createManagementApiSdk for OAuth with token refresh. The SDK exposes typed endpoints for workspaces, projects, databases, and service-token management.

What is the difference between create-db and prisma postgres link?▼

create-db provisions a new temporary database that auto-deletes after about 24 hours unless claimed. prisma postgres link connects an existing Prisma Postgres database to your local project by writing DATABASE_URL into your .env file.

Does Prisma Postgres support direct TCP connections?▼

Yes, Prisma Postgres exposes a direct endpoint at db.prisma.io:5432 and a pooled endpoint at pooled.db.prisma.io:5432. Use the direct URL with sslmode=require and @prisma/adapter-pg for standard Node.js apps.

Why did my Prisma Postgres connection string stop working?▼

Temporary create-db databases are auto-deleted after roughly 24 hours if not claimed via the claim URL. Also, connection secrets are shown only once at creation, so if the URL was not stored, you must rotate or recreate the connection.

When should I use the Management API instead of the Prisma Console?▼

Use the Management API for backend automation, multi-tenant onboarding, and CI provisioning where interactive workflows are impractical. The Console is better for manual tasks like viewing Studio data, metrics, and connection details.

Related Skills

Explore More Software Engineering Skills→
Sahil-ShowketSahil-Showket

prisma-postgres-setup

Provision Prisma Postgres databases via the Management API and connect them to local projects.

Community
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
NewEarthAINewEarthAI

supabase-postgres-best-practices

Review Supabase Postgres databases against performance and security best practices.

Community
Advanced