Basedash

Find your database credentials under Manage credentials in Basedash and build the Postgres connection URI to paste into the Whalesync connection dialog.

Step 1: Find your database

Navigate to the Basedash Connections page. In the left panel, scroll down to the bottom to see your databases. Click on the gear icon of the database you want to connect:

Screenshot of the settings icon for a database connection in Basedash — Connection settings for a database

Click "Manage credentials":

Screenshot of the manage credentials button in Basedash — Manage credentials for a database

Step 2: Construct the connection URI

On the "Manage credentials" page, you should see a "SQL connection overview" section:

SQL connection overview page in Basedash — SQL connection overview

Construct the connection URI with the above fields and replace YOUR_PASSWORD with the correct password. Using the example values above, the connection URI would look like this:

postgresql://postgres:YOUR_PASSWORD@18.18.98.1:5432/postgres

This is the string you will paste into the Whalesync Postgres connection dialog:

Screenshot of the Whalesync Postgres connection dialog — Enter your Postgres connection URI into Whalesync

Caveats

If your database only accepts connections from known IP addresses, allowlist Whalesync's static IP. See Allowlisting Whalesync IP addresses.

Note that Whalesync does not yet support custom SSL/TLS certificates. If you need them to connect to your instance, please reach out and let us know.