skills.rest
son1cleo
son1cleoCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres-setup

Provision a Prisma Postgres database via the Management API and connect it to a local project.

Updated Jul 1, 2026
Search Tags:#migration#orm#prisma#postgres#database provisioning#management api#connection string
One-click install
npx skills add https://github.com/son1cleo/databrief --skill prisma-postgres-setup-son1cleo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-setup
Source: https://github.com/son1cleo/databrief/tree/main/frontend/.windsurf/skills/prisma-postgres-setup
Command: npx skills add https://github.com/son1cleo/databrief --skill prisma-postgres-setup-son1cleo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires prisma, @prisma/client, @prisma/adapter-pg, pg, dotenv, and includes references (resource) components.

What problem does it solve? Setting up a new Prisma Postgres database involves multiple manual steps: creating a service token, choosing a region, provisioning a project through the Management API, wiring the connection string into your project, and configuring Prisma 7's new client adapter pattern. This Skill automates that entire workflow so you get a verified, working database connection without reading API docs. ## Core Features & Use Cases - End-to-end provisioning: Authenticates with a service token, lists available regions, creates a project with a database, and polls until the database status is ready. - Prisma 7 project configuration: Installs required packages, writes the direct connection string to .env, scaffolds schema.prisma and prisma.config.ts, and runs the initial migration. - Connection verification: Generates and runs a test script using the @prisma/adapter-pg driver adapter to confirm the client connects before finishing. - Use Case: You just created a new Next.js app and need a Postgres database. Ask the agent to set up Prisma Postgres, pick a region from the interactive menu, and receive a migrated schema plus a verified DATABASE_URL in minutes. ## Quick Start Set up a new Prisma Postgres database for this project and connect it locally using my service token.

Frequently Asked Questions about prisma-postgres-setup

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

FAQPage Schema
How do I set up a Prisma Postgres database from the command line?▼

Use the Prisma Management API with a workspace service token: list available regions, create a project with createDatabase set to true, then extract the direct connection string from the response. Write it to your .env file as DATABASE_URL and run prisma migrate dev to initialize the schema.

How do I get a Prisma Postgres connection string?▼

Create a project via POST /v1/projects with createDatabase enabled, then read data.database.connections[0].endpoints.direct.connectionString from the response. Use the direct endpoint, not the pooled or Accelerate endpoints, for new projects.

How do I instantiate PrismaClient in Prisma 7?▼

Prisma 7 requires a driver adapter: create a pg.Pool with your DATABASE_URL, wrap it in PrismaPg from @prisma/adapter-pg, and pass { adapter } to the PrismaClient constructor. Calling new PrismaClient() with no arguments or with datasourceUrl throws an error.

Why does Prisma Postgres project creation fail with a database limit error?▼

Workspaces have a cap on databases, so creation fails when the limit is reached. List your existing projects with GET /v1/projects, delete an unused one via DELETE /v1/projects/{projectId}, then retry the creation request.

When should I not use the Prisma Management API for database setup?▼

Avoid it for CI/CD preview databases and multi-tenant provisioning built into an app, which need dedicated workflows. If your database already exists and is connected, standard Prisma CLI commands like prisma migrate dev handle schema tasks directly.

Related Skills

Explore More Software Engineering Skills→
truongnattruongnat

prisma-postgres

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

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

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

Community
Intermediate
UdayPandey01UdayPandey01

prisma-postgres

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

Community
Intermediate
JoshkovuJoshkovu
1

prisma-postgres-setup

Provision Prisma Postgres databases via the Management API and configure local Prisma 7 projects.

Community
Advanced