Automated Database Maintenance Solution

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:

  1. MySQL Connection: Connects directly to your n8n database
  2. Targeted Cleanup: Uses SQL to remove records older than 30 days from the execution_entity table
  3. Time-based Logic: Identifies old records using the 'stoppedAt' timestamp
  4. 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.