Monday.com to SQL

I have an idea of pulling the data out of monday.com to an sql database.

** I have no experience in developing a database - except a local simple database like sqlite3 in python / mysql local server

  1. I don’t know how it works, how should i host a database, and where?
  2. how can I extract data from monday to sql database? - is this a good option (I’m concerned about data integrity issues)
  3. I was thinking to extract via Zapier, but they don’t seem to have option to track deleted columns/values
  4. I was also thinking Webhook option - is this hard to work with? I find the document only teaches how to create webhook on the monday side, how about on my end, what should I do?
  • at the current stage, i just want to experiment with a basic demo prototype database with sqlite3 in vscode using python.

Thank you.

For a no-code way to sync Monday data to an SQL database, you can also try Skyvia. It supports scheduled exports from Monday to popular databases like MySQL or SQL Server and handles data changes, including deletions.

1 Like