SQL Executioner
Execute arbitrary SQL queries against your WordPress database from the Admin.
The facts
- Rating
- 4.6★ from 11
- Active installs
- 2k+
- Price
- Free
- Last updated
- 28 Sep 2016
- Added
- Nov 2012
- Requires WP
- 3.0
- Tested up to
- WP 4.6.30
- Downloads
- 54,841
Our analysis
AI-assistedSQL Executioner is a WordPress plugin that enables you to run SQL queries directly from the WordPress Admin interface. This allows you to view and modify your WordPress database without needing external tools like phpMyAdmin or the MySQL command line client.
The plugin is designed for users who require more control over their database operations and want to leverage the full capabilities of SQL for analysis and updates. It is suitable for developers or advanced users familiar with SQL who need to perform complex queries within their WordPress site.
Best for: This plugin suits developers or advanced users who need to manage their WordPress database directly.
What it does well
- ✓Allows running arbitrary SQL queries from the WordPress Admin
- ✓Bypasses limitations of the WordPress Admin interface
- ✓Useful for database analysis and updates
Where it falls short
- •Requires knowledge of SQL to use effectively
- •Last updated in September 2016, may not be compatible with newer versions of WordPress
Verdict
SQL Executioner provides a straightforward way to execute SQL queries within WordPress, but it requires SQL knowledge and may not be up-to-date with the latest WordPress versions.
From the developer
Justin Watt's own description of SQL Executioner, lightly tidied.
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