Log in to the Heroku dashboard. You should see a list of your apps.
In this example the app we want to connect to the database for is called
Click into the app. In Heroku, database are attached to instances as Add-Ons but can also be accessed in the Resources page.
You will open the datastore settings in a new tab and be greeted by an Overview screen. Click over to the Settings tab for the Datastore to see a link to Database Credentials.
To view the credentials for accessing Postgres, click the link to expand them.
Important: Heroku has encryption turned on by default so you will need to select SSL when using a SQL client like Arctype to connect to your Heroku Postgres database.