How to View PostgreSQL Data from Heroku App?

[nelsonic]

I googled for this question https://www.google.com/search?q=heroku+view+postgres+data
and the first 3 results were:

• https://devcenter.heroku.com/articles/heroku-postgresql
• https://stackoverflow.com/questions/20410873/how-can-i-browse-my-heroku-database
• https://devcenter.heroku.com/articles/connecting-to-heroku-postgres-databases-from-outside-of-heroku

The StackOverflow thread links to Heroku Data Explorer > renamed "Adminium"

• https://devcenter.heroku.com/articles/adminium
• https://elements.heroku.com/addons/adminium

But sadly, Adminium requires access to ALL environment variables on ALL Apps.

"Read and write access to all of your apps and resources, excluding account information. Includes configuration variables, which may include runtime secrets."

If it was limited to just the App I want to view data for, I would be fine with it.
But we have apps that have AWS credentials in Environment Variables, and there's no way I would grant access to those to anyone.

To be clear: I've been using Heroku for 8 years and querying the data using the CLI e.g: heroku pg:psql but that is definitely not "beginner friendly" or accessible to non-technical people (e.g: Product Owner)

I'm going to do a writeup of using PGAdmin to view/query Heroku PostgreSQL Data.

[nelsonic]

Closing. Not using anymore. ✅