Direct PostgreSQL database connection in Airtable (like Metabase)?

Whalesync was recommended in another thread, but I don’t have personal experience with it myself. https://www.whalesync.com/connect/postgres-airtable 

What are you using for your current setup?

-Natalka

For another no-code/low-code way of syncing, you can use Make’s PostgreSQL integrations along with Make’s Airtable integrations.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you can instantly trigger a Make automation from Airtable.

- ScottWorld, Expert Airtable Consultant 

Thanks, I haven’t heard of Whalesync, I will look into it!

We simply use the API to create new records in Airtable when there’s new records in our database. The problem is that there are a lot of sync errors (changes in our database that are not updated in Airtable)

Airtable doesn't have a native "connect to postgres as a live data source" feature like metabase. sync is the only path today.

whalesync and sequin are the better sync options, but worth knowing the limitation: formula, rollup, and lookup fields sync as 1-way only — meaning you get the calculated value in postgres, but not the formula logic itself. so postgres holds a static number/text that airtable computed. if linked records change on the postgres side, postgres won't recalculate — only airtable will, and then the new value syncs back over. depending on your use case that's either fine or a dealbreaker.

there are alternatives like nocodb that sit directly on postgres so you get live reads natively, but they're still relatively new and not at airtable's level for automations and script feature.

I'm build a tool called atmigrator on the migration side — airtable to postgres, with rollups/lookups/formulas actually recreated in postgres (not just synced as static values), plus linked records and attachments preserved.