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.

Samuel Diethelm

This plugin enables the use of [if] shortcodes to work with conditional logic based on the existence of post meta or taxonomy terms on posts and pages.
Please consider taking a minute to rate the plugin or let me know any feature request. Thanks!
<h4>Taxonomy</h4>
With conditional logic for taxonomy terms, you can use names, slugs or term_ids:
<ul>
<li>[if taxonomy=”category” slug=”cars”]Content to show[/if]</li>
<li>[if taxonomy=”category” name=”Cars”]Content to show[/if]</li>
<li>[if taxonomy=”category” id=”123″]Content to show[/if]</li>
</ul>
<h4>Post Meta</h4>
Post meta (or custom field) logic can be used to check if a certain meta_key AND meta_value combination are present or just a meta_key:
<ul>
<li>[if postmeta=”car_model”]Content to show if car model info is present[/if]</li>
<li>[if postmeta=”car_model” value=”Tesla Model S”]Content to show if car model is Tesla Model S[/if]</li>
</ul>

Logic Shortcodes

Use shortcodes for conditional logic based on post meta or taxonomy terms.

Mega Database Cleanup vs Logic Shortcodes