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 install_plugins
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.
SQL Executioner
Instead of needing a tool like phpMyAdmin
or the mysql command line client to view and modify your WordPress database,
the SQL Executioner allows you to run arbitrary SQL queries against your
WordPress database from within the Admin. In many cases this allows you to bypass
the inherent limitation.........
ABASE
The ABASE shortcode accesses a MySQL database without having to code PHP. Over 30 optional attribute values specify whether a shortcode on a page is replaced with an HTML input form or an SQL query output. Forms to search, insert, update or delete records are easy to specify. Output can be a formatt.........
dbview
Presents the results a database SQL query in a table. The query can be saved as a
named view which can then be embedded as a table in any post using the shortcode
[dbview name=name-of-view]. Views can be created and edited in the dashboard....
Enhanced SQL Portal Bridge
This bridge plugin automatically logs you into your database with the Enhanced SQL Portal (ESP). You can either login to your WordPress database with 1 click or go to the login screen and login to a different database on your server. ESP is a database management GUI that makes it easier to:
Manage.........
Adminer
Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. This plugin include this tool in WordPress for a fast management of your database. Adminer is also used without this plu.........
CustomQuery
Review your database, read out your tables and see what...
MySQL Profiler
MySQL Profiler displays debugging information about SQL queries to admin WordPress users. For each query, the profiler displays the time, syntax-highlighted SQL, and a trace of the functions (as well as the file and line number that the functions were called from) that were called.
The list can be.........
EZ SQL Reports Shortcode Widget and DB Backup
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 .........
Easy WP Cleaner
Easy WP Cleaner is user friendly plugin to clean unnecessary data from WordPress database like "revision", "draft", "auto draft", "moderated comments", "spam comments", "trash comments", "orphan postmeta", "orphan commentmeta", "orphan relationships", "dashboard transient feed" and this plugin also .........
Clean Up Optimizer - Optimize & Clean Database
WP Clean Up Optimizer optimizes your WordPress as well as clean up the obsolete data from database. You can schedule the
process of Cleaning, Optimizing , Deleting and Repairing the database tables without going to phpMyAdmin.
By removing revision, draft, auto draft, moderated comments, spam comme.........