Extremely simple way for developers to create new tables inside the existing WordPress database. Forget the annoying process of opening phpMyAdmin, logging in, then typing out the full SQL command for your new table. With this plugin, everything you need to do is located on one simple to use page, and you don't have to type out any SQL queries! This plugin also keeps record of the tables you've created. It is perfect for the developer who wants to quickly and easily add new database tables in a quick and effective manner.
TableMaster
TableMaster is a simple and easy to use plugin that will print styled and responsive tables (containing your own dynamic data) from any WordPress database table to your page or post. In addition, TableMaster integrates the DataTables table plugin for jQuery with the Buttons and Responsive extension.........
Utf8ize
Convert all your database character sets to utf8, trying to follow Codex guides. You should use this if you are experiencing double utf8 encoding. You can check this by setting DB_CHARSET in your wp-config.php file to latin1 or commenting the line; if your characters look good now on your site than .........
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....
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.........
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.........
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.........
Edit Any Table
This plugin can be integrated as a dashboard widget or use its own admin page to allow you to connect to any MySQL database of your choice (as long as your hosting allows) and search, edit, add and delete records in an easy to use interface. Ideal if you have built a site referencing another databa.........
WP-DBManager
Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database....
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.........
