I wrote a guide on connecting Hasura + Forest admin for no-code SaaS apps + admin backends:
"14. Connect Forest Admin to Hasura & Postgres"
http://hasura-forest-admin.surge.sh/#/?id=_14-connect-forest...
For Heroku specifically you need to make sure that the client attempting to connect does it over SSL, so set SSL mode if possible (many clients will do this by-default).
To get the connection string for pasting into Forest Admin config, run this:
heroku config | grep HEROKU_POSTGRESQL
That should give you a connection string you can copy + paste to access externally from Heroku: HEROKU_POSTGRESQL_YELLOW_URL: postgres://user3123:passkja83kd8@ec2-117-21-174-214.compute-1.amazonaws.com:6212/db982398
https://devcenter.heroku.com/articles/heroku-postgresql#exte...