RVS Database Doctor
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. Key features Dashboard with health score and one-click Optimize Now. Time-based job runner (default batch 1000, auto-adapts to max_execution_time) – works smoothly on databases with 100k+ rows. Background queue (WP-Cron drain every minute, Action Scheduler when available) – you can close the tab and the job continues. Before / After snapshots with SVG charts and per-table delta (no external dependencies). Guided Safe Cleanup Wizard with recommended selections, CARE confirmations, before/after snapshots, and cleanup result deltas. Smart Advisor v2 – health score (0-100, grade A-F), actionable tips, and EXPLAIN query-plan hints for slow queries. Bulk actions for Table Sizes, Autoload Options, Index Analysis, and Cleanup tabs. Manual full database backup with a user-selectable table list and manifest.json metadata. Choose PHP chunked dump (works anywhere) or native mysqldump (fast). Full database restore from plugin-created backups – automatic pre-restore backup, streaming SQL import, progress tracking, and mandatory confirmation (type RESTORE). Micro-backup of affected tables before destructive operations (gzip when available, retention by days and count). Scheduled optimizations – hourly / daily / weekly / monthly. Scheduled health digest emails – daily, weekly, or monthly summaries sent to the configured notification email. MyISAM → InnoDB conversion (batched with progress bar). Autoload analysis with severity levels, segmentation, search, filter, pagination, and bulk update – no longer limited to 50 options. Index analysis – missing expected, composite suggestions, sys redundant / unused. WooCommerce / HPOS detection and specific suggestions. 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, _edit_lock / _edit_last. Actions log – every attempt is recorded (success / error / dry-run). WP-CLI commands for every action including backup create --all, backup validate , and backup restore --confirm=RESTORE (wp rvs-database-doctor …; wp rvs-db-doctor … is also supported). Safety rules All destructive actions require the manage_options capability + nonce + explicit confirmation checkbox. Table names are validated against information_schema before any ALTER / ANALYZE / OPTIMIZE / DELETE. Auto-backup of affected tables before destructive operations (enabled by default). The plugin never deletes anything automatically; Optimize Now runs safe categories only by default.
SmartPro Database Optimiser & Cleaner
SmartPro Database Optimiser & Cleaner helps you maintain a faster, cleaner, and more efficient WordPress website by removing unnecessary database clutter and optimizing all database tables. It features a beautiful modern interface, one-click actions, real-time item counts, and AJAX-powered cleaning for a seamless experience. This tool also includes an integrated full database backup system, allowing you to download your entire WordPress database in .sql format before cleaning. No technical skills required — simply open Tools → SmartPro Database Optimiser & Cleaner, click “Clean”, and enjoy improved performance instantly. 🚀 Key Benefits Faster database performance Reduced storage usage Ability to safely back up your WordPress database Clean, modern, user-friendly UI No page reloads (AJAX-based) Safe queries using $wpdb No bloat, lightweight, and optimized 🧹 Cleanup Features Clean up unnecessary and unused database entries with a single click: Remove post revisions Delete auto-saved drafts Remove trashed posts and trashed pages Clean spam and trashed comments Remove expired transients Delete all transients Remove orphaned post meta Remove orphaned comment meta Delete orphaned user meta Remove unused tags Delete empty taxonomy terms Optimize all WordPress tables Each cleanup item displays: – Real-time items count – Action button – Instant results message Also includes: – Clean All button – Refresh Counts button 🛢️ Database Backup Features Before cleaning, download your full database for safety. One-click SQL backup download Shows total database size Backups stored in: /wp-content/uploads/smartpro-database-optimiser-cleaner/ Backup is generated safely using WordPress standards 🗂️ Database Table Optimization From the Optimize Tables tab, you can: View every database table See table size, index size, total size, row count Optimize each table individually Or use Optimize All Tables All database optimization is handled using safe, built-in SQL operations. 🖥️ Smart, Modern UI The plugin includes a clean and intuitive interface: AJAX-powered actions Smooth progress indicators Live counts Field-based table listing Fully responsive design Admin-friendly layout 🔒 Security & Permissions Nonce-protected AJAX requests Sanitized inputs Works only for administrators No risky SQL execution Follows strict WordPress coding standards
