Setting the file. One moment.
Chapter 09 · Prisma Upgrade V7
Subchapter 9.5
references/prisma-config.mdMarkdown3 KBView on GitHub
Prisma v7 introduces prisma.config.ts as the central configuration file for the Prisma CLI.
Place prisma.config.ts at your project root (next to package.json).
import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
schema: 'prisma/schema.prisma',
migrations: {
path: 'prisma/migrations',
},
datasource: {
url: env('DATABASE_URL'),
},
})Path to your Prisma schema file:
schema: 'prisma/schema.prisma'Database connection URL:
datasource: {
url: env('DATABASE_URL'),
}Direct connection URL (bypassing connection pooler):
datasource: {
url: env('DATABASE_URL'),
directUrl: env('DIRECT_DATABASE_URL'),
}Shadow database for migrations:
datasource: {
url: env('DATABASE_URL'),
shadowDatabaseUrl: env('SHADOW_DATABASE_URL'),
}Directory for migration files:
migrations: {
path: 'prisma/migrations',
}Seed command for prisma db seed:
migrations: {
path: 'prisma/migrations',
seed: 'tsx prisma/seed.ts',
}import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
// Schema location
schema: 'prisma/schema.prisma',
// Migration configuration
migrations: {
path: 'prisma/migrations',
seed: 'tsx prisma/seed.ts',
},
// Database connection
datasource: {
url: env('DATABASE_URL'),
directUrl: env('DIRECT_DATABASE_URL'),
shadowDatabaseUrl: env('SHADOW_DATABASE_URL'),
},
})Use env() to reference environment variables:
import { env } from 'prisma/config'
datasource: {
url: env('DATABASE_URL'),
}This provides type safety but does NOT load .env files automatically.
Install and import dotenv:
npm install dotenvimport 'dotenv/config' // Must be first import
import { defineConfig, env } from 'prisma/config'datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
}import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
schema: 'prisma/schema.prisma',
datasource: {
url: env('DATABASE_URL'),
directUrl: env('DIRECT_URL'),
},
})And update schema.prisma:
datasource db {
provider = "postgresql"
// URLs now in prisma.config.ts
}Use --config flag with CLI commands:
prisma migrate dev --config ./config/prisma.config.tsimport 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
import path from 'path'
export default defineConfig({
schema: path.join(__dirname, 'packages/database/prisma/schema.prisma'),
migrations: {
path: path.join(__dirname, 'packages/database/prisma/migrations'),
},
datasource: {
url: env('DATABASE_URL'),
},
})