skills.rest
Akhand0ps
Akhand0psCOMMUNITY
Explore all skills by this author →
GitHub

prisma-postgres-setup

Provisions Prisma Postgres databases via the Management API and connects them to local projects.

Updated Aug 31, 2026
Search Tags:#migration#orm#prisma#postgres#database provisioning#management api#connection string
One-click install
npx skills add https://github.com/Akhand0ps/vecta --skill prisma-postgres-setup-akhand0ps
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-setup
Source: https://github.com/Akhand0ps/vecta/tree/main/packages/db/.agents/skills/prisma-postgres-setup
Command: npx skills add https://github.com/Akhand0ps/vecta --skill prisma-postgres-setup-akhand0ps

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: Creates projects and databases through the Prisma Management API, including region selection, provisioning status polling, and named connections. - 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. - Prisma 7 client setup: Enforces the new driver adapter pattern (pg.Pool + PrismaPg adapter) and verifies the connection with a test script. - Use Case: You start a new Node.js project and say "set up a database" — the Skill provisions a Prisma Postgres instance in your chosen region, configures your project, runs the first migration, and confirms connectivity. ## Quick Start Ask the agent to set up a new Prisma Postgres database for this project and connect it locally using your 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, POST to /v1/projects 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 npx 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 a PrismaPg adapter, 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 removed implicit datasource resolution, so calling new PrismaClient() with no arguments throws, and the datasourceUrl option no longer exists. You must pass a driver adapter such as PrismaPg wrapping a pg.Pool.

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

A 401 authentication-failed response means the service token is invalid or expired. Create a new token in Prisma Console under Workspace Settings → Service Tokens, then retry the request with the new token in the Authorization Bearer header.

When should I not use this database setup workflow?▼

Do not use it for CI/CD preview databases, for building multi-tenant provisioning into an application, or when the database already exists and is connected. Those cases call for the CI/CD or integrator workflows, or standard Prisma CLI migration 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
Rational-PartnersRational-Partners
4

prisma-migrations

Create, deploy, and validate Prisma migrations with schema.prisma alignment.

Official
Advanced
FaysilAlshareefFaysilAlshareef
4

ef-migrations

Automate EF Core migration creation, application, and management in .NET projects.

Community
Advanced
TeamDay-AITeamDay-AI
2

mysql

Query and manage MySQL databases from the command line.

Official
Intermediate