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.

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!

Run SQL Query vs WP Business Intelligence Lite