Skip to content

Environment Variablesλ︎

Add an Heroku Postgres database to the Heroku app creates a DATABASE_URL configuration variable, an environment variable manged by Heroku. This configuration variable can be used to avoid including database connection details in the code repository.

Note:: Check your Heroku app has a DATABASE_URL configuration variableλ︎

List all the configuration variables for your app using the command:

heroku config

The DATABASE_URL contains your username and password for the database, as well as the hostname and database name in the form of:


Using PostgreSQL client applicationsλ︎

The Heroku Postgres database is available via an secure connection from anywhere on the Internet, so you can use these details with your favourite postgres client. The postgres client must connect over SSL, or the connection will be rejected by Heroku postgres.