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.

RVS Database Doctor vs Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance