Mega Database Cleanup

plugin banner

A powerful and safe WordPress database cleanup tool with ACF orphan removal, empty meta scanning, scheduled cleanup automation, backups, and real-time …

Author:MegaWix Technologies (profile at wordpress.org)
WordPress version required:5.0
WordPress version tested:6.9.4
Plugin version:2.0.0
Added to WordPress repository:28-12-2025
Last updated:26-03-2026
Rating, %:0
Rated by:0
Plugin URI:
Total downloads:325
plugin download
Click to start download

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: info@megawix.com

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


Screenshots
FAQ
ChangeLog