MegaWix Technologies

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.
Version 2.0.0 introduces a completely rewritten modular architecture, a real-time Health Dashboard, and targeted cleanup modules for post revisions, trash, spam comments, and expired transients.
<h4>Highlights</h4>
<ul>
<li>
Health Score Dashboard 
Real-time visual representation of your database health and performance at a glance. [NEW in 2.0.0]
</li>
<li>
Targeted Cleanup Modules 
Fast, one-click optimization for Post Revisions, Trashed Content, Spam Comments, and Expired Transients. [NEW in 2.0.0]
</li>
<li>
Empty / Unused Meta Scanner 
Detects empty, null, serialized-empty, or JSON-empty metadata across Post, User, Term, and Comment tables.
</li>
<li>
ACF Cleanup Engine 
Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.
</li>
<li>
Safety Vault System 
Automatically secures deleted revisions and junk data in a temporary vault for easy recovery. [NEW in 2.0.0]
</li>
<li>
Snapshot Management 
Create manual snapshots of your metadata before cleanup and restore them whenever needed. [NEW in 2.0.0]
</li>
<li>
Real-Time Safe Preview 
See exactly what will be deleted before confirming cleanup.
</li>
<li>
Backup Before Delete 
All removed metadata can be stored in a dedicated backup table / snapshot.
</li>
<li>
Scheduled Cleanup (WP-Cron) 
Cleanup can run automatically (daily, weekly).
</li>
<li>
Retention Rules 
Keep the latest N meta rows per meta_key (default: 3).
</li>
<li>
Safe & Secure 
Full validation, sanitization, and capability checks included.
</li>
<li>
One-Click Full Cleanup 
Delete unused metadata across the entire database.
</li>
<li>
Custom Cleanup Patterns 
Add or remove ACF-like patterns (SQL LIKE rules).
</li>
<li>
Activation Welcome Popup 
On first activation, optionally subscribe to optimization tips and anonymous diagnostic sync.
</li>
<li>
Deactivation Feedback 
If you deactivate the plugin, an optional feedback popup appears so you can share why.
</li>
</ul>
<h4>Who Is This For?</h4>
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.
<h4>Why Mega Database Cleanup Is Different</h4>
<ul>
<li>Designed for large databases </li>
<li>Uses safe preview mode </li>
<li>Runs scheduled cleanups automatically </li>
<li>Creates a backup of every deleted row </li>
<li>Safety Vault prevents permanent loss of revisions and trashed data</li>
<li>Preserves the Latest 3 entries for absolute safety </li>
<li>Uses optimized SQL queries for predictable performance</li>
</ul>
<h3>Privacy Policy</h3>
Mega Database Cleanup is committed to transparency regarding user data:
<ul>
<li>No external data transmission — No information ever leaves your site.</li>
<li>Activation popup (optional) — If you enter your email in the welcome popup, it is saved to your site’s <code>wp_options</code> table (<code>mdbcp_subscriber_email</code>). It is never sent to any third-party server. You can skip this step entirely.</li>
<li>Deactivation feedback (optional) — If you submit a deactivation reason, it is saved locally to your site’s <code>wp_options</code> table (<code>mdbcp_deactivation_log</code>). It is never sent externally. You can skip this step entirely.</li>
<li>Database backups — Backup data is stored in a dedicated custom table on your own database server.</li>
</ul>
<h3>Developer Hooks</h3>
<h4>Filters</h4>
<ul>
<li><code>mega_db_cleanup_patterns</code> – Modify cleanup patterns </li>
<li><code>mega_db_cleanup_retention_limit</code> – Change default “keep latest N” count </li>
</ul>
<h4>Actions</h4>
<ul>
<li><code>mega_db_cleanup_before_delete</code> – Fires before deletion </li>
<li><code>mega_db_cleanup_after_delete</code> – Fires after deletion</li>
</ul>
<h3>Credits</h3>
Developed with ❤️ by <a href="https://www.megawix.com" rel="nofollow ugc">MegaWix Technologies</a>
<ul>
<li>Plugin Development: MegaWix Technologies</li>
<li>Testing & QA: MegaWix Technologies</li>
</ul>
<h3>Support</h3>
Need help? Have a question or feature request?
<ul>
<li>Website: https://www.megawix.com</li>
<li>Email: info@megawix.com</li>
</ul>
We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions.

Mega Database Cleanup

A powerful and safe WP database cleanup tool with ACF orphan removal, empty meta scanning, scheduled automation, backups, and real-time preview mode.

Ben Balter

This plugin will work, “as is”, out of the box, but assumes some level of CSS and developer customization to adapt to your site’s specific needs.
Styles can be overridden via your theme’s style.css
Functionality can be overridden via your theme’s functions.php
”Examples”
Don’t display metabox on “product” post type:
<pre><code>add_filter( 'display_custom_fields', 'bb_no_product_metabox' ); function bb_no_product_metabox( $true, $post ) { if ( $post->post_type == 'product' ) return false; return true; } </code></pre>
Don’t display the product_id metakey
<pre><code>add_filter( 'dcf_postmeta', 'bb_no_product_id' ); function bb_no_product_id( $postmeta ) { unset( $postmeta['product_id'] ); return $postmeta; } </code></pre>
Don’t display metabox title
<pre><code>add_filter( 'dcf_heading', '__return_false' ); </code></pre>
Display metabox below content (rather than floated to the right)
<pre><code>add_filter( 'dcf_before_content', '__return_false' ); </code></pre>

Display Custom Fields

Inserts a Wikipedia-like metabox into posts with all the post's associated custom fields and taxonomy terms.

Mega Database Cleanup vs Display Custom Fields