How do I view a PostgreSQL database on heroku with a GUI?

Question

I have a rails app on heroku that is using a Postgre database. My database has > 40 tables and > 10,000 rows. I would like to delete a lot of data, but it would be much easier if I was able to view and interact with it in a GUI table. I can access my data in rails console, but it's taking too long.

Answer 1

pgweb is a great cross-platform GUI, and it's easy to connect to your Heroku Postgres when launching from the command line.

I installed via Homebrew on a Mac (brew install pgweb), but instructions for other platforms are listed on the site. Here's how I launch pgweb connected to a Heroku Postgres DB:

heroku config:get DATABASE_URL | xargs pgweb --url

And if you want to connect to your localhost:

pgweb --host localhost

Answer 2

I'm a little late here, but this may help someone else who stumbles across this thread...

If you go to your Heroku app's dashboard (through the website) > settings > "Reveal Config Vars" > DATABASE_URL, and paste that URL into the browser.

I use TablePlus for database management, when I paste the link into the browser it asks if it can open TablePlus and then I can edit my production database in real time just like I would in development.

I'm not sure what pasting the URL into the browser will do if you don't have TablePlus. I assume it will request to open any other SQL management app you might have.