Adi Glibanović

RVS Database Doctor is a professional database administration tool. It gives you insight into the current state, safely cleans and optimizes, and shows exactly how much you saved – with full support for large databases.
<h4>Key features</h4>
<ul>
<li>Dashboard with health score and one-click Optimize Now.</li>
<li>Time-based job runner (default batch 1000, auto-adapts to <code>max_execution_time</code>) – works smoothly on databases with 100k+ rows.</li>
<li>Background queue (WP-Cron drain every minute, Action Scheduler when available) – you can close the tab and the job continues.</li>
<li>Before / After snapshots with SVG charts and per-table delta (no external dependencies).</li>
<li>Guided Safe Cleanup Wizard with recommended selections, CARE confirmations, before/after snapshots, and cleanup result deltas.</li>
<li>Smart Advisor v2 – health score (0-100, grade A-F), actionable tips, and EXPLAIN query-plan hints for slow queries.</li>
<li>Bulk actions for Table Sizes, Autoload Options, Index Analysis, and Cleanup tabs.</li>
<li>Manual full database backup with a user-selectable table list and manifest.json metadata. Choose PHP chunked dump (works anywhere) or native mysqldump (fast).</li>
<li>Full database restore from plugin-created backups – automatic pre-restore backup, streaming SQL import, progress tracking, and mandatory confirmation (type RESTORE).</li>
<li>Micro-backup of affected tables before destructive operations (gzip when available, retention by days and count).</li>
<li>Scheduled optimizations – hourly / daily / weekly / monthly.</li>
<li>Scheduled health digest emails – daily, weekly, or monthly summaries sent to the configured notification email.</li>
<li>MyISAM → InnoDB conversion (batched with progress bar).</li>
<li>Autoload analysis with severity levels, segmentation, search, filter, pagination, and bulk update – no longer limited to 50 options.</li>
<li>Index analysis – missing expected, composite suggestions, sys redundant / unused.</li>
<li>WooCommerce / HPOS detection and specific suggestions.</li>
<li>Cleanup: expired transients, revisions, auto-drafts, old trash, spam / trash comments, orphan postmeta / commentmeta / term_relationships, expired WC sessions, Action Scheduler old actions / logs, duplicate postmeta, stale session tokens, <code>_edit_lock</code> / <code>_edit_last</code>.</li>
<li>Actions log – every attempt is recorded (success / error / dry-run).</li>
<li>WP-CLI commands for every action including <code>backup create --all</code>, <code>backup validate <uid></code>, and <code>backup restore <uid> --confirm=RESTORE</code> (<code>wp rvs-database-doctor …</code>; <code>wp rvs-db-doctor …</code> is also supported).</li>
</ul>
<h4>Safety rules</h4>
<ul>
<li>All destructive actions require the <code>manage_options</code> capability + nonce + explicit confirmation checkbox.</li>
<li>Table names are validated against <code>information_schema</code> before any <code>ALTER / ANALYZE / OPTIMIZE / DELETE</code>.</li>
<li>Auto-backup of affected tables before destructive operations (enabled by default).</li>
<li>The plugin never deletes anything automatically; Optimize Now runs safe categories only by default.</li>
</ul>

RVS Database Doctor

Safely analyze and optimize your WordPress and WooCommerce database with backups, restore, schedules, and a built-in health advisor.

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.

RVS Database Doctor vs WP-Sweep