Prisma Database Setup

When to Apply

• Initializing a new Prisma project
• Switching database providers
• Configuring connection strings and environment variables
• Troubleshooting database connection issues
• Setting up database-specific features
• Generating and instantiating Prisma Client

System Prerequisites (Prisma ORM 7)

• Node.js 20.19.0+
• TypeScript 5.4.0+

Bun Runtime

bunx --bun prisma ...

Supported Databases

postgresql

mysql

sqlite

mongodb

sqlserver

cockroachdb

postgresql

Configuration Files

1. prisma/schema.prisma

   : Defines the

   datasource

   block.

2. prisma.config.ts

   : Configures the connection URL (replaces env loading in schema).

Driver Adapters (Prisma ORM 7)

PrismaClient

@prisma/adapter-pg

pg

@prisma/adapter-pg

pg

@prisma/adapter-ppg

@prisma/ppg

@prisma/adapter-mariadb

mariadb

@prisma/adapter-better-sqlite3

better-sqlite3

@prisma/adapter-libsql

@libsql/client

@prisma/adapter-mssql

node-mssql

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 })

Prisma Client Setup (Required)

1. Install Prisma CLI and Prisma Client:
   bash

   npm install prisma --save-dev
   npm install @prisma/client

2. Add a generator block (output is required in Prisma v7):
   prisma

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

3. Generate Prisma Client:
   bash

   npx prisma generate

4. Instantiate Prisma Client with the database-specific driver adapter:
   typescript

   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 })

5. Re-run

   prisma generate

   after every schema change.

Quick Reference

PostgreSQL

datasource db {
  provider = "postgresql"
}

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

MySQL

datasource db {
  provider = "mysql"
}

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

SQLite

datasource db {
  provider = "sqlite"
}

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

MongoDB (Prisma v6 only)

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

Rule Files

rules/postgresql.md
rules/mysql.md
rules/sqlite.md
rules/mongodb.md
rules/sqlserver.md
rules/cockroachdb.md
rules/prisma-postgres.md
rules/prisma-client-setup.md