Description
DB Table Viewer is a simple, read-only plugin that allows administrators to:
- Select any table in the WordPress database.
- View its data in a clean, paginated HTML table.
- Navigate through rows using AJAX-based pagination.
This plugin is particularly useful for debugging or inspecting custom database tables without writing SQL queries.
Features
- Dropdown to select from available database tables.
- Displays table data in a well-formatted, horizontally scrollable table.
- AJAX-based pagination that stays fast on large tables.
- Long values are shortened with a “Show more” toggle; NULL and binary values are clearly marked.
- Secure: nonce-protected requests, strict table validation and escaped output.
- Fully translation-ready.
Installation
- Upload the
db-table-viewerfolder to the/wp-content/plugins/directory, or install the plugin through the WordPress plugins screen. - Activate the plugin through the ‘Plugins’ menu in WordPress.
- Navigate to Tools > DB Table Viewer to use the plugin.
FAQ
-
Who can use this plugin?
-
Only administrators with the
manage_optionscapability. On Multisite, only super admins can use it, because all sites share one database. -
Can this plugin modify database data?
-
No, the plugin is read-only and does not allow any modifications to the database.
-
What happens if I select a table with no data?
-
The table’s columns are shown along with a message that the table is empty.
Reviews
There are no reviews for this plugin.
Contributors & Developers
“DB Table Viewer” is open source software. The following people have contributed to this plugin.
Contributors
Translate “DB Table Viewer” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.1
- Security: added nonce verification to AJAX requests.
- Security: table names are now validated against the database’s table list.
- Security: on Multisite, access is restricted to super admins.
- Fix: pagination now shows a compact page range instead of one button per page.
- Fix: empty tables show their column headers.
- Fix: invalid or out-of-range page numbers no longer cause SQL errors.
- Fix: PHP notices for missing request parameters and placeholder-less prepared queries.
- Improvement: long values are truncated with a “Show more” toggle; NULL and binary values are labelled.
- Improvement: wide tables scroll horizontally.
- Improvement: all JavaScript strings are translatable.
- Improvement: prefixed AJAX action, class and CSS names to avoid conflicts with other plugins.
1.0
- Initial release.