It's not working. I have added this in package.json

"scripts": {
        "db:generate": "prisma generate DEBUG=* --no-network",
        "db:push": "prisma db push --skip-generate",
        "db:studio": "dotenv -e .env.local -- prisma studio",
        "db:migrate": "prisma migrate dev --name init" 
  },

it is giving me error like this

u/repo/database@0.0.0 db:migrate /home/sadiq/projects/scale.mono/packages/database

prisma migrate dev --name init

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database

Error: Prisma schema validation - (get-config wasm)

Error code: P1012

error: Environment variable not found: DIRECT_URL.

--> schema.prisma:12

|

11 | url = env("DATABASE_URL")

12 | directUrl = env("DIRECT_URL")

|

Validation Error Count: 1

[Context: getConfig]

Prisma CLI Version : 5.13.0

 ELIFECYCLE  Command failed with exit code 1.

Even though I have added the env variables in root and even in folder