Fabricio Carella

This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.
It also gives you the ability to export the results in a CSV format file.
In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the <code>install_plugins</code> capability, that means a Super Admin in the multi-site installation or an Admin in a single site.
Feel free to contribute: 
https://github.com/Sefirost/run-sql-query
Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

Run SQL Query

Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.

Jordy Meow

Database Cleaner is packed with features to handle big databases, built from years of experience with similar plugins. It works great with the latest WP and PHP versions and has an easy-to-use interface. For large tasks, it uses asynchronous requests to avoid errors and timeouts, ensuring smooth processing. Check it out at <a href="https://meowapps.com/database-cleaner/" rel="nofollow ugc">Database Cleaner</a>.
IMPORTANT: Always back up your data before using this or any plugin! While Database Cleaner is reliable, it’s always best to be safe. Better safe than sorry! 🙂
<h3>Features</h3>
<ul>
<li>Easy Mode & Expert Mode: Whether you’re a beginner or a pro, there’s a mode for you. Easy mode simplifies everything, while Expert mode gives you full control.</li>
<li>One-Click Cleaning: Save time with automatic cleaning. Just one click, and your database is tidy and optimized.</li>
<li>Smart Data Management: Understand how plugins or themes use your data. The Pro Version offers even deeper insights.</li>
<li>Detailed Statistics: Keep an eye on your database size with comprehensive stats and history tracking.</li>
<li>Effortless Data Browsing: Explore and categorize your data with ease. Find what you need without any hassle.</li>
<li>Big Database Handling: Perfect for large databases, it uses smooth, error-free asynchronous requests to manage heavy tasks.</li>
<li>In-Depth Analysis: Specialized tools to analyze and monitor your data across Post Types, Tables, Options, and Cron Jobs.</li>
</ul>
<h3>Why another Database Cleaner?</h3>
While other database cleaners are available, my experience with them revealed areas for improvement, like outdated UIs, incomplete features, and limited data analysis capabilities. Most notably, they struggled with large databases. Motivated by these challenges, I developed my own solution. Now, I’m dedicated to refining it to suit all types of WordPress and databases, aiming to make it the best for everyone.
I’m open to feedback and would be thrilled to discuss how Database Cleaner can better meet your needs. Let’s chat and enhance this tool together!

Database Cleaner


for now, I can tell It works better than any other database-optimizing plugin.


‌Best plugin for database cleaning


Now THIS guy really knows what he's doing. Fantastic UI for "Easy" and "Expert". As an expert I can easily delete loads of crud from the DB, and if I'm not sure I can even look at the value of a DB entry to find out more about it. Simply perfect. And that's all in the free version! I also recommend Jordy's companion plugin Media Cleaner highly - if you want to clean orphaned files in uploads you need the Pro version - I paid for it gladly.


Features you didn't dare dream of

Worth 5 stars without a doubt.  Efficient with an easy mode as well as an expert mode that gives you a lot of possibilities.

Haven't explored the hooks provided such as for example batch assigning unknown metas/options to plugins, but overall am happy with what I saw especially compared to other db clearner plugins out there which give you very basic cleaning functionality while all the real cleaning power site behind the paid version.

Lots of cleaning power


Your plugin is much too good, the interface is super well-thought-out. It's very easy to use, and allows going very far in cleaning up databases. Keep up the good work! You rock!


Deserves more installations

User-friendly tool to clean and optimize databases. Efficiently manages large databases, simplifying repair and ensuring peak performance.

Run SQL Query vs Database Cleaner