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.

meloniq

Enhance the default WordPress admin search by including custom fields (post meta) in search results. 
This plugin seamlessly extends the post listing (edit.php) search functionality, allowing administrators to quickly find content based on values stored in custom fields.
It works out of the box with no configuration required—just activate and start searching. 
Especially useful for sites that rely heavily on custom fields, such as those built with ACF or other meta-based data structures.
Lightweight, efficient, and fully integrated with the native WordPress admin experience.

WP-Admin Search Post Meta

Search WordPress admin posts by custom fields (post meta) directly from the default search.

Mega Database Cleanup vs WP-Admin Search Post Meta