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

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 working, verified 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 extracts the direct connection string from the Management API. - Local project configuration: Installs required packages, writes DATABASE_URL to .env, scaffolds prisma/schema.prisma and prisma.config.ts, and runs the initial migration. - Prisma 7 client setup: Configures the pg driver adapter pattern and verifies the connection with a test script before finishing. - Use Case: You just created a new Node.js app and need a hosted Postgres database. Ask the agent to set up Prisma Postgres, pick a region from the interactive menu, and within minutes you have a migrated schema and a verified connection. ## 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, 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 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 my Prisma Management API request return 401 authentication-failed?▼

A 401 means the service token is missing, invalid, or expired. Create a new token in Prisma Console under Workspace Settings, Service Tokens, and pass it as a Bearer token in the Authorization header of every request.

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 belong to dedicated CI/CD or integrator workflows, while schema changes on existing databases use standard Prisma CLI commands.

Related Skills

Explore More Software Engineering Skills→
truongnattruongnat

prisma-postgres

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

Community
Advanced
Rational-PartnersRational-Partners
4

prisma-migrations

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

Official
Advanced
vecearvecear

preview-environments-builder

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

Community
Advanced
lawalletiolawalletio
3

prisma-postgres

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

Official
Advanced