skills.rest
samu412
samu412COMMUNITY
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 Aug 7, 2026
Search Tags:#migration#orm#prisma#postgres#database provisioning#management api#connection string
One-click install
npx skills add https://github.com/samu412/Development_kisan_basket --skill prisma-postgres-setup-samu412
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-setup
Source: https://github.com/samu412/Development_kisan_basket/tree/main/category_kisan_basket/.agents/skills/prisma-postgres-setup
Command: npx skills add https://github.com/samu412/Development_kisan_basket --skill prisma-postgres-setup-samu412

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 - API-driven provisioning: Authenticates with a service token, lists available regions, creates a project with a database, and polls until the database status is ready. - Local project configuration: Installs required packages, writes the direct connection string to .env, scaffolds prisma/schema.prisma and prisma.config.ts, and runs prisma migrate dev. - Connection verification: Generates and runs a test script using the Prisma 7 pg 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, runs the initial migration, and verifies connectivity. ## Quick Start Ask the agent to set up a new Prisma Postgres database and connect it to your current 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, POST to /v1/projects with createDatabase set to true, then extract the direct connection string from the response. Write it to .env as DATABASE_URL and run npx 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?▼

Create a pg.Pool with your DATABASE_URL, wrap it in a PrismaPg adapter from @prisma/adapter-pg, and pass { adapter } to the PrismaClient constructor. Import the client from ./generated/prisma/client.js and ensure package.json has "type": "module".

Why does new PrismaClient() throw an error in Prisma 7?▼

Prisma 7 requires a driver adapter, so calling new PrismaClient() with no arguments throws. The datasourceUrl option no longer exists either. You must pass a driver adapter such as PrismaPg wrapping a pg.Pool.

What should I do when Prisma Postgres database creation hits a limit?▼

List existing projects with GET /v1/projects, present them to the user, and delete an unneeded project via DELETE /v1/projects/{projectId}. Then retry the project creation request.

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

Avoid it for CI/CD preview databases, multi-tenant provisioning built into an application, or databases that already exist and are connected. Those cases use dedicated CI/CD or integrator flows, and schema work on existing databases uses the standard Prisma CLI.

Related Skills

Explore More Software Engineering Skills→
prismaprisma
51

prisma-postgres-setup

Provision a Prisma Postgres database via the Management API and connect it locally.

Official
Advanced
mattbutlerengineeringmattbutlerengineering
1

prisma-migrations

Automate Prisma schema migrations with version-controlled change management.

Community
Advanced
dennisonbertramdennisonbertram
1

neon-branching

Provisions Neon serverless Postgres branches per pull request.

Community
Advanced
Sake-TeamSake-Team

videodb

Analyze videos and monitor RTSP live feeds via the VideoDB API.

Official
Advanced