Back to Integrations
integration integration
integration MySQL node

Integrate MySQL with 500+ apps and services

Unlock MySQL’s full potential with n8n, connecting it to similar Development apps and over 1000 other services. Automate productivity workflows by scheduling tasks, managing project timelines, and tracking progress across platforms. Create adaptable and scalable workflows between MySQL and your stack. All within a building experience you will love.

Create workflows with MySQL integrations

794 integrations
Sort by:
Popularity
NameOldestNewest

Popular ways to use MySQL integration

MySQL node

Purge n8n execution history located in Mysql

This workflow is useful if you have lots of tasks running daily. MySQL node (or the database used to save data shown in n8n - could be Mongo, Postgres, ... -) remove old entries from execution_entity table that contains the history of the executed workflows. If you have multiple tasks executed every minute, 1024 rows will be created every day (60 minutes x 24 hours) per every task. This will increase the table size fastly. SQL query deletes entries older than 30 days taking stoppedAt column as a reference for date calculations. You only have to setup Mysql connection properly and config cron to execute once per day in a low traffic hour, this way
mcolomer
Miquel Colomer
Webhook node
Telegram node
MySQL node

Cron routines with Telegram

Executes schedule routines, and triggers alerts via telegram
alves
Hermilio
MySQL node

Create a table in MySQL and insert data

Companion workflow for MySQL node docs
sm-amudhan
amudhan
HTTP Request node
Merge node
Postgres node
Webhook node
MySQL node

Join data from Postgres and MySQL

query data from two different databases handle and unify in a single return
alves
Hermilio
Google Sheets node
MySQL node

Import data from MySQL into Google Sheets

This workflow queries a table in MySQL and inserts the data into Google Sheets.
lorenanda
Lorena
Pipedrive node
MySQL node
+2

Two way sync Pipedrive and MySQL

This workflow automates a two way sync of customer data between Pipedrive and MySQL. It will create new records in one source if it only exists in the other. Where matching records have different data for name, phone number or email address, it will sync the most recently updated version.
n8n-team
n8n Team

Supported Actions

Delete
Delete an entire table or rows in a table
Execute SQL
Execute an SQL query
Insert
Insert rows in a table
Insert or Update
Insert or update rows in a table
Select
Select rows from a table
Update
Update rows in a table
MySQL node

About MySQL

The relational database management system MySQL is free and open-source. Although MySQL includes standalone clients that let users communicate with a MySQL database directly using SQL, it is more frequently used in conjunction with other applications to develop applications that require relational database functionality.

Related categories

Similar integrations

  • Google Sheets node
  • Postgres node
  • Airtable node
  • Google Drive node
  • GitHub node
  • MongoDB node
  • Microsoft SQL node
  • GraphQL node
  • Baserow node
  • Redis node
Use case

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

Over 3000 companies switch to n8n every single week

Connect MySQL with your company’s tech stack and create automation workflows

Last week I automated much of the back office work for a small design studio in less than 8hrs and I am still mind-blown about it.

n8n is a game-changer and should be known by all SMBs and even enterprise companies.

in other news I installed @n8n_io tonight and holy moly it’s good

it’s compatible with EVERYTHING

We're using the @n8n_io cloud for our internal automation tasks since the beta started. It's awesome! Also, support is super fast and always helpful. 🤗

FAQ about MySQL integrations

  • How can I set up MySQL integration in n8n?

      To use MySQL integration in n8n, start by adding the MySQL node to your workflow. You'll need to authenticate your MySQL account using supported authentication methods. Once connected, you can choose from the list of supported actions or make custom API calls via the HTTP Request node, for example: you can specify SQL queries directly within the MySQL node to manipulate your database efficiently. Additionally, make sure you configure the node settings according to your database schema for optimal results. Finally, test the connection to ensure everything is set up correctly before proceeding with your workflow.

  • Do I need any special permissions or API keys to integrate MySQL with n8n?

  • Can I combine MySQL with other apps in n8n workflows?

  • What are some common use cases for MySQL integrations with n8n?

  • How does n8n’s pricing model benefit me when integrating MySQL?

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon