Mega Database Cleanup

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.

Highlights

• Health Score Dashboard
  Real-time visual representation of your database health and performance at a glance. [NEW in 2.0.0]

• Targeted Cleanup Modules
  Fast, one-click optimization for Post Revisions, Trashed Content, Spam Comments, and Expired Transients. [NEW in 2.0.0]

• Empty / Unused Meta Scanner
  Detects empty, null, serialized-empty, or JSON-empty metadata across Post, User, Term, and Comment tables.

• ACF Cleanup Engine
  Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.

• Safety Vault System
  Automatically secures deleted revisions and junk data in a temporary vault for easy recovery. [NEW in 2.0.0]

• Snapshot Management
  Create manual snapshots of your metadata before cleanup and restore them whenever needed. [NEW in 2.0.0]

• 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 / snapshot.

• Scheduled Cleanup (WP-Cron)
  Cleanup can run automatically (daily, weekly).

• Retention Rules
  Keep the latest N meta rows per meta_key (default: 3).

• 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).

• Activation Welcome Popup
  On first activation, optionally subscribe to optimization tips and anonymous diagnostic sync.

• Deactivation Feedback
  If you deactivate the plugin, an optional feedback popup appears so you can share why.

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
• Safety Vault prevents permanent loss of revisions and trashed data
• Preserves the Latest 3 entries for absolute safety
• Uses optimized SQL queries for predictable performance

Privacy Policy

Mega Database Cleanup is committed to transparency regarding user data:

• No external data transmission — No information ever leaves your site.
• Activation popup (optional) — If you enter your email in the welcome popup, it is saved to your site’s wp_options table (mdbcp_subscriber_email). It is never sent to any third-party server. You can skip this step entirely.
• Deactivation feedback (optional) — If you submit a deactivation reason, it is saved locally to your site’s wp_options table (mdbcp_deactivation_log). It is never sent externally. You can skip this step entirely.
• Database backups — Backup data is stored in a dedicated custom table on your own database server.

Developer Hooks

Filters

• mega_db_cleanup_patterns – Modify cleanup patterns
• mega_db_cleanup_retention_limit – Change default “keep latest N” count

Actions

• mega_db_cleanup_before_delete – Fires before deletion
• mega_db_cleanup_after_delete – Fires after deletion

Credits

Developed with ❤️ by MegaWix Technologies

• Plugin Development: MegaWix Technologies
• Testing & QA: MegaWix Technologies

Support

Need help? Have a question or feature request?

• Website: https://www.megawix.com
• Email: [email protected]

We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions.