Smart Cleanup Tools Plugin for WordPress GPL Overview:

Smart Cleanup Tools is an easy-to-use, powerful plugin for database cleanup with a total of 37 cleanups, reset, and removal tools. With this plugin, you can remove data that is no longer in use, or is unneeded.

List of cleanup tools

• Remove WooCommerce sessions in options table
• Remove orphaned terms records (v3.2)
• Remove oEmbed cached postmeta records (v3.1)
• Remove orphaned relationships records (v3.0)
• Remove expired transient records (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 post meta 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)

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

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