My environment variable is not loading in Prisma

Question

Failed to load config file "F:\\Documents\\Desktop\\coding projects\\Shopify\\my-turborepo\\packages\\product-db" as a TypeScript/JavaScript module. Error: PrismaConfigEnvError: Missing required environment variable: DATABASE_URL

package.json

{
  "name": "@repo/product-db",
  "version": "0.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1",
    "db:generate": "prisma generate",
    "db:migrate": "prisma migrate dev --skip-generate",
    "db:deploy": "prisma migrate deploy"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "devDependencies": {
    "dotenv-cli": "^11.0.0",
    "prisma": "^6.19.0"
  },
  "dependencies": {
    "@prisma/client": "^6.19.0"
  }
}

.env file

DATABASE_URL="postgresql://admin:123456@localhost:5432/products?schema=public"

schema.prisma file

generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model Product {
  id               Int      @id @default(autoincrement())
  name             String
  shortDescription String
  description      String
  price            Int
  sizes            String[]
  colors           String[]
  images           Json
  createdAt        DateTime @default(now())
  updatedAt        DateTime @updatedAt
  categorySlug     String
  category         Category @relation(fields: [categorySlug], references: [slug])
}

model Category {
  id       Int       @id @default(autoincrement())
  name     String
  slug     String    @unique
  products Product[]
}

What is the solution for this?

Kishan Dobariya · Accepted Answer · 2025-11-10 11:21:37Z

0

Ensure .env is in the correct place, make sure your .env file is located here :

my-turborepo/
  packages/
    product-db/
      .env
      schema.prisma
      package.json

Use dotenv-cli in your Prisma scripts :

Update your package.json scripts inside packages/product-db/package.json like this:

"scripts": {
  "db:generate": "dotenv -e .env -- prisma generate",
  "db:migrate": "dotenv -e .env -- prisma migrate dev --skip-generate",
  "db:deploy": "dotenv -e .env -- prisma migrate deploy"
}

Run from inside the product-db package :

When running commands, cd into the package first:

cd packages/product-db
npm run db:generate

If you run Prisma from the monorepo root, Prisma may look for .env at the root, not in the product-db folder

answered Nov 10 at 11:21

Kishan Dobariya

1428 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codedkey_ · Accepted Answer · 2025-11-12 21:34:15Z

0

Install dotenv

npm i dotenv

Navigate to your prisma.config.ts file in your project. Add this line at the top:

import "dotenv/config";

Run the following:

npx prisma generate

answered Nov 12 at 21:34

codedkey_

463 bronze badges

Comments

Vlad · Accepted Answer · 2025-11-13 16:11:04Z

0

if you have .env file and it's located in the correct place, than you can try one more option without installing dotenv.
just remove prisma.config.ts (in case you don't need it):

When using prisma.config.ts, environment variables from .env files are not automatically loaded.

link: Prisma documentation

edited Nov 13 at 16:11

answered Nov 13 at 14:39

Vlad

6351 gold badge5 silver badges19 bronze badges

Comments

Shahbaz · Accepted Answer · 2025-11-15 19:02:30Z

0

TRY THIS METHOD, I HOPE IT WILL WORK

In older versions of Prisma, e.g, "^ 6.15.0". The Environment variables load automatically.

However, in the version you are using, Prisma "^6.19.0" in its ".env" file clearly states that Environment variables in this file will not be automatically loaded.

Please add import "dotenv/config"; to your prisma.config.ts

(For reference, I'm also adding the snapshot of the .env file instructions by Prisma at the end.)

# Environment variables declared in this file are NOT automatically loaded by Prisma.
# Please add `import "dotenv/config";` to your `prisma.config.ts` file, or use the Prisma CLI with Bun
# to load environment variables from .env files: https://pris.ly/prisma-config-env-vars.

edited Nov 15 at 19:02

answered Nov 15 at 18:54

Shahbaz

1111 gold badge2 silver badges7 bronze badges

2 Comments

piyush sharma Nov 19 at 8:13

It worked Thankyou

Shahbaz 2 days ago

Good to know Piyush , that it worked for you. Kindly accept my answer for your question so that other people can quickly find out the correct answer for the question.

Raj sharma · Accepted Answer · 2025-11-10 11:36:18Z

-1

If your environment (.env) isn’t loading, check the file path, ensure it’s in the project root, and restart your server.

answered Nov 10 at 11:36

Raj sharma

151 bronze badge

Collectives™ on Stack Overflow

My environment variable is not loading in Prisma

5 Answers 5

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related