prisma-database-setup-prisma-postgres

Prisma Postgres Setup

Configure Prisma with Prisma Postgres (Managed).

Overview

Prisma Postgres is a serverless, managed PostgreSQL database optimized for Prisma.

Setup via CLI

You can provision a Prisma Postgres instance directly via the CLI:

prisma init --db

This will:

1. Log you into Prisma Data Platform.
2. Create a new project and database instance.
3. Update your .env with the connection string.

Connection String

The connection string starts with prisma+postgres://.

DATABASE_URL="prisma+postgres://api_key@host.prisma-data.net/env_id"

1. Schema Configuration

In prisma/schema.prisma:

datasource db {
  provider = "postgresql" // Use postgresql provider
}

generator client {
  provider = "prisma-client"
  output   = "../generated"
}

2. Config Configuration

In prisma.config.ts:

import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  schema: 'prisma/schema.prisma',
  datasource: {
    url: env('DATABASE_URL'),
  },
})

Driver Adapter (Prisma ORM 7 required)

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

1. Install adapter and driver:

   npm install @prisma/adapter-ppg @prisma/ppg
   

2. Use a direct TCP connection string for the adapter (from the Prisma Console) and instantiate Prisma Client:

   import 'dotenv/config'
   import { PrismaClient } from '../generated/client'
   import { PrismaPostgresAdapter } from '@prisma/adapter-ppg'
   
   const prisma = new PrismaClient({
     adapter: new PrismaPostgresAdapter({
       connectionString: process.env.PRISMA_DIRECT_TCP_URL,
     }),
   })
   

Features

• Serverless: Scales to zero.
• Caching: Integrated query caching (Accelerate).
• Real-time: Database events (Pulse).

Using with Prisma Client

Since Prisma ORM 7 requires a driver adapter, use the Prisma Postgres adapter shown above when instantiating Prisma Client.