pgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL.

Below is an example of how to set up a connection to pgAdmin. Go to the details page for your instance and copy the URL.

URL structure

postgres://username:password@hostname/databasename

Example URL

postgres://roxvyxky:CaCHvDgMsN8NKdbu6dvD@babar.elephantsql.com:5432/roxvyxky

  • Name: Name of the set up
  • Host: Hostname of the database, in this case: babar.elephantsql.com
  • Port: Port to the database, 5432
  • Maintenance DB: The name of your database, in this case: roxvyxky
  • Password: Password for your instance, in this case: CaCHvDgMsN8NKdbu6dvD
  • postgres database