Navicat is a popular GUI for database administration. In this recipe, you will learn how to set up a connection to your Heroku Postgres database in Navicat.
To start, you'll first need to download and install Navicat. For this recipe, you'll need a version of Navicat that is compatible with Postgres.
You can either use Navicat for Postgres or you can use Navicat Essentials. The essentials version is a less-expensive edition of Navicat with a limited feature set aimed at more basic database administration tasks.
The download and installation instructions are available here:
Navicat for Postgres at http://www.navicat.com/products/navicat-for-postgresql
Navicat Essentials at http://www.navicat.com/products/navicat-essentials