Advanced Database Cleaner Pro

The Sigma package for WordPress brings us three specialized tools designed to enhance our site’s performance on three different levels: Advanced WordPress Reset, WP Cron Cleaner PRO, and the flagship of the pack, Advanced Database Cleaner PRO. Their names already give us a hint of what they do, but let’s dive into the details.

Database Cleaning for the Demanding User

This plugin is an absolute must-have if you want to keep your WordPress database clean and optimized. Advanced Database Cleaner scans all data tables, hunting down and eliminating accumulated digital “junk.” In other words, it gets rid of unnecessary data that piles up over time —like post revisions, drafts, spam comments, orphaned options, unused tables, and more.

It’s worth noting that plugins or components we once installed, then deactivated and deleted, often leave behind their own tables and data, silently taking up space and slowing down our site. Advanced Database Cleaner sweeps away all that excess, reducing the database size and significantly improving efficiency when accessing tables.

Installation

Simply search for the plugin in the WordPress plugin repository, as shown in the screenshot below.

Once installed and activated, we’ll find its access in our WordPress Dashboard.

It’s important to note that the free version of this plugin does not allow for cleaning specific tasks and tables individually. To unlock this level of precision, you’ll need to purchase the Pro version. The advantage of targeted cleaning is that you can preserve certain data (for instance, from an inactive or deleted plugin that you might want to use again in the future).

Below, we outline the features included in the free version, followed by the additional benefits of the Pro version.

Free Version Features

✅ Post Table Cleanup: Removes old post and page revisions, auto-saved drafts, and trashed posts. This helps reduce the size of your WordPress database.

✅ Expired Transient Cleanup: Eliminates expired transients (temporary options) that no longer have a purpose in your database.

✅ View & Manage Tables: Displays detailed information on all database tables (row count, sizes, etc.), allowing you to optimize, repair, empty, or delete tables when necessary.

✅ Database Overview: Provides a clear snapshot of unused or orphaned elements that should be cleaned to keep your database optimized.

✅ Comment Table Cleanup: Deletes pending, spam, trashed comments, pingbacks, and trackbacks, reducing the number of rows in the WordPress comments table.

✅ View Orphaned Elements: Lets you preview orphaned data before cleaning, ensuring that no valuable information is lost.

✅ View & Manage Options: Displays a list of all WordPress options along with their values, sizes, and auto-load settings. You can modify or remove options as needed.

✅ Automation: No need to run the plugin manually! You can schedule automatic cleaning and optimization tasks at custom intervals.

✅ Orphaned Metadata Cleanup: Removes orphaned post metadata, comment metadata, user metadata, term metadata, and orphaned relationships.

✅ Preserve Recent Data: Allows you to exclude data from the last X days, ensuring that only older, unnecessary data is cleaned.

✅ View & Manage Cron Jobs: Displays active scheduled tasks (cron jobs) along with their details (arguments, next execution, etc.), letting you remove unnecessary scheduled tasks to further speed up your WordPress site.

✅ Database Size Reduction: By eliminating unused and orphaned data, your database becomes lighter and faster. A smaller database also means quicker backups, as the files being copied are smaller.

Additional Features in the PRO Version

Before we dive into the extra tools offered by the PRO version, we want to highlight something important: if you need more advanced features beyond what the free version provides, we highly recommend Database Cleaner Pro by Meowapps. In fact, we include it as part of our Managed WordPress Service.

Now, let’s take a look at the six exclusive features that make the PRO version stand out:

✅ Detection & Removal of Orphaned Options – Over time, your WordPress database’s wp_options table can become cluttered with orphaned options. This hidden buildup slows down your site’s performance. Cleaning up orphaned options is a powerful way to speed things up, and the PRO version does it automatically.

✅ Detection & Removal of Orphaned Tables – Similar to orphaned options, some database tables remain even after uninstalling plugins or themes. These unused tables take up space and can impact performance. The PRO version scans for and removes these orphaned tables, helping your site run more efficiently.

✅ Detection & Removal of Orphaned CRON Jobs – When you uninstall a plugin or theme, some scheduled CRON tasks might remain active, even though the functions they call no longer exist. These lingering CRON jobs can cause unnecessary database load and errors. The PRO version detects and eliminates them.

✅ Categorized Scanning & Editing – This feature allows you to scan specific elements or your entire database to determine which plugin or theme they belong to. You can also modify values as needed, ensuring a cleaner and more organized database.

✅ Advanced Search & Filtering – Easily search and filter options, tables, and CRON jobs based on custom criteria such as name, creator, value, and more. This makes it easier to pinpoint exactly what you need.

✅ Expert Assistance – The PRO version includes personalized technical support, helping you get the most out of the plugin. Whether you need guidance before executing actions or want to optimize your database further, expert advice is just a message away.

Final Thoughts

There are plenty of database cleaning plugins out there, but very few actually show you exactly what’s being cleaned. The detailed insights provided by this plugin allow us to understand and prevent performance issues before they become a problem.

The scheduled task manager is another game-changer, enabling automated cleanups so we don’t have to constantly monitor our database’s health.

As for customer support, it’s nothing short of exceptional. The developer’s passion for their product is evident, and their eagerness to help makes troubleshooting a breeze.

In conclusion, this plugin is ultra-lightweight, ultra-efficient, and ultra-complete. However, if for any reason the free version doesn’t meet your expectations, we highly recommend upgrading to Database Cleaner Pro.

We hope this review has been helpful! Feel free to share your thoughts or ask questions in the comments. Wishing you success, and thanks for reading!