Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

Purge n8n execution history located in Mysql

n8n template #700
This workflow is useful if you have lots of tasks running daily. MySQL node (or the database used to save data shown in n8n - could be Mongo, Postgres, ... -) remove old entries from executionentity table that contains the history of the executed workflows. If you have multiple tasks executed every minute, 1024 rows will be created every day (60 minutes x 24 hours) per every task. This will increase the table size fastly. SQL query deletes entries older than 30 days taking stoppedAt column as a reference for date calculations. You only have to setup Mysql connection properly and config cron to execute once per day in a low traffic hour, this way

Hand off to your agent

Prompt

Help me set up the n8n workflow "Purge n8n execution history located in Mysql" (https://n8n.io/workflows/700). It uses: MySQL. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Similar workflows

NameViews
  1. Generate SQL queries from schema only - AI-powered38K
  2. Generate Monthly Financial Reports with Gemini AI, SQL, and Outlook14K
  3. Import CSV into MySQL13K
  4. Build an AI-Powered Tech Radar Advisor with SQL DB, RAG, and Routing Agents12K
  5. Two way sync Pipedrive and MySQL11K
  6. Sync Google Sheets data with MySQL7,760
  7. Create a table in MySQL and insert data6,128
  8. Import data from MySQL into Google Sheets5,532
Buy me a coffee