prisma-postgres

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

Updated Mar 27, 2026
One-click install
npx skills add https://github.com/quanngynx/GDGO-2026.Servexa-Warranty-AI --skill prisma-postgres-quanngynx
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/quanngynx/GDGO-2026.Servexa-Warranty-AI/tree/main/servexa-warranty-ai/.agents/skills/prisma-postgres
Command: npx skills add https://github.com/quanngynx/GDGO-2026.Servexa-Warranty-AI --skill prisma-postgres-quanngynx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It solves the problem of getting a Prisma Postgres database stood up and integrated correctly across manual console usage, CLI provisioning, and programmatic Management API flows.

Core Features & Use Cases

  • Guided Prisma Console setup: Use Console to view/edit data in Studio and retrieve connection details without unnecessary backend work.
  • Instant provisioning with create-db CLI: Create temporary databases for dev, demos, or CI, including region selection, JSON output, and writing DATABASE_URL/CLAIM_URL to an env file.
  • Programmatic provisioning and management: Use Management API (REST) and the typed Management API SDK for service-token or OAuth-based workflows, including token refresh patterns.
  • Integration-ready connection handling: Work with claim URLs, connection strings, regions, and auth flows so apps can use the resulting DATABASE_URL securely and consistently.

Quick Start

Use the prisma-postgres skill to provision a Prisma Postgres database with the CLI by running npx create-db@latest.

Frequently Asked Questions about prisma-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I provision a Prisma Postgres database using the CLI?

You can provision a Prisma Postgres database by running npx create-db@latest, which handles database lifecycle creation, region selection, and outputting DATABASE_URL or CLAIM_URL directly to an environment file.

What is the Prisma Postgres Management API used for?

The Prisma Postgres Management API enables programmatic database provisioning and management. It supports REST endpoints and a typed SDK for service-token or OAuth-based workflows, including token refresh patterns and environment bootstrapping.

Can I use Prisma Console to retrieve connection strings for my database?

Yes, Prisma Console provides a guided setup to view and edit data in Studio and retrieve connection strings without backend work. It also handles endpoint discovery and auth method configuration for your database connections.

Does the Prisma Management API SDK support OAuth token refresh scenarios?

Yes, the typed Management API SDK supports both service-token and OAuth-based workflows. It includes token refresh patterns to ensure reliable programmatic provisioning and management of Prisma Postgres databases across automated environments.

How do I write DATABASE_URL and CLAIM_URL to an env file during database provisioning?

The create-db CLI can write DATABASE_URL and CLAIM_URL directly to an environment file during provisioning. This supports interactive and automated workflows by ensuring integration-ready connection handling for your applications.

What is the best way to manage Prisma Postgres databases in CI pipelines?

For CI pipelines, use the create-db CLI to create temporary databases for dev, demos, or testing. It supports JSON output and region selection, while the Management API SDK handles automated lifecycle management with service tokens.