How can I use N8N to enable 2 way offline sync between local and online databases that is hosted through Cloudbeaver?

Help me Build my Workflow
1

Hi, I’m using a POS System that potentially supports offline sync(2 way),
wherein its MySQL databases is hosted through Cloudbeaver. (e.g. local database and online database)

I want to leverage N8N to support 2 way offline sync between the two databases. Can someone help me on what could be the best architecture/workflow to make this setup work?

Information on your n8n setup

  • n8n version: : 1.91.3
  • Database (default: SQLite):: POSTGRES
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker compose
  • Operating system: Ubuntu 24.04
2

You could probably try with a code node, using js or python, I’ve not used that db, but certainly possible in n8n.

1 Like