← Back to Postgres GUI FAQs

How to Connect to a PostgreSQL Database

The Postgres GUI supports two connection methods. Use whichever is more convenient for your setup.

Method 1: Connection URL (Scheme Mode)

  1. Open the Postgres GUI tool.
  2. Make sure the "Scheme" tab is selected.
  3. Paste your PostgreSQL connection string:
postgresql://username:password@host:5432/database_name

Click Connect. The tool will test the connection and load your tables.

Method 2: Individual Fields (Standard Mode)

  1. Switch to the "Standard" tab.
  2. Fill in the fields:
  • Host — your server address (e.g. localhost or db.example.com)
  • Port — usually 5432
  • Username — your database user
  • Password — the user's password
  • Database — the database name
  • SSL — choose the appropriate mode for your server

Click Connect to establish the connection.

Troubleshooting

  • Make sure your PostgreSQL server allows remote connections if connecting from outside
  • Check that the user has CONNECT privilege on the target database
  • For cloud databases, ensure your IP is whitelisted in the firewall rules
  • If you get an SSL error, try switching the SSL mode to require