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. You can find all connection details in the details page of your ElephantSQL Console.

URL structure

postgres://username:password@hostname/databasename

Example URL

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

  • Name: Name of the set up, for example ElephantSQL
  • Host name/address: 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
  • Username: Username for your database, in this case: roxvyxky
  • Password: Password for your database.
  • postgres database