Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance

✅ Automation

• Schedule database cleanup to run automatically
• Create scheduled cleanup tasks and specify which items each task should clean
• Schedule database optimization and/or repair to run automatically
• Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly
• Specify the “keep last X days” rule for each item type in a scheduled task
• Pause/Resume scheduled tasks whenever needed
• Create as many scheduled cleanup tasks as needed and specify what each task should clean

✅ Tables

• Display the list of database tables with information such as number of rows, table size, engine, etc.
• Sort tables by any column such as table name or table size
• Display table contents along with their column structure, indexes, status, and more
• Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page
• Optimize database tables (the plugin notifies you when tables require optimization)
• Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted)
• Convert tables to InnoDB for better performance
• Empty rows of database tables
• Clean and delete database tables

✅ Options

• Display the options list with information such as option name, option value, option size, and autoload status
• Sort options by any column such as option name or option size
• View option value content in original or formatted mode for serialized or JSON structures.
• Notify you if autoloaded options are large and help reduce autoload size for better performance
• Detect large options that may slow down your website
• Set option autoload to yes/no
• Clean and delete options

✅ Cron Jobs

• Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc.
• Sort cron jobs by any column such as action name or next run time
• Detect cron jobs with no valid actions
• Clean and delete scheduled tasks

✅ Post Meta

• Display the post meta list with information such as meta key, value, size, associated post ID, etc.
• Sort post meta by any column such as meta key, meta size, or post ID
• View post meta value content in original or formatted mode for serialized or JSON structures.
• Detect unused post meta (meta not associated with any existing posts)
• Detect duplicated post meta (same meta key/value for the same post ID)
• Clean and delete post meta

✅ Post types

• Display post types with information such as name, post count, visibility (public or non-public), etc.
• Sort post types by columns such as name, post count, visibility, etc.
• View posts corresponding to each post type, along with their details
• Detect unused or orphaned post types
• Clean orphaned post types

✅ User Meta

• Display the user meta list with information such as meta key, value, size, associated user ID, etc.
• Sort user meta by any column such as meta key, meta size, or user ID
• View user meta value content in original or formatted mode for serialized or JSON structures.
• Detect unused user meta (meta not associated with any existing users)
• Detect duplicated user meta (same meta key/value for the same user ID)
• Clean and delete user meta

✅ Transients

• Display the list of transients with information such as name, value, size, and expiration time
• Sort transients by any column such as transient name, size, or expiration time
• View transient value content in original or formatted mode for serialized or JSON structures.
• Clean expired transients
• Detect large transients that may slow down your website
• Clean and delete transients
• Set transient autoload to yes/no

✅ WooCommerce

• Clean orphaned product variations
• Clean orphaned customer analytics
• Clean expired customer sessions

✅ Other Tools

• Display current database size
• Logging system for easy troubleshooting
• Access the WordPress debug log directly from the plugin interface
• Multisite support (network-wide database cleanup and optimization from the main site)
• Modern, responsive interface powered by React for a smooth experience without page reloads
• Show/hide plugin tabs for better usability

⚡ Premium Features ⚡ Official website

Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level.

✅ Remote SmartScan

• Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs
• Cloud-enhanced ownership detection using a large and continuously improving remote database
• Improved accuracy for identifying orphaned items left by deleted plugins and themes
• Ability to edit ownership of any item and correct misidentified owners
• Ability to send ownership corrections to improve the global detection database
• Enhanced “Belongs to” ownership column everywhere using cloud data + local data
• Display multiple possible owners for each item when applicable
• Display owner status (active, inactive, not installed) to simplify cleanup decisions
• Check your remote scan credits to monitor usage

✅ Action Scheduler Cleanup

• Clean Action Scheduler Completed actions
• Clean Action Scheduler Failed actions
• Clean Action Scheduler Canceled actions
• Clean Action Scheduler Completed logs
• Clean Action Scheduler Failed logs
• Clean Action Scheduler Canceled logs
• Clean Action Scheduler Orphan logs

✅ General Cleanup Enhancements

• Keep last X items feature in General Cleanup
• Keep last X items per parent (e.g., per post)
• Keep last X items globally (e.g., keep the last 10 pingbacks)
• Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety

✅ Advanced Filters

• Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
• Filter by size, value content, autoload, expiration, metadata type, and more
• Filter by plugin owner, theme owner, WordPress core, orphan, or unknown
• Filter by multisite site ID with full per-site visibility
• Filter by action frequency and interval in cron jobs
• Filter by duplicated, unused, large, not-yet-scanned, or expired items

✅ Advanced Automation

• Unlimited automation tasks (Free version is limited to 5 tasks)
• Create any number of scheduled cleanup tasks with different configurations
• Create scheduled optimization and repair tasks
• Use Keep Last X Items and Keep Last X Days inside scheduled tasks
• Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency
• Pause/resume/delete automation tasks without losing settings
• Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs

✅ Database Analytics

• Daily tracking of total database size and number of tables
• Daily and monthly charts showing database growth trends
• Raw data tab with all recorded measurements
• Table-level analytics showing size growth, rows growth, and daily changes
• Ability to detect abnormal table growth caused by logs, caches, or runaway actions
• Multi-table selection and search for analyzing multiple tables at once

✅ Addons Activity

• Automatically track plugin activations, deactivations, and uninstalls
• Automatically track theme switches and uninstalls
• Display activity in a color-coded timeline for better readability
• All timestamps shown in your local timezone
• Multisite support (activity recorded on the main site)

✅ Full Multisite Support

• Clean any site or all sites
• Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs)
• Display which site each it