skills.rest
byEduarda
byEduardaCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

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

1|2|Updated Aug 14, 2026
Search Tags:#orm#prisma#postgres#database provisioning#management api#connection string#create-db
One-click install
npx skills add https://github.com/byEduarda/TrabalhoFinal-EJCM2026.2 --skill prisma-postgres-byeduarda
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/byEduarda/TrabalhoFinal-EJCM2026.2/tree/main/back/src/.windsurf/skills/prisma-postgres
Command: npx skills add https://github.com/byEduarda/TrabalhoFinal-EJCM2026.2 --skill prisma-postgres-byeduarda

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 database 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: Integrate the Management API or @prisma/management-api-sdk for workspace, project, branch, and database automation with service tokens or OAuth. - 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 backend developer needs a Postgres database for a new Express API. They run npx create-db@latest --env .env to provision a database and write DATABASE_URL directly into their project, then run prisma migrate dev. ## 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. Use flags like --region to pick a location, --env to write DATABASE_URL into a .env file, or --json for CI-friendly machine-readable output.

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

Run prisma postgres link to wire an existing database to your local project. It updates your .env with DATABASE_URL, after which you run prisma generate and prisma migrate dev. For CI, pass --api-key and --database non-interactively.

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

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

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 sslmode=require with the direct URL and the @prisma/adapter-pg driver for standard Node.js applications.

How do I authenticate with the Prisma Management API?▼

The Management API supports service tokens for server-to-server workspace operations and OAuth 2.0 for acting on behalf of users. Send the token as a Bearer header against https://api.prisma.io/v1 endpoints.

Why is my Prisma Postgres connection string only shown once?▼

Connection credentials and service token values are returned exactly once at creation for security. Store them immediately in a secret manager, because later API responses only show metadata or a value hint.

Related Skills

Explore More Software Engineering Skills→
theslashdojotheslashdojo

schema

Define and manage Prisma database schemas and models.

Official
Intermediate
gil00pitagil00pita

prisma

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

Community
Advanced
yeohj0710yeohj0710

prisma-postgres

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

Community
Advanced
yejuneyejune

{{persona::BRAND}}-platform-database-cloud

Compare Neon, Supabase, and Firestore for cloud database selection.

Community
Intermediate