How To

How to sync Airtable and Postgres

Ian Yanusko
June 12, 2023
min read

If Postgres takes priority, choose Postgres as your primary source and Airtable as your secondary source. Otherwise, do the opposite

1. Choose your primary source

2. Connect Postgres

3. Enter details found in connection URI, password, and preferred security settings

4. Write a query or send a full table from Postgres

5. Connect to Airtable

6. Add a base

7. Grant access to the base

8. Choose a table to sync, or have Bracket generate the table for you (we can generate Postgres from an existing Airtable)

9. Click continue

10. Choose the direction to sync data in

11. Map the fields in Airtable to the fields in Postgres

12. Choose how often the data should refresh

13. Turn the toggle on to get syncing