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;” /]
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: 
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar] 
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.
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. 
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.
<h4>Automatic Database Backups</h4>
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.

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.

joeyoungblood

WP Business Intelligence Lite allows you to powerfully display responsive data tables and charts on your website. This plugin is simple to use and allows you to connect with your wordpress database and display the data in real time. Once you have created at least one SQL query that retrieves data from your DB, you can define the type of chart (bar, donut, line, or grouped bar) or table to be used to display them. A simple shortcode embeds the chart or table in any post or page. Each page refresh retrieves the data from the DB so that the information in the chart or table is always up-to-date.
Installation guide, FAQs and support can be found at <a href="http://www.wpbusinessintelligence.com/support" rel="nofollow ugc">WP Business Intelligence Support</a>
<a href="http://www.wpbusinessintelligence.com/demos" rel="nofollow ugc">WP Business Intelligence Demos</a>
In order to use your own live MySQL, MS SQL, or PostgreSQL database with WP Business Intelligence, purchase the Pro version of WP Business Intelligence from the <a href="http://www.wpbusinessintelligence.com" rel="nofollow ugc">WP Business Intelligence web site</a>
We are actively developing this plugin and would love to hear from you with feature requests. <a href="http://www.wpbusinessintelligence.com/contact/" rel="nofollow ugc">Contact Us.</a>
Some icons provided by <a href="https://fontawesome.com/license" rel="nofollow ugc">Font Awesome</a>
<h4>Features</h4>
<ol>
<li>Live connection to your WordPress DB via custom SQL queries</li>
<li>Responsive charts/tables</li>
<li>Works in Chrome, Firefox, IE9+</li>
<li>Charts based on <a href="https://eventbrite.github.io/britecharts/tutorial-kitchen-sink.html" rel="nofollow ugc">Britecharts</a></li>
<li>Tables build on <a href="https://datatables.net/" rel="nofollow ugc">Datatables</a></li>
</ol>

WP Business Intelligence Lite

As a long-time user of this plugin I had been dismayed with how it had eroded in recent years. A few months ago the developer and I reached an agreement for me to take over the plugin so my team and I could start making updates. 

Since December of last year we have fixed all of the known bugs in the display of the charts, fixed the tooltip display, introduced more free charts for WP users, fixed a handful of database query bugs, added a feature to give your charts and graphs a name, added animation to all charts and graphs, and added a feature to give charts and graphs a caption. 

This is only the beginning of our updates, but after 3 months of hardwork the issues with this plugin that were breaking reporting dashboards for us and our clients have now been fixed. We have an aggressive roadmap to bring more charts, features, and functionality to both the free and paid version of this plugin and I am excited to keep using it to build business intelligence dashboards and to display in-depth data on our clients websites.

Problems Getting Fixed, Great Charts!

Dynamic web charts and tables for your site! Connect to your live WordPress instance DB to retrieve data in real-time and update charts and tables!

EZ SQL Reports Shortcode Widget and DB Backup vs WP Business Intelligence Lite