Connect a GUI or IDE
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 PostgreSQL database also support connecting to Neon.
Gather your connection details
The following details are typically required when configuring a connection:
- database name
- user name
You can gather most of these details from the Connection Details widget on the Neon Dashboard. Select a branch, a user, and the database you want to connect to. A connection string is constructed for you.
The connection string includes the user name, hostname, and database name.
postgres://email@example.com/neondb ^ ^ ^ |- <user name> |- <hostname> |- <database name>
- user name:
- database name:
Passwords are only shown when they are created. If you misplaced your password, you can reset it by selecting the Reset Password link in the Connection Details widget, or by navigating to Settings > Users.
Neon uses the default PostgreSQL port,
Connect to the database
In the GUI application or IDE, enter the connection details into the appropriate fields and connect. In the pgAdmin example shown below, clicking Save establishes the database connection.
If the connection is successful, you should be able to view and interact with your database from the GUI application or IDE.
Tested GUI applications and IDEs
Connections from the following GUI applications and IDEs have been tested with Neon:
- Azure Data Studio (requires the PostgreSQL extension, and the option D connection workaround)
- DronaHQ hosted cloud version (requires selecting Connect using SSL when creating a connector)
- PostgreSQL VS Code Extension by Chris Kolkman
- pgAdmin 4
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 Connect from older clients for possible workarounds.
ERROR: The endpoint ID is not specified. Either upgrade the PostgreSQL client library (libpq) for SNI support or pass the endpoint ID (the first part of the domain name) as a parameter: '&options=project%3D'. See [https://neon.tech/sni](https://neon.tech/sni) for more information.