skills.rest
vasuguptadot-jpg
vasuguptadot-jpgCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres-setup

Provisions a Prisma Postgres database via the Management API and connects it to a local project.

Updated Jul 27, 2026
Search Tags:#migration#prisma#postgres#database provisioning#management api#connection string#prisma 7
One-click install
npx skills add https://github.com/vasuguptadot-jpg/Life-xp- --skill prisma-postgres-setup-vasuguptadot-jpg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-setup
Source: https://github.com/vasuguptadot-jpg/Life-xp-/tree/main/attached_assets/LifeXP-Complete/apps/api/.agents/skills/prisma-postgres-setup
Command: npx skills add https://github.com/vasuguptadot-jpg/Life-xp- --skill prisma-postgres-setup-vasuguptadot-jpg

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 local environment, and configuring Prisma 7's new client adapter pattern. This Skill automates that entire workflow end to end. ## Core Features & Use Cases - Automated Provisioning: Authenticates with a service token, lists available regions, and creates a project with a database through the Prisma Management API. - Local Project Configuration: Installs required packages, writes the direct connection string to .env, scaffolds prisma/schema.prisma and prisma.config.ts, and runs the initial migration. - Connection Verification: Generates and runs a test script using the Prisma 7 PrismaPg adapter to confirm the database connection works before finishing. - Use Case: You start a new Node.js project and say "set up a Prisma Postgres database for this app" — the Skill provisions the database, configures Prisma 7 correctly, and verifies connectivity in one guided flow. ## Quick Start Ask the agent to set up a new Prisma Postgres database and connect it to this project, providing your workspace service token if you have one.

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, and extract the direct connection string from the response. Then write it to your .env file as DATABASE_URL and run prisma migrate dev.

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.

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 throws an error.

Why does Prisma 7 not use a url in schema.prisma?▼

Prisma 7 moved connection URLs out of the schema into prisma.config.ts, which loads DATABASE_URL from the environment via dotenv. The datasource block in schema.prisma should only declare provider = "postgresql".

What should I do when Prisma API returns a 401 authentication error?▼

A 401 authentication-failed error means your service token is invalid or expired. Create a new token in Prisma Console under Workspace Settings, Service Tokens, and use it in the Authorization Bearer header for all API requests.

When should I not use this database setup workflow?▼

Do not use it for CI/CD preview databases, multi-tenant provisioning inside an application, or databases that already exist and are connected. Those cases are covered by dedicated CI/CD and integrator workflows or standard Prisma CLI commands.

Related Skills

Explore More Software Engineering Skills→
rauell1rauell1
3

prisma-postgres

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

Community
Advanced
hugoguhugogu

prisma-migrations

Automate Prisma Migrate schema changes across development, staging, and production.

Community
Advanced
vecearvecear

preview-environments-builder

Automate ephemeral preview environments for pull requests in CI/CD pipelines.

Community
Advanced
TeamDay-AITeamDay-AI
2

mysql

Query and manage MySQL databases from the command line.

Official
Intermediate