Automated Cleanup of Old Database Records

This n8n workflow is designed to optimize database maintenance by automatically deleting outdated records from a MySQL database. The workflow provides manual and scheduled triggers to run deletion queries, ensuring that the database remains clean and efficient. The ‘On clicking execute’ node allows manual triggering of the cleanup process, while the cron trigger schedules the cleanup to run daily at 7 AM. When activated, the MySQL node executes a DELETE statement that removes records older than 30 days from the ‘execution_entity’ table, helping to prevent database bloat and improve performance. This workflow is ideal for website administrators or developers who want to automate routine database cleanup without manual intervention, saving time and maintaining data hygiene.