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 limitations of the WordPress Admin interface, and use the full expressive
power of SQL to analyze and update your blog's database.
To use simply install and visit the Tools > SQL Executioner page.
If you're interested in contributing to the code behind this plugin, it's also hosted on GitHub:
https://github.com/justincwatt/wp-sql-executioner
Run SQL Query
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.........
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.........
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 .........
WP DB Booster
WP DB Booster will help you to clean up, optimize and analyze your WordPress database with few clicks.
You can clean up and optimize more than 20 various data types including orphan and duplicate metadata that can bloat your database.
If you edit your posts or pages WordPress creates revision each .........
Clean Up Booster - Optimize DB & WordPress
Clean Up Booster is a Superlative High quality WordPress Plugin which allows you to clean up the WordPress Database.
The following things should be clean with the Clean Up Booster, which are mentioned below:
Auto Drafts
Dashboard Transient Feed
Unapproved Comments
Orphan Comments Meta
Orphan Post.........
