Need to use custom env files for accessing environment variables in schema.prisma datasource.

[parab-bloom]

Question

I have multiple env files named (let's say) dev.env, prod.env, stage.env
I am using these files in my app. Now, when I am trying to perform prisma pull it is only supporting .env file custom files are not allowed.
To rectify this, I wrote script to perform prisma pull, in this also when I am performing pull for multiple dbs command is separated by && operator. Here, too only first command is getting my environment variables, all other files are not.
Can any one help me with this one.
How can I use custom env files while performing prisma db pull ?

How to reproduce (optional)

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[janpio]

https://www.npmjs.com/package/dotenv-cli is a good tool to load any .env files when calling Prisma CLI.

[dejurin]

For example

dotenv -e .env.local -- npx prisma generate