GrandPlugins

DB Viewer lets you securely view your WordPress database directly from your website’s dashboard — no need to log in to your hosting account or use phpMyAdmin. Perfect for quick inspections and monitoring.
With the free version, you can:
<ul>
<li>Browse and view any database table </li>
<li>Inspect table structures and content inside WordPress </li>
<li>Safely explore your data without leaving the dashboard </li>
</ul>
🔥 Upgrade to <a href="https://grandplugins.com/product/wp-db-controller/" rel="nofollow ugc">DB Controller PRO</a> to unlock powerful database management features:
<ul>
<li>Empty any table with a single click </li>
<li>Delete tables you no longer need </li>
<li>Rename tables instantly </li>
<li>Search for any value across all columns </li>
<li>Add new rows directly from the dashboard </li>
<li>Edit any existing row inline </li>
</ul>
This makes the PRO version a complete lightweight alternative to phpMyAdmin, built directly into WordPress.

DB Viewer

View your WordPress database directly inside your Dashboard. No need for phpMyAdmin or hosting panels.

Olar Marius

Justin Watt

Instead of needing a tool like <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow ugc">phpMyAdmin</a> 
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

SQL Executioner

This plugin seems to me simple but very useful.

Simple and efficient

I use this plugin on a daily basis to run quick queries in the database while developing. Very very helpful!!!

Amazing Tool

Execute arbitrary SQL queries against your WordPress database from the Admin.

DB Viewer vs SQL Executioner