If you open your App in Hatchbox, click on Resources -> Database and all the details for connecting to your database will be listed there.
How can I manually backup my app database?
Backing up your database manually is pretty easy but takes a couple steps.
To find your Database
First, SSH into your server. Then we'll run pg_dump to dump our database. This will make a compressed dump of our database so it's smaller and easier to manage.