Labsco
prisma logo

prisma-database-setup-postgresql

✓ Official★ 8

by prisma · part of prisma/cursor-plugin

PostgreSQL Setup. Reference when using this Prisma feature.

🔥🔥🔥✓ VerifiedFreeAdvanced setup
#database#git
🧩 One of 7 skills in the prisma/cursor-plugin package — works on its own, and pairs well with its siblings.

PostgreSQL Setup. Reference when using this Prisma feature.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by prisma

PostgreSQL Setup. Reference when using this Prisma feature. npx skills add https://github.com/prisma/cursor-plugin --skill prisma-database-setup-postgresql Download ZIPGitHub8

3. Environment Variable

In .env:

Copy & paste — that's it
DATABASE_URL="postgresql://user:password@localhost:5432/mydb?schema=public"

Connection String Format

Copy & paste — that's it
postgresql://USER:PASSWORD@HOST:PORT/DATABASE?schema=SCHEMA

  • USER: Database user

  • PASSWORD: Password (URL encoded if special chars)

  • HOST: Hostname (localhost, IP, or domain)

  • PORT: Port (default 5432)

  • DATABASE: Database name

  • SCHEMA: Schema name (default public)

Driver Adapter (Prisma ORM 7 required)

Prisma ORM 7 uses the query compiler by default, so you must use a driver adapter.

Install adapter and driver:

Copy & paste — that's it
npm install @prisma/adapter-pg pg

Instantiate Prisma Client with the adapter:

Copy & paste — that's it
import 'dotenv/config'
import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })
const prisma = new PrismaClient({ adapter })