About this plugin
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.
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