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

Pexle Chris

<p>The best database management tool for the best CMS.</p>
<p>This plugin uses the tool <a href="https://www.adminer.org/" rel="nofollow ugc">Adminer</a>, in order to give database access to administrators directly from the Dashboard.<br />
As simple as the previous sentence!</p>
<p>I am not the author of Adminer. I am only the author who does the WordPress integration with Adminer.<br />
Author of Adminer is Jakub Vrana and you can donate him from <a href="https://www.paypal.com/donate/?item_name=Donation+to+Adminer&cmd=_donations&business=jakub%40vrana.cz" rel="nofollow ugc">there</a>.</p>
<p>Compatible also with WordPress Multisite installations</p>
<h3>WP Adminer access positions</h3>
<p>You can access the WP Adminer from the below positions:<br />
1. WP Adminer URL in the Admin Bar<br />
2. WP Adminer Tools Page (Dashboard > Tools > WP Adminer)</p>
<h3>Explore my other plugins</h3>
<ul>
<li><a href="https://www.pexlechris.dev/library-viewer/wp-wpadminer" rel="nofollow ugc">Library Viewer</a>: With Library Viewer, you can display the containing files and the containing folders of a “specific folder” of your (FTP) server to your users in the front-end.</li>
<li><a href="https://wordpress.org/plugins/gift-wrapping-for-woocommerce" rel="ugc">Gift Wrapping for WooCommerce</a>: This plugin allows customers to select a gift wrapper for their orders, via a checkbox in the checkout page.</li>
</ul>


Database Manager – WP Adminer

thanks for this plugin! easy to use and well structured!
you can easily edit your DB or whatever :)

very useful!

Thank you for this Adminer plugin! 

It has been a very long time (when ARI Adminer was taken offline) and is so very necessary as a database tool without having to bother clients for their database credentials.

Pieter

Adminer is back!

I've tried other Adminer solutions over the years - always having various connectivity issues, often being unable to connect to the DB.

This one always seems to connect correctly - great job!

Actually works!


Great plugin! This is what i was looking for.


Working as expected!


This is a solid database admin tool that has always worked for me, even on a variety of client sites running on a variety of hosting.



Much appreciated.


Solid database admin tool that has always worked

Manage the database from your WordPress Dashboard using Adminer.

EZ SQL Reports Shortcode Widget and DB Backup vs Database Manager – WP Adminer