<p>Just place some SQL on in the box and save it as a report. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click. You can place your reports on the User’s Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]</p>
<p>There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site:<br />
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]<br />
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.</p>
<p>If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode.<br />
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.</p>
<h4>Automatic Database Backups</h4>
<p>Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.</p>


EZ SQL Reports Shortcode Widget and DB Backup

Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.

Jordy Meow

<p>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>.</p>
<p><strong>IMPORTANT</strong>: 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! 🙂</p>
<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>
<p>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.</p>
<p>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!</p>


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.

EZ SQL Reports Shortcode Widget and DB Backup vs Database Cleaner