Set up credentials
Adapt connects to Neon using your project’s Postgres connection string.1
Open your Neon project
Sign in to the Neon Console and select your
project.
2
Open the Connect widget
On the Project Dashboard, click Connect to open the Connect to
your database modal.
3
Copy your connection string
Select the branch, database, and role you want Adapt to use,
then copy the generated connection string. It looks like:
Neon requires SSL, so keep the
sslmode=require parameter in your connection
string. You can toggle connection pooling in the Connect widget; the pooled
host includes a -pooler suffix.Connect to Adapt
1
Open Integrations
In Adapt, go to Settings > Integrations.
2
Find Neon
Search for Neon and select it from the catalog.
3
Start the connection
Click Connect to open the connection form.
4
Add your credentials
Enter the values you gathered above, then click Add connection:
You can rename the connection and choose whether it is shared with your
organization or kept personal to you.
5
Test the connection
Ask Adapt to list your tables or query your data.
Security
- Credentials are encrypted at rest with AES-256
- Connect with a role that has only the privileges Adapt needs, such as read-only
SELECTaccess - Keep
sslmode=requireso all connections use SSL - If your connection string is ever exposed, reset the role’s password in the Neon Console
- Never share your connection string publicly or commit it to source control