MegaWix Technologies

<p><strong>Mega Database Cleanup</strong> is a modern, high-performance cleanup utility built to remove unused, empty, bloated, or orphaned metadata from your WordPress database — safely and automatically.</p>
<p>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.</p>
<p><strong>Version 2.0.0</strong> introduces a completely rewritten modular architecture, a real-time Health Dashboard, and targeted cleanup modules for post revisions, trash, spam comments, and expired transients.</p>
<h4>Highlights</h4>
<ul>
<li>
<p><strong>Health Score Dashboard</strong><br />
Real-time visual representation of your database health and performance at a glance. [NEW in 2.0.0]</p>
</li>
<li>
<p><strong>Targeted Cleanup Modules</strong><br />
Fast, one-click optimization for Post Revisions, Trashed Content, Spam Comments, and Expired Transients. [NEW in 2.0.0]</p>
</li>
<li>
<p><strong>Empty / Unused Meta Scanner</strong><br />
Detects empty, null, serialized-empty, or JSON-empty metadata across Post, User, Term, and Comment tables.</p>
</li>
<li>
<p><strong>ACF Cleanup Engine</strong><br />
Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.</p>
</li>
<li>
<p><strong>Safety Vault System</strong><br />
Automatically secures deleted revisions and junk data in a temporary vault for easy recovery. [NEW in 2.0.0]</p>
</li>
<li>
<p><strong>Snapshot Management</strong><br />
Create manual snapshots of your metadata before cleanup and restore them whenever needed. [NEW in 2.0.0]</p>
</li>
<li>
<p><strong>Real-Time Safe Preview</strong><br />
See exactly what will be deleted before confirming cleanup.</p>
</li>
<li>
<p><strong>Backup Before Delete</strong><br />
All removed metadata can be stored in a dedicated backup table / snapshot.</p>
</li>
<li>
<p><strong>Scheduled Cleanup (WP-Cron)</strong><br />
Cleanup can run automatically (daily, weekly).</p>
</li>
<li>
<p><strong>Retention Rules</strong><br />
Keep the latest N meta rows per meta_key (default: 3).</p>
</li>
<li>
<p><strong>Safe & Secure</strong><br />
Full validation, sanitization, and capability checks included.</p>
</li>
<li>
<p><strong>One-Click Full Cleanup</strong><br />
Delete unused metadata across the entire database.</p>
</li>
<li>
<p><strong>Custom Cleanup Patterns</strong><br />
Add or remove ACF-like patterns (SQL LIKE rules).</p>
</li>
<li>
<p><strong>Activation Welcome Popup</strong><br />
On first activation, optionally subscribe to optimization tips and anonymous diagnostic sync.</p>
</li>
<li>
<p><strong>Deactivation Feedback</strong><br />
If you deactivate the plugin, an optional feedback popup appears so you can share why.</p>
</li>
</ul>
<h4>Who Is This For?</h4>
<p><strong>Website Owners</strong><br />
– Improve site performance and reduce database size safely.</p>
<p><strong>Agencies & Developers</strong><br />
– Maintain clean data structures, especially on large sites.</p>
<p><strong>ACF Users</strong><br />
– Automatically remove leftover fields that accumulate over time.</p>
<p><strong>Performance Optimizers</strong><br />
– Speed up queries by removing thousands of useless meta rows.</p>
<h4>Why Mega Database Cleanup Is Different</h4>
<ul>
<li>Designed for <strong>large databases</strong>  </li>
<li>Uses safe preview mode  </li>
<li>Runs scheduled cleanups automatically  </li>
<li>Creates a backup of every deleted row  </li>
<li><strong>Safety Vault</strong> prevents permanent loss of revisions and trashed data</li>
<li>Preserves the <strong>Latest 3 entries</strong> for absolute safety  </li>
<li>Uses optimized SQL queries for predictable performance</li>
</ul>
<h3>Privacy Policy</h3>
<p>Mega Database Cleanup is committed to transparency regarding user data:</p>
<ul>
<li><strong>No external data transmission</strong> — No information ever leaves your site.</li>
<li><strong>Activation popup (optional)</strong> — 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><strong>Deactivation feedback (optional)</strong> — 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><strong>Database backups</strong> — 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>
<p>Developed with ❤️ by <a href="https://www.megawix.com" rel="nofollow ugc">MegaWix Technologies</a></p>
<ul>
<li>Plugin Development: MegaWix Technologies</li>
<li>Testing & QA: MegaWix Technologies</li>
</ul>
<h3>Support</h3>
<p>Need help? Have a question or feature request?</p>
<ul>
<li>Website: https://www.megawix.com</li>
<li>Email: info@megawix.com</li>
</ul>
<p>We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions.</p>


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.

