Powering next gen AI apps with Postgres 🚀 Learn More

Connect a GUI application

Learn how to connect a GUI application to Neon

This topic describes how to connect to a Neon database from a GUI application or IDE. Most GUI applications and IDEs that support connecting to a Postgres database also support connecting to Neon.

Gather your connection details

The following details are typically required when configuring a connection:

  • hostname
  • port
  • database name
  • role (user)
  • password

You can gather these details from the Connection Details widget on the Neon Dashboard. Select a branch, a role, and the database you want to connect to. A connection string is constructed for you.

Connection details widget


Neon supports pooled and direct connections to the database. Use a pooled connection string if your application uses a high number of concurrent connections. For more information, see Connection pooling.

The connection string includes the role, password, hostname, and database name.

  • role: daniel
  • hostname: ep-raspy-cherry-95040071.us-east-2.aws.neon.tech
  • database name: neondb

Neon uses the default Postgres port, 5432.

Connect to the database

In the GUI application or IDE, enter the connection details into the appropriate fields and connect. Some applications permit specifying a connection string while others require entering connection details into separate fields. In the pgAdmin example below, connection details are entered into separate fields, and clicking Save establishes the database connection.

Register - Server

Some Java-based tools that use the pgJDBC driver for connecting to Postgres, such as DBeaver, DataGrip, and CLion, do not support including a role name and password in a database connection string or URL field. When you find that a connection string is not accepted, try entering the database name, role, and password values in the appropriate fields in the tool's connection UI when configuring a connection to Neon. For example, the DBeaver client has a URL field, but connecting to Neon requires specifying the connection details as shown:

DBeaver connection

Tested GUI applications and IDEs

Connections from the GUI applications and IDEs in the table below have been tested with Neon.


Some applications require an Server Name Indication (SNI) workaround. Neon uses compute endpoint domain names to route incoming connections. However, the Postgres wire protocol does not transfer the server domain name, so Neon relies on the Server Name Indication (SNI) extension of the TLS protocol to do this. Not all application clients support SNI. In these cases, a workaround is required. For more information, see Connection errors.

Application or IDENotes
AWS Database Migration Service (DMS)Use SNI workaround D. Use a $ character as a separator between the endpoint option and password. For example: endpoint=<endpoint_id>$<password>. Also, you must set Secure Socket Layer (SSL) mode to require. See Migrate with AWS DMS.
Azure Data StudioRequires the PostgreSQL extension and SNI workaround D
Beekeeper StudioRequires the Enable SSL option
DatagranRequires SNI workaround D connection workaround
DronaHQ hosted cloud versionRequires selecting Connect using SSL when creating a connector
Forest AdminThe database requires at least one table
GrafanaRequires sslmode=verify-full. See SNI workaround C.
Google Looker StudioRequires Enable SSL and uploading the ISRG Root X1 self-signed pem root certificate from Let's Encrypt. See Connect to Looker Studio, in the Neon Community forum.
ILLA Cloud
Luna ModelerRequires enabling the SSL/TLS option
PopSQLNo SNI support. Use SNI workaround D.
PosticoSNI support since v1.5.21. For older versions, use SNI workaround B.
PostgreSQL VS Code Extension by Chris Kolkman
pgAdmin 4
TablePlusSNI support on macOS since build 436, and on Windows since build 202. No SNI support on Linux currently. For older versions, use SNI workaround B.
SegmentRequires SNI workaround D

Connection issues

Applications that use older client libraries or drivers that do not support Server Name Indication (SNI) may not permit connecting to Neon. If you encounter the following error, refer to Connection errors for possible workarounds.

Need help?

Send a request to support@neon.tech, or join the Neon community forum.

Edit this page
Was this page helpful?