<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.

Puvox Software

ttodua

<h4>[ ✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 𝐵𝓎 𝒫𝓊𝓋𝑜𝓍 ] :</h4>
<blockquote>
<p>• Checked against vulnerability holes.<br />
  • No extra load/slowness to site.<br />
  • Does not collect & share private data.</p>
</blockquote>
<h4>Plugin Description</h4>
<p>The famous database browser & manager (for MySQL & MariaDB) – use it inside WordPress Dashboard without an extra hassle.</p>
<h3>NOTES</h3>
<ul>
<li>This plugin has been started from 2018 year, and we have no connections to the old age’s vulnerable wp-phpMyAdmin plugin (published elsewhere by 3rd party scammers) . So, this current plugin is just a wrapper for official phpMyAdmin release and depends itself on the realiability & security of the <code>phpMyAdmin</code> itself. Also, initially we wanted to put PhpMyAdmin released <code>.zip</code> file untouched (to ensure the checksums are same) and unpack that <code>.zip</code> directly upon plugin’s installation, but unfortunately WordPress Plugin Team didn’t allow to put <code>.zip</code> file in the package (saying that SVN doesn’t like working with <code>.zip</code> files). Thus, we had to submit extracted PMA (but still original & untouched) to the repository.</li>
<li>PHP >= 7.2.5 is required to for <strong>phpMyAdmin</strong> latest version (otherwise you will have option to use older version of PMA, which is not encouraged to be used).</li>
<li>For the reason to make it compact, some unnecessary files (language files, OpenLayer/GIS map lib, extra themes, etc) are removed.</li>
<li>It’s recommended, that you enable the plugin only while you need to use PhpMyAdmin. Otherwise, for longer periods, you can deactivate plugin.</li>
</ul>
<h4>Liability</h4>
<p>We are not developers of PhpMyAdmin itself, neither affiliated with them. We just made this plugin as a wrapper (container) of official PhpMyAdmin, to make it possible to be installed as a WP plugin. However, we don’t monitor PhpMyAdmin package’s source code itself. We take no responsibility about this plugin. Use it at your own responsibility (However, as it’s also visible in stats, thousands of users are using this extendion and only few people have complained about errors).</p>
<h4>Available Options</h4>
<p>See all available options and their description on plugin’s settings page.</p>


WP phpMyAdmin

What a wonderful marriage of two pieces of software,

I work on WordPress sites allllll the time, it's very easy to facilitate access with a client to the dashboard, but I've had no end of trouble in the past trying to facilitate access to phpMyAdmin via the clients respective hosting.

This plugin has saved me an innumerable amount of time!

Supremely useful

I am sure the developer of this plugin will be a lovely guy like the plugin he/she has developed!

a Lovely Plugin

This is a lifesaver plugin when, for some reason, you don't have the database credentials and need to do some database operations.

A lifesaver plugin

Very helpful plugin. Saves a lot of time and hassle in certain circumstances. Thanks!

Very helpful


I love this plugin to debug my client sites.It is very easy and usefull solution


Very Usefull Plugin


I use this plugin on almost all of the WordPress sites I develop with.


Excellent Plugin

[ ✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 𝐵𝓎 𝒫𝓊𝓋𝑜𝓍 ] phpMyAdmin -  Database Browser & Manager (for MySQL & MariaDB)

EZ SQL Reports Shortcode Widget and DB Backup vs WP phpMyAdmin