[Prisma] Environment variable not found: DATABASE_URL

[ghost]

Describe the Bug (버그 설명)

prisma schema doesnt find the env variable

Version to Reproduce (현재 사용한 버전)

9.2

Steps to Reproduce (재현 순서)

prisma migrate dev --preview-feature

Prisma schema loaded from src\prisma\schema.prisma
Error: Schema validation error - Error (query-engine-node-api library)
Error code: P1012
error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:6
   | 
 5 |   provider = "sqlite"
 6 |   url      = env("DATABASE_URL")
   | 

Validation Error Count: 1
[Context: getConfig]

Prisma CLI Version : 4.5.0

[ghost]

Are there any workarounds to fix the issue? thanks.

[ahmadabbas02]

Are there any workarounds to fix the issue? thanks.

I found a workaround by using dotenv cli as shown in prisma docs, you can find information here

In my case: dotenv -e .env.development.local -- prisma migrate dev --preview-feature

[ljlm0402]

@HijackHornet

Thank you for good information.
We will reflect it after correction soon

[anthonydibi]

Still not fixed