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.

Post Status Scheduler allows for scheduling of post status changes, category/tag adding or removing and 
removing of postmeta on any given date or time. It can be activated on any post type and shows 
up on the post edit screen in the publish section. From version 1.0.0 it has a feature for sending 
an email notification to the post author on the scheduled update.
<h4>Shortcodes</h4>
<ul>
<li>[pss_scheduled_time post_id=””] can be used to get the post’s scheduled date and time.</li>
</ul>
<h4>Filters</h4>
Scheduled Update: 
* post_status_scheduler_before_execution 
* post_status_scheduler_after_execution
Email Notification ( version 1.0.0 ): 
* post_status_scheduler_email_notification_recipient_email 
* post_status_scheduler_email_notification_subject 
* post_status_scheduler_email_notification_date 
* post_status_scheduler_email_notification_body

Post Status Scheduler

Change status, categories/tags or postmeta of any post type at a scheduled timestamp.

Mega Database Cleanup vs Post Status Scheduler