Mega Database Cleanup is a modern, high-performance cleanup utility built to remove unused, empty, bloated, or orphaned metadata from your WordPress database — safely and automatically.
It includes a smart scanner, preview mode, ACF pattern cleanup, scheduled tasks, and full backup support. Ideal for site owners, developers, agencies, and power users who want a faster & cleaner database without risking important data.
Highlights
- Empty / Unused Meta Scanner\
Detects empty, null, serialized-empty, or JSON-empty postmeta values.
- ACF Cleanup Engine\
Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.
- Real-Time Safe Preview\
See exactly what will be deleted before confirming cleanup.
- Backup Before Delete\
All removed metadata can be stored in a dedicated backup table.
- Scheduled Cleanup (WP-Cron)\
Cleanup can run automatically (hourly, daily, weekly).
- Retention Rules\
Keep the latest N meta rows per meta_key (default: 5).
- Safe & Secure\
Full validation, sanitization, and capability checks included.
- One-Click Full Cleanup\
Delete unused metadata across the entire database.
- Custom Cleanup Patterns\
Add or remove ACF-like patterns (SQL LIKE rules).
Who Is This For?
Website Owners\
– Improve site performance and reduce database size safely.
Agencies & Developers\
– Maintain clean data structures, especially on large sites.
ACF Users\
– Automatically remove leftover fields that accumulate over time.
Performance Optimizers\
– Speed up queries by removing thousands of useless meta rows.
Why Mega Database Cleanup Is Different
- Designed for large databases
- Uses safe preview mode
- Runs scheduled cleanups automatically
- Creates a backup of every deleted row
- Preserves the first meta entry + last 5 entries for safety
- Uses optimized SQL queries for predictable performance
Automatic Installation
- Log in to WordPress Admin → Plugins → Add New
- Search for Mega Database Cleanup
- Click Install Now → Activate
- Navigate to Tools → Mega DB Cleanup
Manual Installation
- Download the plugin ZIP
- Go to Plugins → Add New → Upload Plugin
- Select the ZIP and install
- Click Activate Plugin
Initial Setup
- Open Tools → Mega DB Cleanup
- Enable ACF Cleanup (optional)
- Enable Preview Mode (recommended)
- Add patterns if needed
- Enable scheduled cleanup (optional)
- Save changes
You're ready to analyze or clean your database!