prisma-upgrade-v7-env-variables

name	prisma-upgrade-v7-env-variables
description	Environment Variables
license	MIT
metadata	{"author":"prisma","version":"7.0.0"}

Environment Variables

Prisma v7 no longer automatically loads environment variables. You must load them explicitly.

The Change

v6 Behavior

Prisma CLI automatically loaded .env files.

v7 Behavior

You must manually load environment variables using dotenv or similar.

Setup

1. Install dotenv

npm install dotenv

2. Import in prisma.config.ts

import 'dotenv/config'  // Must be first import
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  datasource: {
    url: env('DATABASE_URL'),
  },
})

Bun Users

Bun automatically loads .env files. No additional setup needed:

// prisma.config.ts (Bun)
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  datasource: {
    url: env('DATABASE_URL'),
  },
})

Multiple .env Files

Using dotenv-cli

npm install -D dotenv-cli

{
  "scripts": {
    "db:migrate": "dotenv -e .env.local -- prisma migrate dev",
    "db:push": "dotenv -e .env.development -- prisma db push"
  }
}

Using dotenv with path

// 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'),
  },
})

Application Code

For your application, load env vars at startup:

Entry point

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

Or use dotenv explicitly

import { config } from 'dotenv'
config()

// Now process.env.DATABASE_URL is available

Removed Environment Variables

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)

TypeScript env() Helper

The env() function from prisma/config provides type safety:

import { env } from 'prisma/config'

// Type-safe environment variable access
const url = env('DATABASE_URL')  // string

Note: This only works within prisma.config.ts, not in your application code.

CI/CD Considerations

Ensure environment variables are set in your CI environment:

# GitHub Actions
env:
  DATABASE_URL: ${{ secrets.DATABASE_URL }}

steps:
  - run: npx prisma migrate deploy

No need for dotenv in CI if variables are set directly.