Kirtikumar Solanki

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 <code>.sql</code> format before cleaning.
No technical skills required — simply open Tools → SmartPro Database Optimiser & Cleaner, click “Clean”, and enjoy improved performance instantly.
<h3>🚀 Key Benefits</h3>
<ul>
<li>Faster database performance </li>
<li>Reduced storage usage </li>
<li>Ability to safely back up your WordPress database </li>
<li>Clean, modern, user-friendly UI </li>
<li>No page reloads (AJAX-based) </li>
<li>Safe queries using <code>$wpdb</code> </li>
<li>No bloat, lightweight, and optimized </li>
</ul>
<h3>🧹 Cleanup Features</h3>
Clean up unnecessary and unused database entries with a single click:
<ul>
<li>Remove post revisions</li>
<li>Delete auto-saved drafts</li>
<li>Remove trashed posts and trashed pages</li>
<li>Clean spam and trashed comments</li>
<li>Remove expired transients</li>
<li>Delete all transients</li>
<li>Remove orphaned post meta</li>
<li>Remove orphaned comment meta</li>
<li>Delete orphaned user meta</li>
<li>Remove unused tags</li>
<li>Delete empty taxonomy terms</li>
<li>Optimize all WordPress tables</li>
</ul>
Each cleanup item displays: 
– Real-time items count 
– Action button 
– Instant results message
Also includes: 
– Clean All button 
– Refresh Counts button
<h3>🛢️ Database Backup Features</h3>
Before cleaning, download your full database for safety.
<ul>
<li>One-click SQL backup download</li>
<li>Shows total database size</li>
<li>Backups stored in: 
 /wp-content/uploads/smartpro-database-optimiser-cleaner/</li>
<li>Backup is generated safely using WordPress standards</li>
</ul>
<h3>🗂️ Database Table Optimization</h3>
From the Optimize Tables tab, you can:
<ul>
<li>View every database table </li>
<li>See table size, index size, total size, row count </li>
<li>Optimize each table individually </li>
<li>Or use Optimize All Tables</li>
</ul>
All database optimization is handled using safe, built-in SQL operations.
<h3>🖥️ Smart, Modern UI</h3>
The plugin includes a clean and intuitive interface:
<ul>
<li>AJAX-powered actions </li>
<li>Smooth progress indicators </li>
<li>Live counts </li>
<li>Field-based table listing </li>
<li>Fully responsive design </li>
<li>Admin-friendly layout </li>
</ul>
<h3>🔒 Security & Permissions</h3>
<ul>
<li>Nonce-protected AJAX requests </li>
<li>Sanitized inputs </li>
<li>Works only for administrators </li>
<li>No risky SQL execution </li>
<li>Follows strict WordPress coding standards</li>
</ul>

SmartPro Database Optimiser & Cleaner

Smart, lightweight tool to clean, optimize, and back up your WordPress database for better speed and performance.

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

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

SmartPro Database Optimiser & Cleaner vs WP-Sweep