Version 2.0.0 — Major Overhaul Released

Mega Database
Cleanup for WordPress

The most powerful & safe WordPress database cleanup tool. Remove orphaned ACF fields, empty meta rows, revisions, spam, and transients — with real-time preview and automatic snapshots.

Download Free Learn More
2.0 Latest Version
GPLv2 Open Source
WP 5.0+ Compatible
PHP 7.4+ Required
Health Dashboard
75%Health Score
Empty Meta Rows 1,248
ACF Orphans 342
Post Revisions 587
Expired Transients 0
Core Features

Everything You Need for a Clean Database

Built for power users, developers, and agencies managing large WordPress databases.

Empty / Unused Meta Scanner

Detects empty, null, serialized-empty, or JSON-empty metadata across Post, User, Term, and Comment tables.

ACF Cleanup Engine

Automatically identifies ACF patterns to detect and remove orphan entries. Fully customizable pattern rules.

NEW 2.0

Safety Vault System

Automatically secures deleted revisions and junk data in a temporary vault so you can recover anything, anytime.

NEW 2.0

Snapshot Management

Create manual snapshots before cleanup and restore them whenever needed. Full historical backup support.

Real-Time Safe Preview

See exactly what will be deleted before confirming any cleanup. Zero risk of accidental permanent deletion.

Scheduled Cleanup (WP-Cron)

Set it and forget it. Automated daily or weekly cleanup follows all your retention rules and backup settings.

Retention Rules

Keep the latest N meta rows per meta_key (default: 3). Never accidentally remove all data for a key.

How It Works

Three Steps to a Faster Database

01

Scan & Analyze

The scanner inspects your entire WordPress database — post meta, user meta, term meta, and comment meta — identifying empty, unused, serialized-empty, and orphaned rows.

02

Preview Changes

Preview mode shows you every row that will be deleted before you confirm. Enable snapshots to auto-backup before any action. You're always in control.

meta_keyaction
_acf_field_orphanDELETE
_empty_metaDELETE
_product_priceKEEP
03

Clean & Recover

Execute the cleanup with one click. All deleted rows are safely vaulted. If you ever need something back, restore from the Snapshot Manager instantly.

Cleaned!
Cleanup Modules

Targeted One-Click Optimization

Each module is laser-focused on a specific source of database bloat.

Post Revisions

Safely remove stale post revisions. Keep only what matters, clear the rest.

NEW 2.0

Trashed Content

Permanently delete trashed posts and pages that are taking up space.

NEW 2.0

Spam Comments

Obliterate spam and unapproved comments in a single, safe operation.

NEW 2.0

Expired Transients

Clear out all expired WordPress transients that pile up over time.

NEW 2.0

Empty Meta Cleaner

Advanced scanner for null, empty, serialized-empty, and JSON-empty meta values.

ACF Orphan Engine

Pattern-based ACF field detection. Add custom patterns to match any leftover ACF data.

Why Choose Us

Built for Large-Scale WordPress Sites

  • Optimized SQL Queries Designed for predictable, high-performance operation on databases with millions of rows.
  • Zero Data Loss Guarantee Every deleted row is backed up in the Safety Vault or snapshot table before removal.
  • 100% Privacy — No External Calls Your data never leaves your server. No third-party telemetry or tracking.
  • Developer Hooks & Filters Extend or override behavior with mega_db_cleanup_patterns, retention filters, and action hooks.
  • Modular Architecture Version 2.0 is a complete class-based rewrite. Clean, maintainable, and extensible.
Before vs. After
480MB
210MB
124,000
55,800
2.4s
0.9s
■ Before ■ After
FAQ

Frequently Asked Questions

No — the plugin only targets metadata that is clearly empty, unused, or orphaned. With the new Safety Vault and Snapshot systems, you can restore deleted data at any time.
Yes. Preview mode allows you to see exactly which meta rows are considered empty before removing anything. You are always in complete control.
Yes! It includes a dedicated ACF cleanup engine that uses pattern rules to identify real orphan fields. You can add or remove patterns to match your exact ACF field configuration.
It is a percentage-based calculation that tells you how optimized your database is based on the amount of junk data found. 100% means a perfectly clean database.
Very safe — scheduled cleanup follows the same rules as manual cleanup, including retention rules and backup settings. The Safety Vault protects any deleted data automatically.
The plugin requires at least WordPress 5.0 and PHP 7.4. It has been tested and confirmed compatible up to WordPress 6.9 and beyond.
Changelog

What's New

v2.0.0 — Latest
  • Major Overhaul: Completely redesigned modular class-based architecture
  • New: Health Score Dashboard with real-time database diagnostics
  • New: User, Term, and Comment metadata cleanup support
  • New: Targeted cleanup modules — Revisions, Trash, Spam, Transients
  • New: Safety Vault system to temporarily secure deleted data
  • New: Metadata Snapshot system for manual backups and restoration
  • New: Modern tabbed UI with improved user experience
  • Added: Telemetry system for anonymous site optimization diagnostics
v1.1.1
  • Fixed: PHP compatibility — replaced arrow functions with anonymous functions
  • Fixed: Plugin deactivation bug during update process on some servers
  • Improved: Better handling of plugin state during version transitions
v1.1.0
  • Added optional activation popup with email subscription
  • Added deactivation feedback popup with 6 selectable reasons
  • Plugin now appears as a top-level menu item in WordPress sidebar
  • Quick-access link added to the WordPress admin bar
v1.0.0 — Initial Release
  • Empty meta scanner and preview mode
  • ACF orphan cleanup with pattern-based detection
  • Scheduled automatic cleanup (hourly/daily/weekly)
  • Backup table to store deleted meta rows
  • Retention rule — keep latest N entries per meta_key
  • One-click delete all empty metadata
  • Fully optimized SQL cleanup with jQuery admin UI

Ready for a Faster WordPress Site?

Join thousands of WordPress site owners who trust Mega Database Cleanup to keep their databases lean, fast, and safe — for free.

Free Download WordPress.org Visit MegaWix.com

Free forever · GPLv2 License · No credit card required