Hey guys, I am mutating

process.env.DATABASE_URL

before creating a Prisma client instance like

process.env.DATABASE_URL = ...

but unfortunately this results in

error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:11
   | 
10 |   provider = "mysql"
11 |   url      = env("DATABASE_URL")
   |

Any idea what I can do?

I ran into the same problem earlier in my dev with Prisma. What helped was to make sure my

.env

file was being read properly.

// in package.json
  "start": "ts-node-dev -r dotenv/config src/index.ts",

  "dependencies": {
     "dotenv": "^10.0.0", // Using dotenv
   }

// in .env
DATABASE_URL="..."

I have a bit of a rare case where I fetch parameters from AWS Parameter Store because I'm doing Green/Blue deployment with GitHub actions + CodeDeploy EC2, I cannot use a .env file 😕

/**
 * Load and set environment variables from AWS Parameter Store file, see: scripts/start_server.sh
 */
export function env() {
  const json: Record<"Parameters", Parameter[]> = JSON.parse(
    fs.readFileSync(".env.json", "utf8")
  )

  json.Parameters.forEach((p) => {
    const key = p.Name.split("/").pop()

    if (key) {
      process.env[key] = p.Value
    }
  })
}

Could you try adding it to both of these and check?

process.env.DATABASE_URL = `URL`
this.global.process.env.DATABASE_URL = `URL`