Backup, restore or migrate your WordPress website to another host or domain. Schedule backups or run manually....
Free
3M+ installs 4.8★ (8,631)
EZ SQL Reports Shortcode Widget and DB Backup
Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.
The facts
- Rating
- 4.7★ from 15
- Active installs
- 500+
- Price
- Free
- Last updated
- 26 Jun 2025
- Added
- Dec 2011
- Requires WP
- 2.6
- Tested up to
- WP 6.8.8
- Downloads
- 25,402
Our analysis
AI-assistedEZ SQL Reports Shortcode Widget and DB Backup is a WordPress plugin that allows you to create and manage SQL reports easily. You can save multiple reports, which will be accessible from the Admin Menu for quick execution. The plugin also enables you to display reports on user dashboards based on roles and embed them in pages or posts using shortcodes.
In addition to report generation, the plugin offers automatic database backups that can be scheduled hourly or daily. Backups can be emailed to a specified address and restored to your WordPress database or an external database, facilitating easy data management and migration.
Best for: This plugin is suitable for WordPress site administrators needing to manage SQL reports and database backups.
What it does well
- ✓Create and manage multiple SQL reports
- ✓Embed reports in pages or posts using shortcodes
- ✓Automatic database backups can be scheduled
- ✓Backups can be emailed and restored easily
Where it falls short
- •Requires admin user to create SQL reports for security reasons
- •Limited information on additional features
Verdict
EZ SQL Reports Shortcode Widget and DB Backup offers useful functionalities for SQL reporting and database management, making it a practical choice for site administrators.
From the developer
Eli's own description of EZ SQL Reports Shortcode Widget and DB Backup, lightly tidied.
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 Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]
There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site:
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.
If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode.
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.
Automatic Database Backups
Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.
Tagged as
purpose
Backup & Restore
Alternatives
Other plugins for backups.
Trusted by 60M+ sites: The gold standard for WordPress migration and backup. Migrate, backup, and restore your...
Free
5M+ installs 4.5★ (7,664)
Duplicator
93The best WordPress backup and migration plugin. Quickly and easily backup ,migrate, copy, move, or clone your...
Free
1M+ installs 4.9★ (4,929)
WPvivid
93All-in-one WordPress backup, migration and staging plugin — schedule automatic backups, restore in one click,...
Free
900k+ installs 4.9★ (1,536)
Disable Gutenberg Block Editor and restore the Classic Editor and original Edit Post screen (TinyMCE, meta box...
Free
500k+ installs 5★ (733)
WP STAGING
92WordPress backup plugin: backups, restore & migration in minutes. Clone or duplicate your site, test updat...
Free
100k+ installs 4.8★ (2,464)