skills.rest
Rithika135
Rithika135COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

Updated Aug 21, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/Rithika135/watchtower-360 --skill prisma-postgres-rithika135
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/Rithika135/watchtower-360/tree/main/watchtower360-backend/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/Rithika135/watchtower-360 --skill prisma-postgres-rithika135

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 create-db (aliases create-pg, create-postgres) using flags like --ttl, --region, --json, and --env. - 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, and choose between @prisma/adapter-pg and serverless drivers. - Use Case: A backend developer needs a Postgres database for a CI preview environment. They run npx create-db@latest --ttl 2h --json to get a connection string that auto-deletes after the pipeline finishes. ## 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, --ttl, --json, or --env to control region, auto-deletion time, output format, and .env file writing.

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

Run prisma postgres link to wire an existing database into your local project, which updates .env with DATABASE_URL. For CI environments, pass --api-key and --database flags 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 api.prisma.io/v1 is the raw REST interface authenticated with service tokens or OAuth. The @prisma/management-api-sdk package wraps it with typed endpoints and optional OAuth token refresh handling for TypeScript and JavaScript apps.

Do temporary create-db databases get deleted automatically?▼

Yes, databases created with create-db are temporary by default and auto-delete after roughly 24 hours unless claimed. You can shorten this with the --ttl flag (for example 30m or 2h), or open the claim URL to keep the database 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 Prisma Postgres serverless driver is specifically needed.

Why can't I see my connection string or service token again after creation?▼

Connection credentials and service token values are returned exactly once at creation for security. Later API calls show only metadata and a valueHint, so store the secret immediately in a secret store and never log creation responses.

Related Skills

Explore More Software Engineering Skills→
gil00pitagil00pita

prisma

Generate a type-safe Prisma Client from declarative schemas for Node.js and TypeScript.

Community
Advanced
NarixHineNarixHine

prisma-postgres-setup

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

Community
Advanced
yeohj0710yeohj0710

prisma-postgres

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

Community
Advanced
modu-aimodu-ai
1.2k

moai-platform-database-cloud

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

Official
Intermediate