Automate Purging of n8n Execution History in MySQL - n8n Workflow | Neura Market
Automate Purging of n8n Execution History in MySQL
This workflow automatically deletes n8n execution history entries older than 30 days from a MySQL database, helping to manage database size effectively.
The workflow is designed to maintain the efficiency of your n8n database by removing outdated execution records. It utilizes a MySQL query to delete entries from the execution_entity table where the stoppedAt date is older than 30 days. This process is triggered daily at a specified low-traffic hour using a cron job, ensuring minimal impact on database performance.
Platform
n8n
Category
Data & Analytics
Price
Free
Creator
Marco Bianchi
cron
mySql
manualTrigger
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.