skills.rest
samu412
samu412COMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

Provision and manage Prisma Postgres databases via CLI, Console, 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/samu412/Development_kisan_basket --skill prisma-postgres-samu412
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/samu412/Development_kisan_basket/tree/main/category_kisan_basket/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/samu412/Development_kisan_basket --skill prisma-postgres-samu412

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 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 and connections: Link existing databases with prisma postgres link, retrieve direct TCP connection strings, and choose the right driver adapter (@prisma/adapter-pg vs @prisma/adapter-ppg). - Use Case: A developer needs a Postgres database for a CI preview environment. They run npx create-db@latest --ttl 2h --json to get a temporary database that auto-deletes, then wire the connection string into their pipeline. ## Quick Start Ask the assistant to create 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 writing.

How to 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 flags non-interactively, then run prisma generate and prisma migrate dev.

What is the difference between create-db and the Prisma Management API?▼

create-db provisions instant temporary databases that auto-delete after about 24 hours unless claimed, ideal for development and CI. The Management API provides durable programmatic control over workspaces, projects, branches, and databases for production automation.

Does Prisma Postgres support direct TCP connections?▼

Yes, Prisma Postgres supports direct TCP connections using a postgres:// URL with sslmode=require against db.prisma.io:5432. Use @prisma/adapter-pg for standard Node.js apps, or @prisma/adapter-ppg with @prisma/ppg for edge and serverless runtimes.

Why is my Prisma service token or connection string not visible after creation?▼

Service tokens and connection credentials are returned exactly once at creation and are redacted in later API responses. Store the value immediately in a secret store and never log the full creation response.

Related Skills

Explore More Software Engineering Skills→
theslashdojotheslashdojo

schema

Define and manage Prisma database schemas and models.

Official
Intermediate
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
MacPhobosMacPhobos

Neon Serverless Postgres Skill

Create and manage Neon Serverless Postgres databases with connection strings and ORM integrations.

Community
Advanced