FM
FlowMarket
Database & SQL Beginner ⚡ 3 n8n Nodes

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

🔌 Nodes & Integrations Used (1)

n8n Core Logic

📖 Implementation & Setup Guide

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.

![workflow-screenshot](fileId:267)

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

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Purge n8n execution history located in Mysql.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Database & SQL Workflows

View All in Database & SQL →