htmlpie

<p>This plugin adds some cool features to the <a href="https://wordpress.org/themes/pen" title="Pen Theme - Multi-purpose WordPress Theme" rel="ugc">Pen theme</a> such as importing metadata from one post to another, importing\exporting color scheme(s) from one website to another, and a very useful toolbar menu for easier access to various parts of the Customize section both from the front-end and the back-end.</p>
<h4>Quick Introduction</h4>
<p>Pen is a premium multi-purpose WP theme, very perfect for various kinds of websites and blogs, such as cooking, creative, eCommerce shops, education, food, health & fitness, landing pages, lifestyle, local business, medical, news, personal websites, portfolio, restaurant, travel, university portal, wedding and any other kind of awesome site or blog.</p>
<h4>What Makes This Theme Different?</h4>
<ul>
<li>This is the Full version, i.e. it has no locked feature and there is no “UPGRADE NOW” banner to tease you everyday</li>
<li>No footer backlink either</li>
<li>Top-rated support</li>
<li>Beautiful Ready-Made Color Schemes (Dark Color Schemes Included)</li>
<li>Content-Specific Configuration (This is awesome! please check the screenshots down below for more information)</li>
<li>Sharing Content Configuration Across Different Posts\Products</li>
<li>Per-Content Layout & Color Scheme Customization!</li>
<li>Per-Widget Color Schemes & Animations!</li>
<li>Shortcut Menus For Easier Site Building & Perfect User Experience</li>
<li>Built-in Dropdown Navigation & Mobile Menu (No need to check hundreds of plugin)</li>
<li>Built-in “Loading…” Splash Screen (Unobtrusive JS and Retina-Ready)</li>
<li>Upload Light Version of Your Logo For Dark Color Schemes (Switches Automatically!)</li>
<li>Featured Image as Background! (Beautiful! Just Install The Theme And Try It Out)
<ul>
<li>Site Background</li>
<li>Header Background</li>
<li>Navigation Menu Background</li>
<li>Content Title Background</li>
<li>Footer Background</li>
</ul>
</li>
<li>Unobtrusive JavaScript</li>
<li>Web Accessibility Best Practices (WCAG AA)</li>
</ul>
<h4>Other Notable Theme Features</h4>
<ul>
<li>450+ Customization Options!</li>
<li>Over 100 Color Options</li>
<li>Flat Color Schemes Included!</li>
<li>Multiple Layout Options</li>
<li>Multiple Header & Footer Layouts</li>
<li>Fully Animated (Optional)</li>
<li>Beautiful CSS3 Effects (Optional)</li>
<li>jQuery Masonry (Plus Animation)</li>
<li>Sticky Header (Optional)</li>
<li>Post Excerpt</li>
<li>Author Profile (Optional)</li>
<li>Large Search Box (Optional)</li>
<li>Compatible with WooCommerce</li>
<li>Compatible with WP PageNavi</li>
<li>Localization-Ready</li>
<li>800+ Google Fonts</li>
<li>Site Icon</li>
<li>HTML5 Polyfills</li>
<li>Optimized CSS, HTML, & JS (Awesome SEO)</li>
<li>Lightweight Codes</li>
<li>Child Theme Support</li>
<li>Semantic HTML5 Structure</li>
<li>WordPress Best Practices</li>
<li>And Much More…</li>
</ul>
<h4>Plugin Features</h4>
<ul>
<li>View and Import Content-Specific Customization (Very Awesome Feature!)</li>
<li>Toolbar Menu (Screenshot 4)</li>
<li>Choose Layout & Color Schemes</li>
<li>Export & Import Theme Options (Screenshot 3)</li>
</ul>
<h3>Plugin Installation</h3>
<p>The theme has a built-in installer which takes care of plugin installation and activation with a click.</p>
<p>If you need to manually install this plugin:</p>
<ol>
<li>Upload the plugin files to the <code>/wp-content/plugins/pen-extra-features</code> directory, or install the plugin through the WordPress plugins screen directly.</li>
<li>Activate the plugin through the ‘Plugins’ screen in WordPress.</li>
<li>Enjoy having an improved UX and new features.</li>
</ol>


This plugin adds some cool features to the Pen theme.

Mega Database Cleanup vs Pen