
Automated Database Maintenance Solution
How the MySQL Purge Workflow Solves Database Bloat
Simple Solution, Powerful Impact
Our workflow provides automated maintenance through a straightforward implementation:
- MySQL Connection: Connects directly to your n8n database
- Targeted Cleanup: Uses SQL to remove records older than 30 days from the execution_entity table
- Time-based Logic: Identifies old records using the 'stoppedAt' timestamp
- Scheduled Operation: Runs once daily during low-traffic periods via n8n Cron node
The workflow is database-agnostic and works with MySQL, PostgreSQL, MongoDB, or whichever database powers your n8n instance. Implementation takes less than 10 minutes but delivers immediate performance benefits.