skills.rest
vasuguptadot-jpg
vasuguptadot-jpgCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

Updated Jul 27, 2026
Search Tags:#cli#orm#prisma#postgres#database provisioning#management api#create-db
One-click install
npx skills add https://github.com/vasuguptadot-jpg/Life-xp- --skill prisma-postgres-vasuguptadot-jpg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/vasuguptadot-jpg/Life-xp-/tree/main/attached_assets/LifeXP-Complete/apps/api/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/vasuguptadot-jpg/Life-xp- --skill prisma-postgres-vasuguptadot-jpg

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 or @prisma/management-api-sdk for workspace, project, branch, and database automation with service tokens or OAuth. - Project Linking & Connections: Link existing databases with prisma postgres link, configure direct TCP connections with sslmode=require, and choose between @prisma/adapter-pg and serverless drivers. - Use Case: A developer bootstrapping a new app runs npx create-db@latest --env .env to get a database instantly, then later migrates to the Management API SDK for multi-tenant provisioning in production. ## Quick Start Ask the AI 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 available. Use flags like --region, --env to write DATABASE_URL to a file, --json for CI output, or --ttl to control auto-deletion.

How to provision Prisma Postgres programmatically in TypeScript?▼

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

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 supports direct TCP connections at db.prisma.io:5432 with sslmode=require, suitable for @prisma/adapter-pg in standard Node.js apps. Connection responses expose endpoints.direct and endpoints.pooled fields, and secrets are shown only once at creation.

Why did my create-db database get deleted?▼

Databases created with create-db are temporary by default and unclaimed databases auto-delete after roughly 24 hours. Open the claim URL shown in the command output to keep the database permanently, or set a shorter deletion window with --ttl.

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
JoshkovuJoshkovu
1

prisma-postgres-setup

Provision Prisma Postgres databases via the Management API and configure local Prisma 7 projects.

Community
Advanced
mgd34msumgd34msu
4

railway

Automate application deployment to the Railway Platform with zero-config detection.

Community
Intermediate
NaveedTechLabNaveedTechLab
11

infra-deployment-specialist

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

Community
Advanced