CodingBunny

CodingBunny Database Cleaner is a straightforward yet powerful WordPress plugin that helps you analyze, filter, and safely remove unnecessary data from your database. Whether it’s orphaned options, leftover post meta, unused comments, transients, or more, the plugin gives you a clear picture of what’s in your database and lets you clean it up with confidence.
The plugin automatically detects the likely origin of each database entry — plugin, theme, or WordPress core — so you always know what you’re dealing with before you delete anything.
<h3>Why use CodingBunny Database Cleaner?</h3>
<ul>
<li>See what’s really in your database: get a clear overview of all entries, with auto-detected source.</li>
<li>Clean safely: every action is protected by nonces, role checks, and confirmation prompts. No accidental deletions.</li>
<li>Improve performance: a leaner database means faster queries, smaller backups, and a snappier site.</li>
<li>Automate cleaning: schedule automatic cleanups for greater peace of mind.</li>
<li>Help the community: if the plugin misidentifies the owner of a database entry, you can contribute a correction to help everyone.</li>
</ul>
<h4>Features</h4>
Tables 
* Optimize, repair, and convert tables to InnoDB 
* Delete unused tables 
* Table source detection
Options 
* Delete unused options 
* Manage and optimize autoloaded options
Posts 
* Delete posts, revisions, auto drafts, trash 
* Set up scheduled automatic cleanup
Post Meta 
* Delete unused and orphaned post meta entries 
* Set up scheduled auto clean
Comments 
* Delete spam, trashed, and orphaned comments, pingbacks and trackbacks 
* Set up scheduled auto clean
Comment Meta 
* Delete unused and orphaned comment meta 
* Set up scheduled auto clean
User Meta 
* Delete unused and orphaned user meta 
* Set up scheduled auto clean
Term Meta 
* Delete unused and orphaned term meta 
* Set up scheduled auto clean
Term Relationship 
* Delete unused and orphaned term relationships 
* Set up scheduled auto clean
Post Types 
* Delete unused post types
Transients 
* Delete unused and expired transients 
* Set up scheduled auto clean
Cron Jobs 
* Delete unused cron jobs 
* Set up scheduled auto clean
Action Scheduler 
* Delete completed, failed, and canceled actions 
* Set up scheduled auto clean
oEmbed Caches 
* Delete all oEmbed caches or only expired ones 
* Set up scheduled auto clean
Full Database Cleanup 
* Clean your entire database in a single action
General Tools 
* Multisite support: clean individual subsites or the entire network 
* Detailed filtering, searching, and sorting in every module 
* Paginated results for efficient handling of large databases 
* Safety confirmations and nonce verification on every action 
* Contribute ownership corrections to help the community

CodingBunny Database Cleaner


This plugin does exactly what it promises and helps keep the WordPress database clean without unnecessary complexity. The interface is straightforward, and the cleanup process is easy to understand even for non-technical users.



One suggestion for improvement: instead of adding a separate DB Cleaner item in the main WordPress admin menu, it would feel more natural and consistent with WordPress conventions to place it under Tools → DB Cleaner.



Overall, a useful plugin for routine database maintenance.


Simple and Useful Database Cleanup Plugin

Keep your WordPress database fast and lean by finding and removing orphaned data left behind by plugins, themes, and WordPress itself.

Lester Chan

