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

799 integrations
Sort by:
Popularity
NameOldestNewest

Popular ways to use MySQL integration

Webhook node
Telegram node
MySQL node

Cron routines with Telegram

Executes schedule routines, and triggers alerts via telegram
alves
Hermilio
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
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
MySQL node

Create a table in MySQL and insert data

Companion workflow for MySQL node docs
sm-amudhan
amudhan
MySQL node
Compare Datasets node

Compare SQL datasets

This workflow compares 2 datasets from a single database. Two SQL nodes create a slightly different summary report based on the payments table. Both reports have the same structure, but different time periods. In addition to that, output from the "Orders from 2004 and 2005" node has an extra manipulation on the ordercount variable. This makes Compare Datasets node to produce four outputs: data in A Only Branch, in B Only Branch, Same Branch records and Different Branch records. Please refere to the MySQL Tutorial website and download the example database: https://www.mysqltutorial.org/mysql-sample-database.aspx
n8n-team
n8n Team
HTTP Request node
Webhook node
+3

SQL to XML export with XSL template formatting

This workflow demonstrates how to export SQL to XML and present the data nicely formatted using an XSL Template. The upper part of the workflow starts with a webhook. Then it gets several random records from the SQL table and converts them into an XML string. Then a final XML file is created that contains a link to the XML Stylesheet file. The lower part of the workflow contains a helper Webhook that reads an XSL Template from the GitHub gist and serves it back via the Respond to Webhook node. This is required to comply with the CORS rules of modern browsers. These rules dictate that both XML data and a stylesheet file should come from the same domain.
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

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?

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. 🤗

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.

Need help setting up your MySQL integration?

Discover our latest community's recommendations and join the discussions about MySQL integration.
Mohammadali
Michael Zareno
Neal A Richardson Sr
GabrielBackend
Chaima Belkacem

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon