How to Sync Airtable and Postgres (Two-Way)

The Airtable, Whalesync and PostgreSQL logos connected, representing a sync between Airtable and Postgres

Learn real-time syncing with Airtable and Postgres using Whalesync

1 min read
Nov 9, 2022

Step-by-Step Guide

1. Create new Sync

New sync button highlighted at the top right of Whalesync's Syncs page

2. Select your first app - Airtable

Airtable highlighted in the app list for the new sync's first data source

3. Click on Authorize

Authorize button highlighted under the App field, with Airtable chosen as the first data source
Authorize Airtable dialog with a base sharing link pasted into the Airtable Base Sharing Link field

5. Authorize using Airtable OAuth

Airtable's access request for Whalesync, with Add a base highlighted to pick the bases it can reach before Grant access

6. Select other app - Postgres

Postgres highlighted in the app list for the second data source, with Airtable already set as the first

7. Click on Authorize

Authorize button highlighted with Postgres chosen as the second data source

8. Paste connection string and change [YOUR PASSWORD] with your Project password

Authorize Postgres dialog with the [YOUR-PASSWORD] placeholder in the pasted connection string highlighted

9. Click on Save connection

Save connection button highlighted below the schema to sync, set to postgres - public

10. Start mapping your tables

Sync setup page with Add table mappings highlighted under Map tables, after connecting Airtable and Postgres

11. Continue to field mapping

Automap fields dialog offering to map 3 same-named fields between the Airtable and Postgres Blog Posts tables

12. Save and Exit

Featured?, Name and Post Summary mapped between the two Blog Posts tables, with Save and Exit highlighted

13. Start Initial sync

Setup checklist showing 1 table mapped, with Prepare initial sync highlighted under Configure initial sync

14. Scan your records

First step of preparing the initial sync, Scan existing records, with the Scan records button highlighted

15. Match your records if needed

Match records step reporting no existing records to match for Blog Posts, with Continue highlighted

16. Click on Continue

Sync preview showing 3 records will be added to the Postgres Blog Post table and none to Airtable

17. Activate your sync

All four setup steps checked off, with the Activate sync button highlighted

18. Click on Activate Sync

Activate Sync dialog warning about attachment file names and renaming mapped tables, with Activate Sync highlighted

19. Initial sync completed!

Completion screen reporting 3 records synced from Airtable into the Postgres Blog Post table

20. Let's get syncing! 🎉

Confetti around the message that the sync is now active, with its status set to Active and a View sync button

Subscribe for more

Stay up to date with the latest no-code data news, strategies, and insights sent straight to your inbox!

Keep reading

Related posts

Start syncing in minutes