skills.rest
UdayPandey01
UdayPandey01COMMUNITY
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.

2|Updated Feb 22, 2026
Search Tags:#migration#orm#prisma#postgres#database provisioning#management api#connection string
One-click install
npx skills add https://github.com/UdayPandey01/Healix --skill prisma-postgres-setup-udaypandey01
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-setup
Source: https://github.com/UdayPandey01/Healix/tree/main/core/.agents/skills/prisma-postgres-setup
Command: npx skills add https://github.com/UdayPandey01/Healix --skill prisma-postgres-setup-udaypandey01

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 across the Console UI, API calls, and local project configuration. This Skill automates the entire provisioning workflow, from authentication to a verified working connection. ## Core Features & Use Cases - Database Provisioning via Management API: Authenticate with a service token, select a region, and create a project with a database, extracting the direct connection string automatically. - Local Project Configuration: Install required packages (prisma, @prisma/client, @prisma/adapter-pg, pg, dotenv), configure .env, prisma.config.ts, and schema.prisma following Prisma 7 conventions. - End-to-End Verification: Run a test script against the new database to confirm the Prisma 7 client connects correctly before finishing. - Use Case: You are starting a new Node.js project and need a hosted Postgres database. Ask the agent to set up Prisma Postgres, and it provisions the database, writes the connection string to .env, scaffolds the schema, runs the initial migration, and verifies connectivity. ## 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 for a new project?▼

Authenticate with a workspace service token, create a project via POST /v1/projects with createDatabase set to true, and extract the direct connection string. Then install prisma, @prisma/client, @prisma/adapter-pg, pg, and dotenv, write the string to .env, and run npx prisma migrate dev.

How do I get a Prisma Postgres connection string?▼

Create a project with a database through the Management API and read data.database.connections[0].endpoints.direct.connectionString from the response. Use the direct endpoint, not the pooled or accelerate endpoints, which are only for legacy Accelerate setups.

How do I instantiate PrismaClient in Prisma 7?▼

Create a pg.Pool with your DATABASE_URL, wrap it in a PrismaPg adapter, and pass { adapter } to the PrismaClient constructor imported from ./generated/prisma/client.js. Calling new PrismaClient() with no arguments or with datasourceUrl throws in Prisma 7.

Why does Prisma Postgres authentication return a 401 error?▼

A 401 authentication-failed error means the service token is invalid or expired. Create a new token in Prisma Console under Workspace Settings, Service Tokens, and set it as the PRISMA_SERVICE_TOKEN environment variable.

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

Do not use this workflow for CI/CD preview databases or multi-tenant provisioning built into an app; those use dedicated skills. If the database already exists and is connected, standard Prisma CLI commands handle schema and migration tasks.

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
dennisonbertramdennisonbertram
1

neon-branching

Provisions Neon serverless Postgres branches per pull request.

Community
Advanced
JoshkovuJoshkovu
1

prisma-postgres-setup

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

Community
Advanced