Database Browser

Descripcion

Ever needed to check some data in one of your WordPress database tables, but don’t have PHPMyAdmin available? Now you can easily query your data and export it in HTML, XML, CSV, SQL (insert statements) and JSON formats with a simple plugin.

There are other options, for example you can write your own ‘where’ and ‘order by’ clauses, and pagination is built-in. You can also see the complete query run against your database. And you can even save queries with custom names, so if there are queries you use a lot they are only a click away.

Screenshots

  • The database browser form

Installacion

  1. Upload plugin-name.php to the /wp-content/plugins/ directory, or install from the Plugin browser
  2. Activate the plugin through the ‘Plugins’ menu in WordPress

FAQ

Can I delete my data?

Yes, it is possible to delete or modify data using the custom query, ‘Where’ and ‘Order by’ boxes. Be careful.

Who can export the data?

Only people with export permisions – the people who can run your WordPress export file.

Reviews

24 setembre 2020
I've had trouble today loading the Thrive Apprentice page editor and the TA control panel. I've tracked it down to this plugin. I notice it isn't tested with the latest version of WP. Might need a little tweaking...?!?
3 setembre 2020
the extension generate js error it make impossible to add news users in WP the password button can't work i had to desactivate the plugin , and then i can add WP users and after that, i reactivate the database browser plugin it needs an update thanks
27 junh 2017
Usually I troubleshoot databases using phpMyAdmin, but this week I'm helping someone with a site whose hosting doesn't give me access to that. I need to see raw DB contents, and wasn't looking forward to writing a bunch of custom PHP/MySQL queries. Then I found this plugin. Thank you for writing it. What a time saver. Obviously it's doesn't have nearly as many features as phpMyAdmin, and I'm fine with that. This is a great, simple way inspect (and apparently update) the WP DB.
Read all 14 reviews

Contributors & Developers

“Database Browser” is open source software. The following people have contributed to this plugin.

Contributors

Translate “Database Browser” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.4.3 (2020/03/10)

Fixed styling of pagination links. Tested with WordPress 5.3.2.

1.4.2 (2017/01/29)

Fixed deprecation error messages.

1.4.1 (2017/01/10)

Tested with WordPress 4.7.

1.4 (2016/10/16)

Added UTF decoding, as per suggestion by @darktek (https://wordpress.org/support/topic/exporting-into-csv-character-error/)
Added unit tests for output methods

1.3 (2015/04/20)

Enabled plugin to handle non-standard plugin folders. Tested up to 4.2.

1.2 (2014/03/28)

Added functionality to save queries with custom names
Rewrote much of the plugin
Reconfigured the UI
Added Spanish translation (thanks to Andrew at http://www.webhostinghub.com/)

1.1.4 (2013/05/29)

Fixed load_plugin_textdomain() call so translations will work properly.

1.1.3 (2013/01/05)

Fixed incorrect $wpdb->prepare() call.

1.1.2 (2011/10/11)

Fixed SQL for column names which are keywords.

1.1.1 (2011/01/04)

Fixed incorrect link for CSV download. Changed table cell styling. Removed pagination links for custom queries. Removed SQL_CALC_FOUND_ROWS in custom queries.

1.1 (2010/12/22)

Added the ability to run custom queries, and export the results. Also added nonce security (thanks to Julio from Boiteaweb.fr). Added Plugin Register.

1.0 (2010/12/06)

Initial version committed.