PostgreSQL Integration

Connect your PostgreSQL database to Paragon.

1. Get PostgreSQL Details & Whitelist Paragon IP Addresses

You can get your database credentials from whoever set up the database. You'll also need to get them to whitelist the Paragon IP addresses:

  • 18.205.92.162

  • 54.235.127.238

  • 107.20.97.35

  • 54.237.188.41

2. Add PostgreSQL Paragon

To add PostgreSQL to Paragon, click the "+" button in the workflow canvas and choose the PostgreSQL from the sidebar. Under Connect to a PostgreSQL account, choose "Add new account for PostgreSQL" and enter your database credentials. We recommend setting up separate accounts for read and write access to make it harder to accidentally cause unwanted changes to your database.

3. Query PostgreSQL

Once your PostgreSQL database is connected, you can add steps to perform the following actions:

  • Write SQL

  • Find Records

  • Find Record by ID

  • Create Record

  • Update Records

  • Update Record by ID

  • Delete Records

  • Delete Record by ID

You can query PostgreSQL by writing SQL or using Paragon's visual query editor. When writing SQL, you can reference data from previous steps by typing {{ to invoke the variable menu.