Sync CMS data to MySQL

Hello,
Is there a way to automatically sync the CMS data to our own DB e.g MySQL? I have seen some tutorials on how to sync with Notion, Airtable,etc, but i am looking to sync it with our own DB

I’d recommend that you establish a single source of truth, and sync in one direction only.

If the CMS is your SSoT, you can code your CRUD operations manually as automations that trigger off of CMS webhooks, and update your MySQL db accordingly. Make, Zapier, n8n are all good automation platforms for this.

If MySQL is your SSoT, you can do the same, or look into internal triggers and add-ons that support outbound CRUD operations as updates occur.

Keep in mind if you’re planning to do batch operations in MySQL, you’ll quickly overwhelm the Webflow API’s rate limits. You might look into powerimporter pro and whalesync to see if they can buffer that for you adequately.

Hey Abhishek It is possible to automatically sync CMS data from Webflow to your own MySQL database. There are several tools and services available that can help achieve this. One option is to use a third-party integration tool such as Hightouch or Zapier to connect your MySQL database to Webflow and sync the CMS data automatically. Another option is to use a custom solution such as the Webflow external database syncing tool. It is important to experiment with different tools and configurations to achieve the desired functionality for your website, Try this -Connect your MySQL to Webflow integration in 2 minutes | Zapier

@ankitparmar Thanks for replying. The link that you shared triggers the zapier flow on form submission. We wanted the sync to get triggered whenever we make a change to any CMS item.

Use Webflow Webhooks.

They sync your CMS to an external source on create, update, and delete.

Any of those CRUD actions trigger the Webhook which then automatically sends that data to an external service. I usually add Make (Integromat) as the glue service to whatever datastore I’m moving it to, but it’s not required.

Here’s the API:

Here’s a tutorial on how to use it, and set it up in Webflow:

If you want to make your life easier you can use my Webflow Webhook Creator tool:

Via Make (Integromat):

Put all of this together and you get what you need :smile:

1 Like

Hey Michael

In regards to MySQL (SSoT) sending changes to Webflow, would the updates made in an MySQL database have a long lag time before it syncs into the CMS in Webflow?

Do you know about High Touch as an option?

Depends on your sync code, but pretty much instantaneous once you make the API call.

There are strict API call limits though, I think 100 per minute? So this will begin to break down a bit if you are trying to push large volumes of data in over short timeframes.

1 Like

Yeah interesting, really appreciate that Michael :call_me_hand:

Fingers crossed Webflow makes some large data syncing improvements down the line.