How do I check the records of my heroku database?

Question

I've just deployed my application to heroku and pointed my custom domain to the heroku servers. How can I check the records in my heroku database?

heroku help shows all you can do – apneadiving Apr 28 '11 at 21:47 — apneadiving, Apr 28 '11 at 21:47

Andre Schweighofer · Accepted Answer · 2013-05-19T11:19:44.200

45

You can use heroku run rails console and look at your records with Model.all or any other method.

If you want to backup the database look at heroku PG backups, you then can import your database on your local machine and look at it there. Depending on your db adapter you could use sqlite browser for sqlite3 or phpmyadmin for MySQL.

edited May 19 '13 at 11:19

answered Apr 28 '11 at 21:45

Andre Schweighofer

2,759
1
26
25

is there anything that can present the records in a more organized way? – Justin Meltzer Apr 28 '11 at 21:49
i added informations about tools to view the database locally. hope this helps! – Andre Schweighofer Apr 28 '11 at 21:57
1

`heroku console` has been removed. – David Rhoden May 18 '13 at 21:08
8

**Warning:** The `heroku run` command spins up a one-off dyno. Any time spent executing a one-off dyno will contribute to usage and will be charged just like any other dyno if you go over your monthly 750 free dyno-hours. – Dennis Apr 07 '14 at 19:14

score 38 · Answer 2 · edited May 23 '17 at 11:54

38

I found a similar question like this and here is what @Chowlett says:

"You could run heroku pg:psql to fire up a Postgres console, then issue \d to see all tables, and \d tablename to see details for a particular table."

You can also type select * from tablename; to view the table contents.

How to view current database schema for Heroku app in Terminal?

edited May 23 '17 at 11:54

Community

1
1

answered Dec 29 '13 at 07:54

Daniel

2,950
2
25
45

score 4 · Answer 3 · answered Apr 29 '11 at 19:49

4

heroku db:pull to pull your production DB locally to take a peek in it.

answered Apr 29 '11 at 19:49

John Beynon

37,398
8
88
97

score 3 · Answer 4 · answered Jan 29 '15 at 01:33

3

I'll give the method for connecting via a GUI tool

Run the following command to get the database credentials from Heroku:

heroku pg:credentials DATABASE_URL

Then you can use a GUI tool like PG Commander or PGAdmin to connect to the db

answered Jan 29 '15 at 01:33

hexinpeter

1,470
1
16
14

Vishal · Answer 5 · 2015-11-04T07:40:08.917

3

Heroku now has an add-on named PostgreSQL Studio (currently free & in beta) that would let you access your database from within the browser, without having to use CLI, much like PHP MyAdmin.

To attach this add-on to your application,

heroku addons:create pgstudio

Then go to the list of add-ons on Heroku, select PostgreSQL Studio, authorize it, select the database to connect with from the dropdown list of all databases and it will take you to the web-based interface to handle your selected database.

You may refer to this official article on Heroku: https://devcenter.heroku.com/articles/pgstudio

edited Nov 04 '15 at 07:40

answered Nov 02 '15 at 10:14

Vishal

394
3
8

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – Drenmi Nov 03 '15 at 06:26
Thank you. I edited the answer to include the steps. – Vishal Nov 04 '15 at 07:42
This `pgstudio` is not available anymore. Any other solution new perhaps? Tried searching the whole Addons and no luck – Surveyor Jr Apr 02 '22 at 15:25

score 2 · Answer 6 · answered Dec 05 '14 at 05:53

2

The easy answer is:

heroku pg:info

answered Dec 05 '14 at 05:53

Nikhil

743
7
14

Works perfectly thanks! Gives: Rows: xxxx/10000 – Luke Jul 26 '17 at 14:29

score 1 · Answer 7 · edited Aug 01 '17 at 16:48

1

You can also download a client side Postgres, like Postico, and using the information provided in that URL to enter password and database name etc, then you can create locally, just like phpMyAdmin.

edited Aug 01 '17 at 16:48

Francisco

10,918
6
34
45

answered Feb 18 '16 at 20:55

Nate Sun

11
3

score 0 · Answer 8 · answered Dec 15 '16 at 22:52

0

You can use heroku dataclips that allows to run queries online. Here you can find documentation https://devcenter.heroku.com/articles/dataclips.

answered Dec 15 '16 at 22:52

Pavel Polushkin

358
2
8

score 0 · Answer 9 · answered Jul 04 '18 at 23:59

0

Connect to the database using Sequel Pro. You can find your ClearDB url using heroku config command. The structure for connecting is as follows:

CLEARDB_DATABASE_URL => mysql://[username]:[password]@[host]/[database name]?reconnect=true

answered Jul 04 '18 at 23:59

Connor Leech

18,052
30
105
150

score 0 · Answer 10 · answered Feb 21 '12 at 19:52

0

I use the admin_data gem, works well in Heroku.

answered Feb 21 '12 at 19:52

rtfminc

6,243
7
36
45

How do I check the records of my heroku database?

10 Answers10