prisma-upgrade-v7-env-variables

// 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 available

import { 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