How to integrate Airtable base with PostgreSQL

[Davor_Lauc]

Hi, I am pretty new to Airtable. Is there are some easy way to sync (or at least export) an Airtable base to relational DB?

[AntonScatton]

Hi,
you can try this free tool to do that https://uibakery.io/move-airtable-to-postgresql

[yanu]

Hi Davor, there are a few ways to do this.

1. You could write your own script to call the Airtable API. Note that you’ll need an Airtable Enterprise plan to fully use the API, but you could get around it with something like BaseQL: https://baseql.com/

2. You could use an ETL solution like Fivetran or Airbyte if you’re just trying to move the data one way (i.e. Airtable to Postgres).

3. You could use a “circular” ETL solution like Bracket (https://www.usebracket.com/) if you want to sync bidirectionally, i.e. you want changes from either source to be preserved in the other.

Hope that helps!

[MichaelTomar]

Have you tried 3rd parties to configure the integration? Skyvia, as an example, is pretty simple to use and has a freemium model. Take a look here.

[BenFortunato]

Was wondering if anyone had any experience using an ETL solution with an airtable base? I'm setting one up and would like to get a bit of insight into pitfalls.