This plugin cleans up:
<ul>
<li>Revisions</li>
<li>Auto drafts</li>
<li>Deleted comments</li>
<li>Unapproved comments</li>
<li>Spammed comments</li>
<li>Deleted comments</li>
<li>Orphaned post meta</li>
<li>Orphaned comment meta</li>
<li>Orphaned user meta</li>
<li>Orphaned term meta</li>
<li>Orphan term relationships</li>
<li>Unused terms</li>
<li>Duplicated post meta</li>
<li>Duplicated comment meta</li>
<li>Duplicated user meta</li>
<li>Duplicated term meta</li>
<li>Transient options</li>
<li>Optimizes database tables</li>
<li>oEmbed caches in post meta</li>
</ul>
This plugin uses proper WordPress delete functions as much as possible instead of running direct delete MySQL queries.
Following delete functions are used:
<ul>
<li>wp_delete_post_revision()</li>
<li>wp_delete_post()</li>
<li>wp_delete_comment()</li>
<li>delete_post_meta()</li>
<li>delete_comment_meta()</li>
<li>delete_user_meta()</li>
<li>delete_term_meta()</li>
<li>wp_remove_object_terms()</li>
<li>wp_delete_term()</li>
<li>delete_transient()</li>
<li>delete_site_transient()</li>
</ul>
WP-Sweep WP REST API Endpoints 
* <code>GET /wp-json/sweep/v1/count/<Name></code>. Get the number of items that we will be sweeping. 
* <code>GET /wp-json/sweep/v1/details/<Name></code>. Get the details of the items that we will be sweeping. 
* <code>DELETE /wp-json/sweep/v1/sweep/<Name></code>. Runs sweep for that particular item.
WP-Sweep WP-CLI Commands 
* <code>wp sweep --all</code>. Runs sweep for all items. 
* <code>wp sweep <Name></code>. Runs sweep for that particular item. 
* <code>wp sweep <Name1> <Name2></code>. Run sweep for the selected items.
WP-Sweep Available Items: 
* revisions 
* auto_drafts 
* deleted_posts 
* unapproved_comments 
* spam_comments 
* deleted_comments 
* transient_options 
* orphan_postmeta 
* orphan_commentmeta 
* orphan_usermeta 
* orphan_termmeta 
* orphan_term_relationships 
* unused_terms 
* duplicated_postmeta 
* duplicated_commentmeta 
* duplicated_usermeta 
* duplicated_termmeta 
* optimize_database 
* oembed_postmeta
WP-Sweep is not compatible with the following plugins: 
* <a href="https://wordpress.org/plugins/custom-fonts/" rel="ugc">Custom Fonts</a> 
* <a href="https://elementor.com/features/popup-builder/" rel="nofollow ugc">Elementor Popup Builder</a> 
* <a href="https://wordpress.org/plugins/mailpress/" rel="ugc">MailPress</a> 
* <a href="https://wordpress.org/support/plugin/ml-slider/" rel="ugc">Meta Slider</a> 
* <a href="https://wordpress.org/plugins/polylang/" rel="ugc">Polylang</a> 
* <a href="https://revolution.themepunch.com/" rel="nofollow ugc">Slider Revolution</a> 
* <a href="https://codecanyon.net/item/viba-portfolio-wordpress-plugin/9561599" rel="nofollow ugc">Viba Portfolio</a> 
* <a href="https://wpml.org/" rel="nofollow ugc">WPML</a>
<h3>Build Status</h3>
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a> 
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a>
<h3>Development</h3>
<ul>
<li><a href="https://github.com/lesterchan/wp-sweep" title="https://github.com/lesterchan/wp-sweep" rel="nofollow ugc">https://github.com/lesterchan/wp-sweep</a></li>
</ul>
<h3>Credits</h3>
<ul>
<li>Plugin icon by <a href="http://www.freepik.com" rel="nofollow ugc">Freepik</a> from <a href="http://www.flaticon.com" rel="nofollow ugc">Flaticon</a></li>
</ul>
<h3>Donations</h3>
I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.

WP-Sweep


WP-Sweep is a simple yet powerful plugin that helps keep your WordPress site running smoothly. It cleans up unnecessary data like post revisions, trashed posts, spam comments, unused terms, and more — all using native WordPress functions, which makes it safer than many alternatives.



We've used WP-Sweep on multiple websites and it's never caused any issues. It's lightweight, user-friendly, and does exactly what it promises. The interface is clear and makes it easy to choose what to clean.



Highly recommended for anyone looking to optimize their WordPress database without the risk of breaking anything.


Great plugin to keep your WordPress database clean and optimized

Thanks a lot

WP-Sweep allows you to clean up unused, orphaned and duplicated data in your WordPress. It also optimizes your database tables.

CodingBunny Database Cleaner vs WP-Sweep