skills.rest
johnnystefan
johnnystefanCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres

Provision Prisma Postgres databases via console, create-db CLI, or management API workflows.

Updated Mar 26, 2026
Search Tags:#cli#sdk#prisma#postgres#management-api#database-provisioning#create-db
One-click install
npx skills add https://github.com/johnnystefan/test-saas-business --skill prisma-postgres-johnnystefan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres
Source: https://github.com/johnnystefan/test-saas-business/tree/main/skills/prisma/postgres
Command: npx skills add https://github.com/johnnystefan/test-saas-business --skill prisma-postgres-johnnystefan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill removes the friction of creating, linking, and managing Prisma Postgres databases by outlining the full console, CLI, and API workflows needed for reproducible deployments and integrations.

Core Features & Use Cases

  • CLI Provisioning: Use create-db (and its aliases) to spin up instant Postgres databases with TTL, copy, quiet, and open flags for rapid environments and predictable cleanup.
  • Management API Workflows: Authenticate with service tokens or OAuth, explore the OpenAPI docs, and manage Prisma Postgres resources programmatically for teams and automation scripts.
  • SDK and Local Linking: Install @prisma/management-api-sdk for typed clients, persist tokens securely, and run prisma postgres link (with API keys in CI) to connect your local project to remote databases.

Quick Start

Ask to provision a temporary Prisma Postgres database with create-db and link it to your project.

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 temporary Prisma Postgres database from the command line?▼

You can provision a Prisma Postgres database using the create-db CLI command with TTL, copy, quiet, and open flags to spin up instant environments with predictable cleanup. This allows rapid deployment of temporary databases directly from your terminal.

Can I manage Prisma Postgres resources programmatically using a typed SDK?▼

Yes, you can manage Prisma Postgres resources programmatically by installing the @prisma/management-api-sdk to get typed clients. This SDK allows you to authenticate with service tokens or OAuth and manage resources via the management API.

What is the best way to link a local project to a remote Prisma Postgres database?▼

The best way to link a local project to a remote Prisma Postgres database is by running the prisma postgres link command. You can use API keys in CI environments to establish the connection and manage your connection strings securely.

How does authentication work for the Prisma Postgres management API?▼

Authentication for the Prisma Postgres management API works through service tokens or OAuth flows. You can explore the OpenAPI docs to understand the endpoints and manage your databases programmatically for team automation scripts.

Do I need the console to set up a Prisma Postgres workspace for SDK integrations?▼

No, you do not need the console to set up a Prisma Postgres workspace for SDK integrations. You can apply CLI workflows and the management API SDK to handle workspace setup, instant database creation, and local project linking directly.

Related Skills

Explore More Software Engineering Skills→
truongnattruongnat

prisma-postgres

Provision and manage Prisma Postgres databases via Console, CLI, and APIs.

Community
Advanced
METRMETR
25

database-migrations

Manage database schema evolution with Alembic for Python applications.

Official
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

Implement Prisma ORM for type-safe database access and migrations.

Community
Intermediate
phuetzphuetz
30

terraform-ansible

Provision cloud infrastructure with Terraform and configure it using Ansible playbooks.

Community
Advanced