Smart Cleanup Tools is an easy to use, powerful plugin for database cleanup with total of 37 cleanup, reset and removal tools. With this plugin you can remove data that is no longer in use, or it is unneeded.
Also, it can help you restore database overhead and speed up database operations. Plugin supports WordPress multisite, and it has few tools designed for the Network administration.
Powerful Database Cleanup for WordPress
Quick cleanup: one click full cleanup
Cleanup Tools: 19 in version 5.0
List of cleanup tools
- Remove WooCommerce sessions in options table (v4.5)
- Remove orphaned terms records (v3.2)
- Remove oEmbed cached postmeta records (v3.1)
- Remove orphaned relationships records (v3.0)
- Remove expired transient records (also in multisite mode) (v2.5)
- Remove auto-draft posts records
- Remove trashed posts records
- Remove spammed posts records
- Remove published posts revisions records
- Remove orphaned posts revisions records
- Remove trashed comments records
- Remove spammed comments records
- Remove orphaned postmeta records
- Remove orphaned comment meta records
- Remove orphaned comments records
- Remove RSS feeds cache
- Remove empty user meta records
- Remove transient records (also in multisite mode)
- Remove database overhead (also in multisite mode)
Removal Tools: 14 in version 5.0
List of removal tools
- Remove unapproved comments records (4.7)
- Remove postmeta records with no value (v4.4)
- Remove comment meta records with no value (v4.4)
- Remove draft posts records (v4.3)
- Remove attachments with missing files (v4.0)
- Remove attachments with missing parent posts (v4.0)
- Remove attachments that are not attached (v4.0)
- Remove missing post types posts (v4.0)
- Remove missing taxonomies terms (v4.0)
- Remove missing unassigned taxonomy terms (v4.0)
- Remove missing all available taxonomy terms (v4.0)
- Remove Akismet comments logs (v2.5)
- Remove user agent data for all comments
- Remove pingback comments
Reset Tools: 4 in version 5.0
With reset tools you can remove some data from database, and it will be recreated to default values. Removing widgets from sidebars is useful when changing themes, and refreshing rewrite rules is useful when having problems with permalinks.List of reset tools
- Remove all post edit locks (v4.1)
- Reset all sidebars
- Reset rewrite rules
- Reset plugins data and statistics (also in multisite mode)
Scheduled Jobs for automatic cleanup
Export and Import of settings and jobs
Other Features
- WordPress Toolbar Menu with quick access and cleanup options
- Tools to export and import plugin settings and scheduled jobs
- Disable tools you don’t want to use from cleanup and reset panels
- Log all executed SQL queries during cleanup check into file
- Log all executed SQL queries during cleanup execution into file
- Log work with normal and scheduled executions
- Gathers statistical data for each tool used
- Gathers global statistics for saved database space
- Uses AJAX for cleanup operation executing
- Support translation and includes POT file
System and WordPress Requirements
- PHP 7.2 or newer
- WordPress 5.3 or newer
Documentation
Plugin contains PDF user guide in the plugin package, inside the ‘docs’ directory. Check out this documentation to get information on plugin options, usage and more.Disclaimers
- Make sure you read plugin documentation and all the information provided by the plugin for each tweak and tool.
- Make sure you backup your database before cleanups, in case you change your mind later. Once removed, plugin can’t restore removed data!
- You are using Smart Cleanup Tools for WordPress at your own risk.
Changelog
Version 5.1 / 2022.03.06.
- Updated: minimal requirement: WordPress 5.3
- Updated: minimal requirement: PHP 7.2
- Updated: more escaping of attribute and HTML values
- Updated: various updates to PHP code
- Fixed: wrong use of ternary operator with PHP 7.1+
- Fixed: minor issues with rendering some cleanup tools boxes
Version 5.0 / 2021.03.22.
- Updated: minimal requirement: WordPress 5.0
- Updated: minimal requirement: PHP 7.0
- Updated: using WordPress code style
- Updated: code inheritance improvements
- Updated: safe use: _ replaced with esc_html_ and esc_attr__
- Updated: safe use: _e replaced with esc_html_e and esc_attr_e
- Updated: most of the JavaScript code has been rewritten