Members
94The best WordPress membership and user role editor plugin. User Roles & Capabilities editor helps you rest...
Free
300k+ installs 4.9★ (1,274)
Run SQL Query
Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.
The facts
- Rating
- 5★ from 1
- Active installs
- 500+
- Price
- Free
- Last updated
- 1 Aug 2016
- Added
- Aug 2016
- Requires WP
- 4.4
- Tested up to
- WP 4.5.33
- Downloads
- 14,833
Our analysis
AI-assistedRun SQL Query is a WordPress plugin that allows you to execute SQL queries directly on your WordPress database using the MySQLi extension. It provides an interface to run queries without needing additional tools like phpMyAdmin and lets you export the results in CSV format.
This plugin is intended for users with administrative capabilities, specifically Super Admins in multi-site installations or Admins in single-site setups. It is suitable for those who are comfortable working with SQL and need to manage their database directly from the WordPress dashboard.
Best for: Users with SQL knowledge who need direct database access within WordPress.
What it does well
- ✓Execute SQL queries directly in WordPress
- ✓Export query results in CSV format
- ✓No need for external tools like phpMyAdmin
Where it falls short
- •Requires admin-level access to use
- •Use at your own risk; potential for database damage
Verdict
Run SQL Query offers a straightforward way to manage database queries within WordPress, but it requires caution due to the risks involved.
From the developer
Fabricio Carella's own description of Run SQL Query, lightly tidied.
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.
Tagged as
Alternatives
Other plugins for moving data.
Manage all your WordPress updates, including individual updates, automatic updates, logs, and loads more. This...
Free
300k+ installs 4.8★ (725)
Redux is a simple, truly extensible, and fully responsive options framework for WordPress themes and plugins....
Free
900k+ installs 4.4★ (273)
PrettyLinks
90🌠 Shorten, brand, and track any URL on your own domain. Keep your links — and your data — where they belong....
Free
200k+ installs 4.8★ (1,317)
Export WooCommerce orders to Excel, CSV, XML, JSON, PDF and HTML. Best free order export plugin for WooCommerc...
Free
100k+ installs 5★ (350)
Easily export or import your WordPress customizer settings!
Free
100k+ installs 4.8★ (115)