I start using the prisma studio desktop app (for mac): in my schema I have set the url to

url = env("POSTGRES_URL")

to work with local, dev and prod environments without manually set the url into the schema. The app says

error: Environment variable not found: POSTGRES_URL.

It works fine if I open prisma studio from the terminal. Is there I way to add e.g 3 urls that I can select, to quickly work with the app on local, dev and prod? Do I miss anything? Otherwise I would need to add the full url directly to the schema each time, which is not very handy.

@Henri Kuper 👋 This works fine in the latest version of Studio (0.394.0). Could you update to the latest version and restart the app to check?

I think I am on the latest version. At least the version number says 0.394.0

Ohh. Could you restart the app and check again?

@Ryan did not change anything…

@Henri Kuper works fine on the latest version. Tried with SQLite and used env variables.

Still the same error. I use postgres. Does the .env need to be stored in the same folder as the schema.prisma?

My

.env

is stored in the root of the project and I’m using the latest version of Studio as above.

ok in this case, we have the same setup. And as you said I am using a fresh installed 0.394.0 from the prisma website

Yup works fine 😄

mhm.. any other idea? I guess the app comes along with its on prisma version? Because the repo itself still works with prisma 2.20.1. That should cause the issue I have right?

I have the latest version of

prisma

. Maybe that’s causing some issue

I will, but not today 😄 need some time to solve the breaking changes from 2.20 to 2.25