Skip to main content
You need to make sure the Less IPs are whitelisted from your PostgreSQL database. You can find the IPs here.

​
Setup

For most PostgreSQL databases, you can use the default connection method. However, if you are using a database that requires SSH, you can use the SSH connection method.
Neon, Supabase, PlanetScale, Aurora,Redshift, and other PostgreSQL-compatible databases are supported. Basically, any PostgreSQL database is supported.
To connect to a PostgreSQL database, the easiest is to find your connection string. This is usually found in the database’s settings (alternatively, ask your database admin for a connection string). It looks something like this: 
postgresql://myuser:[email protected]:5432
Which maps to the following: 
postgresql://<username>:<password>@<host>:<port>/<database>
Save those values for the steps below.
The first step is input host, port (almost always 5432), and the name of the database you want to extract data from.
Input your username and password from the connection string you found above.
We recommend trying without SSH first if you’re in doubt. If you are using a database that requires SSH, you can use the SSH connection method.Input your SSH host, SSH port, SSH username, and SSH password from the database’s settings.
Once you have input your account and credential information, you need to validate your connection on the Tables tab. Click “Connect” to continue. Note that we do not change error message coming from the database.If you can successfully connect to the database, you can now select the tables you want to extract data from. Alternatively, you can switch to the “query-based” tab to write one or more SQL queries to extract data from the database.