2

I know Heroku has a command line client to execute a .sql file.

But is there something like an SQL Server Management Studio for databases deployed at Heroku? I was looking for a UI that allows you to interactively write queries, execute them, and view the results on a grid. I'll mostly execute SELECTs and UPDATEs based on ids, over databases generated by Rails.

Community
  • 1
  • 1
dialex
  • 2,706
  • 8
  • 44
  • 74

2 Answers2

3

Have a look at Adminium: it's a free control panel plugin for Heroku.

https://addons.heroku.com/adminium

Max Williams
  • 32,435
  • 31
  • 130
  • 197
2

Take a look at http://www.pgadmin.org/ and install pgAdmin III. I use it for the same purpose, watch and query over the database of one of my Heroku apps.

francordie
  • 608
  • 5
  • 11