skills.rest
brillianodhiya
brillianodhiyaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-postgres

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

Updated Jun 11, 2026
Search Tags:#oauth#ORM#Prisma#postgres#database provisioning#management api#create-db
One-click install
npx skills add https://github.com/brillianodhiya/VisionScript --skill prisma-postgres-brillianodhiya
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/brillianodhiya/VisionScript/tree/main/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/brillianodhiya/VisionScript --skill prisma-postgres-brillianodhiya

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires create-db, @prisma/management-api-sdk, and includes references (resource) components.

What problem does it solve? Setting up and managing Prisma Postgres databases involves multiple surfaces—Console, CLI, REST API, and SDK—and choosing the right workflow for each scenario is confusing. This Skill provides structured guidance for every provisioning and management path. ## Core Features & Use Cases - Instant CLI Provisioning: Create temporary databases with npx create-db using flags like --ttl, --region, --json, and --env for development, demos, and CI previews. - Programmatic Management: Integrate the Prisma Management API or @prisma/management-api-sdk with service tokens or OAuth for backend automation and multi-tenant onboarding. - Console & Connection Workflows: Link existing projects with prisma postgres link, inspect data in Studio, and configure direct TCP or serverless driver connections. - Use Case: A developer building a SaaS app needs per-customer databases. Use this Skill to implement OAuth-based provisioning with the Management API SDK, including token refresh and typed endpoint calls. ## Quick Start Ask the AI to provision a new Prisma Postgres database in the eu-central-1 region and write the connection string to your .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 to a file, or --json for CI-friendly machine-readable output.

How to provision Prisma Postgres databases programmatically?▼

Use the Prisma Management API at https://api.prisma.io/v1 with a service token or OAuth, or install @prisma/management-api-sdk for typed endpoints. The create-db npm package also exposes create() and regions() functions.

What is the difference between service token and OAuth for Prisma Management API?▼

Service tokens suit server-to-server operations within your own workspace. OAuth 2.0 is for acting on behalf of users across workspaces, requiring an authorize redirect, code exchange, and token refresh handling.

Does create-db support temporary databases with auto-delete?▼

Yes, create-db databases are temporary by default and auto-delete after roughly 24 hours unless claimed via the claim URL. Use the --ttl flag like 30m or 2h to shorten the lifetime.

How do I connect Prisma Postgres in serverless or edge runtimes?▼

Standard Node.js apps should use @prisma/adapter-pg with a direct TCP connection string including sslmode=require. Edge and serverless runtimes use @prisma/adapter-ppg with @prisma/ppg only when the serverless driver is needed.

How do I 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 .env with DATABASE_URL. For CI, pass --api-key and --database non-interactively, then run prisma generate and prisma migrate dev.

Related Skills

Explore More Software Engineering Skills→
nethangabrielbnethangabrielb

prisma-postgres-setup

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

Community
Advanced
kaxuna1kaxuna1

prisma

Generate a type-safe Prisma ORM layer for PostgreSQL in Node.js backends.

Community
Intermediate
flaviogragnolatiflaviogragnolati

prisma-postgres

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

Community
Advanced
lawalletiolawalletio
3

prisma-postgres

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

Official
Advanced