CODEWITHSUNDEEP
databaseherokuheroku-postgres
Andrew
Andrew

Reputation: 3989

How can I browse my Heroku database?

Now that I've deployed my webapp to Heroku, how would I be able to browse the database as it's altered over time?

Upvotes: 46

Views: 59573

Answers (5)

Stephy
Stephy

Reputation: 13

Install Beekeeper Studio. Connect to POSTGRES_URL of Heroku with "SSL" enabled.

Easy to view enter image description here

Upvotes: 0

Abhishek
Abhishek

Reputation: 682

Download PgAdmin 4 and configure your heroku database credentials. Right click on Servers link and choose create >> server. On General tab give Name as per your wish and on Connection tab enter Hostname/address, address, Maintenance database (database name), Username and password which is given in Heroku dabase credentials page. And you will be able to access heroku dadabase on UI free of cost.

Upvotes: 11

Ndeto
Ndeto

Reputation: 315

I use a tool called Adminer to connect to the DB. The problem is that Heroku will change the credentials for the DB occasionally. You can find them by visiting the Resources tab on your Dashboard then clicking on the DB you use.

It will take you to the Addons page in another tab. Click on the Settings tab then View Credentials.

Using these credentials, you can use Adminer to login to the DB.

Upvotes: 0

Lauris
Lauris

Reputation: 345

If you want to browse your Heroku PostgreSQL database using a browser there is now a free tool for that called Heroku Data Explorer: https://datazenit.com/heroku-data-explorer.html

It uses Heroku API in real time so your data/credentials stay secure and private. Also it has excellent performance because Heroku local network is used for database connections.

Upvotes: 20

James Kingsbery
James Kingsbery

Reputation: 7486

Try heroku pg:psql. For instructions for how to do this, see this.

Upvotes: 40

Related Questions