MySQL cleanup in n8n: auto-delete old logs on schedule

# MySQL cleanup for n8n: scheduled or manual removal of old execution records

This automation template helps maintain n8n database performance by automatically removing outdated records from the `execution_entity` table. It runs daily on schedule or can be triggered manually, freeing up space and improving system efficiency.

## Who it´s for
- n8n administrators monitoring database cleanliness
- DevOps engineers automating routine maintenance tasks
- Developers using n8n with MySQL

## What the automation does
- Checks the `stoppedAt` date in the `execution_entity` table
- Deletes records older than 30 days
- Triggered daily at 7:00 or manually via execute trigger
- Works directly with MySQL, minimizing load on n8n
- Ensures stable and efficient database operation

## What´s included
- Ready-to-use n8n workflow
- Logic for triggers and deletion conditions
- Integrations only with MySQL and Cron
- Basic textual guide for setup and adaptation

## Requirements for setup
- Access to an n8n instance
- MySQL access with read and delete permissions on `execution_entity` table
- Configured MySQL connection in n8n

## Benefits and outcomes
- Automatic removal of outdated execution logs
- Reduced database load
- Prevention of data clutter accumulation
- Maintained high n8n performance
- Time saved on manual cleanup
- Option for on-demand manual execution

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat