How to view your data in PlanetScale?
Is there really no table editor view, similar to Prisma Studio, in PlanetScale? I assume there is only access via the web console, which is kind of a bummer. Anyways I can't view my data in the web console. Following the directions here https://planetscale.com/docs/concepts/web-console, I entered SHOW TABLES; into the console. That gave me my list of tables. Then I ran DESCRIBE USERS; into the console, then it gave my an error that that table does not exist, even though it shows up in the results from SHOW TABLES;. What am I doing wrong here?
1 Reply
If you link your planetscale prod db as your db in your .env file then you can use prisma studio
Just be careful, if you don’t have the link down somewhere if you request to see the password I think it makes a new one, so then you would have to update it anywhere you are using it