Free tool · runs in your browser
SQL Generator: WordPress Database Cleanup
A WordPress database grows quietly: revisions, transients, orphaned metadata and bloated autoloaded options slow every page. The generator first creates count queries so you see where the ballast is, then the matching DELETE statements – with your table prefix.
SQL Generator
Clean up the WordPress database
Pick what to target, then measure or clean up. Everything runs in your browser – nothing is executed automatically.
Before you continue: Take a database backup first. Run this SQL via phpMyAdmin or wp db query. DELETE statements cannot be undone.
Your input never leaves the browser. The SQL is generated locally via JavaScript.
Everything is generated locally in your browser. Nothing you enter is transmitted to our server.
How it works
- 1 Enter your table prefix and pick targets
- 2 Check in “Count” mode first what would be affected
- 3 Take a backup, then run the DELETE statements
Guides for this tool
- Clean Up and Optimise the WordPress Database Revisions, transients and autoload bloat slow WordPress unnoticed. Measure, then clean the database in a targeted way – not by blindly clicking plugin buttons.
- Speed Up WooCommerce: What Really Counts in a Shop WooCommerce has bottlenecks generic tips miss: cart fragments, uncacheable pages, query load. Here's how to speed up your shop in a targeted way.
Related Services
More tools
- wp-config.php Generator
- .htaccess Password Protection Generator
- Redirect Generator (301)
- PHP Limits Generator
- Restore WordPress Admin Access
- Cron Generator for WordPress
- Database Connection Test
- Caching Generator (.htaccess / Nginx)
- robots.txt for AI Crawlers
- llms.txt Generator
- Maintenance Page Generator
- Backup Planner
- Base64 Encode and Decode
- HTTP Status Checker
- All tools →