Help

MySql to Airtable Syncing Data

Topic Labels: ImportingExporting
6841 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ritz_Patel
4 - Data Explorer
4 - Data Explorer

Wondering if anyone has managed to sync MySQL data into a Airtable base?

What we are basically trying to do is sync a SQL query data to Airtable - this is currently done manually multiple times a day and imported to Airtable base.

Has anyone done anything like this or are there any 3rd party solutions out there?

Thanks in advance :slightly_smiling_face:

3 Replies 3

Hi @Ritz_Patel - if you want something simple you could use a script (something like python or ruby) that could access you database, get data from there and send to Airtable using the Airtable API.

You could also do this using Google Sheets script as the host - this link shows how to get data from a database using Google Script.

Python or Ruby scripts would need to be hosted somewhere - not a big deal, but something to be considered.

Beyond that there’s lots of commercial data integration solutions - Mulesoft, Talend, etc - but these might be overkill for a relatively small Airtable base.

MichaelTomar
5 - Automation Enthusiast
5 - Automation Enthusiast

Try the Skyvia app. It can sync Airtable and MySQL data without coding. Read more here.

IanYanusko
6 - Interface Innovator
6 - Interface Innovator

In case this helpful for anyone down the road:

Bracket track updates to existing cells, new rows, and even deleted content in both sources. So changes in Airtable are reflected in mySQL and vice-versa. You can also set changes to sync in only one direction if that fits your use case better too. You can also query data from mySQL into Airtable to get filtered views.

It's different from solutions like skyvia because it's a 2-way syncing tool. It can sync from mySQL to Airtable, Airtable to mySQL, or both at the same time (which effectively allows you to use Airtable as a UI for your mySQL database).