Advanced Database Cleaner

Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc.

It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned.

With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more.

Why use Advanced Database Cleaner❓

👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned.

👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you.

👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites.

✅ Main Features

• Delete old revisions of posts and pages
• Delete old auto-drafts
• Delete trashed posts
• Delete pending comments
• Delete spam comments
• Delete trashed comments
• Delete pingbacks
• Delete trackbacks
• Delete unused post meta
• Delete unused comment meta
• Delete unused user meta
• Delete unused term meta
• Delete unused relationships
• Delete expired transients
• Delete duplicated post meta
• Delete duplicated user meta
• Delete duplicated comment meta
• Delete duplicated term meta
• Delete oEmbed caches
• Display the database size that will be freed before cleaning for each item type, and the total size to be freed
• Display and preview items to clean before performing a database cleanup to ensure safety
• Sorting capability in cleanup preview tables (by name, date, size, site id, etc.)
• View options value content in original or formatted mode for serialized or JSON structures (and other items types as well).
• Keep last X days of data: clean only data older than the number of days you specify

✅ 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

Read the full description on the official page →