OverviewHistoryStatsSecurity
npx skills add ...
Documentation
SKILL.md
npx skills add prisma/cursor-plugin --skill prisma-upgrade-v7-env-variables
Environment Variables
npx skills add prisma/cursor-plugin --skill prisma-upgrade-v7-env-variables
Prisma v7 no longer automatically loads environment variables. You must load them explicitly.
Prisma CLI automatically loaded .env files.
You must manually load environment variables using dotenv or similar.
Bun automatically loads .env files. No additional setup needed:
For your application, load env vars at startup:
These Prisma-specific env vars are removed in v7:
| Removed Variable | Alternative |
|---|---|
PRISMA_CLI_QUERY_ENGINE_TYPE | Not needed (no engines) |
PRISMA_CLIENT_ENGINE_TYPE | Not needed (no engines) |
PRISMA_QUERY_ENGINE_BINARY | Not needed |
PRISMA_QUERY_ENGINE_LIBRARY | Not needed |
PRISMA_GENERATE_SKIP_AUTOINSTALL | Not needed |
PRISMA_SKIP_POSTINSTALL_GENERATE | Not needed |
PRISMA_GENERATE_IN_POSTINSTALL | Not needed |
PRISMA_GENERATE_DATAPROXY | Use --no-engine flag |
PRISMA_GENERATE_NO_ENGINE | Use --no-engine flag |
PRISMA_CLIENT_NO_RETRY | Configure on adapter |
PRISMA_MIGRATE_SKIP_GENERATE | Not needed (auto-generate removed) |
PRISMA_MIGRATE_SKIP_SEED | Not needed (auto-seed removed) |
The env() function from prisma/config provides type safety:
Note: This only works within prisma.config.ts, not in your application code.
Ensure environment variables are set in your CI environment:
No need for dotenv in CI if variables are set directly.
// prisma.config.ts (Bun)
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
datasource: {
url: env('DATABASE_URL'),
},
})npm install -D dotenv-cli{
"scripts": {
"db:migrate": "dotenv -e .env.local -- prisma migrate dev",
"db:push": "dotenv -e .env.development -- prisma db push"
}
}// prisma.config.ts
import { config } from 'dotenv'
import path from 'path'
// Load specific .env file
config({ path: path.join(__dirname, '.env.local') })
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
datasource: {
url: env('DATABASE_URL'),
},
})// index.ts
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 })import { config } from 'dotenv'
config()
// Now process.env.DATABASE_URL is availableimport { env } from 'prisma/config'
// Type-safe environment variable access
const url = env('DATABASE_URL') // string# GitHub Actions
env:
DATABASE_URL: ${{ secrets.DATABASE_URL }}
steps:
- run: npx prisma migrate deploy