Setting the file. One moment.
Skill 04 · Prisma Database Setup
Subchapter 4.6
references/prisma-postgres.mdMarkdown3 KBView on GitHub
Prisma Postgres is a serverless, managed PostgreSQL database optimized for Prisma.
You can provision a Prisma Postgres instance directly via the CLI:
prisma init --dbThis will:
.env with the connection string.For Prisma CLI flows and Accelerate-style usage, you may see a prisma+postgres:// URL.
For Prisma Client with a driver adapter in Node.js, prefer the direct TCP connection string from the Prisma Postgres dashboard:
DATABASE_URL="postgres://identifier:key@db.prisma.io:5432/postgres?sslmode=require"In prisma/schema.prisma:
datasource db {
provider = "postgresql" // Use postgresql provider
}
generator client {
provider = "prisma-client"
output = "../generated"
}In prisma.config.ts:
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
schema: 'prisma/schema.prisma',
datasource: {
url: env('DATABASE_URL'),
},
})Use a driver adapter for Prisma Postgres in the standard SQL workflow.
Install adapter and driver:
npm install @prisma/adapter-pg pgUse the direct TCP connection string from Prisma Console:
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 })PrismaPg also accepts the connection string directly:
const adapter = new PrismaPg(process.env.DATABASE_URL!)
const prisma = new PrismaClient({ adapter })For PostgreSQL prepared statement naming, pass adapter options as the second argument:
import { createHash } from 'node:crypto'
const adapter = new PrismaPg(process.env.DATABASE_URL!, {
statementNameGenerator: ({ sql }) =>
`prisma_${createHash('sha1').update(sql).digest('hex').slice(0, 16)}`,
})Use the Prisma Postgres serverless driver only when you need HTTP/WebSocket transport in environments like Workers or Edge Functions:
npm install @prisma/adapter-ppg @prisma/ppgimport { PrismaClient } from '../generated/client'
import { PrismaPostgresAdapter } from '@prisma/adapter-ppg'
const prisma = new PrismaClient({
adapter: new PrismaPostgresAdapter({
connectionString: process.env.PRISMA_DIRECT_TCP_URL,
}),
})This serverless driver is the specialized path for HTTP/WebSocket-based edge and serverless runtimes, not the default recommendation for standard Node.js apps.
Use the Prisma Postgres adapter shown above when instantiating Prisma Client.