How do I access Prisma Studio for my Wasp app that I've deployed on Fly.io?
Hi all, like the title asks, how can I access the Prisma Studio to view / modify database records for a Wasp app that's been deployed to Fly.io?
KHi @jason. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
K----------------------
To access Prisma Studio for your Wasp app deployed on Fly.io, you'll need to follow these steps:
Important notes:
If you encounter any issues or need more detailed instructions, please let me know.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
To access Prisma Studio for your Wasp app deployed on Fly.io, you'll need to follow these steps:
- Open a tunnel to your Fly.io database using the following command:```fly proxy 5432 -a <db-name>```Replace `<db-name>` with your Fly.io database app name.
- In a new terminal tab, set the `DATABASE_URL` environment variable to connect to your production database. You'll need to use the database credentials you received when first deploying your app to Fly.io. The format should be:```DATABASE_URL=postgres://<user>:<pw>@localhost:5432/<db_name>?sslmode=disable```
- Once the tunnel is open and you've set the `DATABASE_URL`, you can run Prisma Studio using the Wasp CLI command:```wasp db studio```
Important notes:
- Be cautious when interacting with your production database, as any changes you make will affect your live app.
- After you're done, remember to close the tunnel and remove the
from your local environment to avoid accidentally connecting to the production database later.DATABASE_URL
If you encounter any issues or need more detailed instructions, please let me know.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
KSorry @jason, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist:
Perhaps try again in 15mins?
Perhaps try again in 15mins?
MHave you tried what the bot suggested? 
JI wasn't able to do so exactly as described unfortunatly, it would have been nice to use the Prisma Studio, but I managed to connect directly to postgre via the shell :)
