EHERO Cleaner – Clean the WordPress database in one click

Clean WordPress database in one click, knowing exactly what each tool removes

EHERO Cleaner is a free plugin to clean WordPress database clutter from your dashboard: old revisions, auto-drafts, trash, spam, expired transients, orphaned metadata, Action Scheduler history and expired WooCommerce sessions. It is listed on WordPress.org and updates from your dashboard like any other plugin.

Over the years, the database behind a website or a shop fills up with things nobody needs. Every save leaves a revision, every plugin you try leaves its metadata behind, and a WooCommerce store piles up thousands of scheduled tasks that already ran. None of it shows on the site, yet it takes space, makes backups longer and slows down some queries.

Each of its 25 tools tells you what it removes, how many items it found and whether its risk is Safe or Moderate. Run them one by one, all the safe ones at once, or put them on a schedule.

25 tools to clean WordPress database clutter, each with its risk level

The dashboard shows one card per tool with a short description, the number of items it found and a risk label.

• Posts: revisions, auto-drafts, trash and edit locks (the «someone is editing» warning).
• Comments: spam, trash, pingbacks and trackbacks.
• Orphaned post, comment, term and user meta, term relationships pointing to deleted posts and exact duplicate post meta.
• Cache: expired or all transients, oEmbed and RSS feed cache, expired login sessions and table optimisation.
• Two tools are labelled Moderate, deleting all transients and duplicate meta; the other 23 are labelled Safe.

One click for every safe tool, with an activity log

The «Run All Safe Tools» button runs every tool labelled Safe in a single pass and tells you how many items it removed.

• Your browser asks you to confirm before it starts.
• Moderate tools never join that pass: you run them by hand, one at a time.
• The activity log keeps the date, the tool and the number of items removed in each cleanup.
• The dashboard shows the database size, the number of tables and the date of the last scheduled cleanup.

Revisions: keep the latest few, delete the rest

WordPress stores a revision every time you update a post or a page, and never deletes them on its own.

• In Settings you choose how many revisions to keep per post: 5 by default, 3 to 5 recommended.
• Set it to 0 to delete every revision.
• Revisions are removed through the WordPress function, so their metadata goes with them.
• Auto-drafts and trashed posts, pages and custom post types are emptied the same way, through WordPress functions.

Scheduled cleanup: twice daily, daily or weekly

Turn on scheduled cleanup, pick the frequency and tick the tools you want to run on their own.

• It relies on WP-Cron: it runs when the site gets visits or when your server cron triggers it.
• You choose the list, for example expired transients, spam and Action Scheduler every week.
• The dashboard shows when the last scheduled cleanup ran.
• The Settings tab also has a manual cleanup table with live counts and a «Run Now» button on every row.

Action Scheduler and WooCommerce without the extra history

Action Scheduler is the task queue used by WooCommerce and many other plugins. On a busy store it can reach hundreds of thousands of rows.

• Completed actions older than 30 days, failed actions and cancelled actions.
• Action Scheduler log entries whose action no longer exists.
• Expired WooCommerce customer sessions; active ones stay untouched.
• Download log entries older than 30 days, so the table stops growing forever.

Metadata detector grouped by plugin

When you uninstall a plugin, its data usually stays in the database. The detector scans a meta table and groups the keys by their likely origin.

• Scan post and product meta, user meta, term meta or comment meta.
• Recognises WordPress, WooCommerce, Yoast SEO, Rank Math, AIOSEO, Elementor, ACF, JetEngine, WPML, Divi, Beaver Builder and more.
• Each group shows how many rows it holds and expands to list its keys one by one.
• Tick the groups or keys you want to delete and confirm. The origin is guessed from the key prefix, so check it before you delete.

Metadata viewer on every post, product and order

A read-only box on the edit screen lists all the metadata of the item, grouped by origin.

• Available on posts, pages, products, public post types and orders, including WooCommerce HPOS order storage.
• On categories, tags and other terms it appears at the bottom of their edit screen.
• Groups such as WordPress, WooCommerce, Yoast SEO, Rank Math, Elementor, custom fields and private plugin fields.
• A button expands or collapses every group. The viewer changes nothing: it only shows.

Advanced zone: bulk deletes with a double confirmation

To reset a staging shop or wipe a whole catalogue there is a separate tab, flagged as a danger zone.

• Delete posts, pages or products by status or by category, with the number of items shown before you confirm.
• Empty a whole data group: posts and pages, comments, media, products, orders, coupons, product categories, tags or attributes.
• Every delete asks you to type DELETE in a dialog before it runs.
• These operations cannot be undone: use them only with a recent backup.

Built to clean WordPress database tables without touching your content

The regular cleanup tools only remove what is already in the trash, marked as spam, expired, or left without the item it belonged to.

• Your published posts, pages and products are never deleted from the dashboard or by scheduled cleanup.
• Only administrators can use it, and every request carries a security token so nobody can trigger it from outside.
• Cleanups run on your own server with no external calls; only the newsletter banner, which you can dismiss for good, contacts our site.
• Uninstalling it removes its settings, its log and its scheduled task.

Truly free, in English and Spanish

There is no paid edition and nothing is locked: the 25 tools, scheduled cleanup, the detector, the viewer and the advanced zone all come in the same plugin.

• Install and update it from WordPress.org on as many sites as you like.
• Admin screens in English and Spanish, through the WordPress.org language pack.
• A user manual is bundled inside the plugin.
• Works with or without WooCommerce; with WooCommerce you also get the session and download log tools.

Ideal for

Any site benefits when you clean WordPress database tables now and then; these notice it most:

📋 System requirements

What version 1.0.12 needs to clean WordPress database tables on your site.

🛟 Support

Support* in the EHERO Cleaner forum on WordPress.org. Updates reach your dashboard like any plugin from the directory, including every new release of this tool to clean WordPress database tables.

⚖️ Comparison: why EHERO Cleaner?

Two of the most widely used cleanup plugins are WP-Optimize, by TeamUpdraft, and Advanced Database Cleaner, by SigmaPlugin. Both have a free and a paid edition. This is what each one states on its own pages, next to what EHERO Cleaner does, free and complete.

Data from WordPress.org and each vendor’s website, October 2026. «Not stated»: not found on its product page, terms or FAQ.

When did you last clean WordPress database tables on your site? Install EHERO Cleaner, take a backup and see how much each tool finds. It is free.

EHERO Cleaner: a lighter database, and you know what gets deleted.

Want to see more tools for your store? Discover all our plugins for WooCommerce or visit the Consultoría EHERO store.

*EHERO Cleaner is distributed free of charge under the GPLv2 license and without warranty. Support for the free version is the WordPress.org forum.