{"id":218930,"date":"2025-02-05T05:35:27","date_gmt":"2025-02-05T05:35:27","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/db-table-viewer\/"},"modified":"2026-10-23T07:08:29","modified_gmt":"2026-10-23T07:08:29","slug":"db-table-viewer","status":"publish","type":"plugin","link":"https:\/\/tuk.wordpress.org\/plugins\/db-table-viewer\/","author":20751968,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.1","stable_tag":"1.1","tested":"6.9.10","requires":"6.2","requires_php":"7.2","requires_plugins":null,"header_name":"DB Table Viewer","header_author":"Vrutti22","header_description":"View and paginate database table data in a user-friendly format.","assets_banners_color":"","last_updated":"2026-10-23 07:08:29","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"https:\/\/profiles.wordpress.org\/vrutti22\/","rating":0,"author_block_rating":0,"active_installs":90,"downloads":1773,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0":{"tag":"1.0","author":"vrutti22","date":"2026-10-23 07:05:05","revision":3761056},"1.1":{"tag":"1.1","author":"vrutti22","date":"2026-10-23 07:08:29","revision":3761063}},"upgrade_notice":{"1.1":"<p>Security update. Adds request verification and strict table validation. Requires WordPress 6.2 or later.<\/p>"},"ratings":[],"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","1.1"],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"The DB Table Viewer entry in the Tools menu.","2":"The table selection dropdown.","3":"A paginated view of the selected table's data."}},"plugin_section":[],"plugin_tags":[83,153,900,2289,747],"plugin_category":[59],"plugin_contributors":[267773],"plugin_business_model":[],"class_list":["post-218930","plugin","type-plugin","status-publish","hentry","plugin_tags-admin","plugin_tags-database","plugin_tags-pagination","plugin_tags-table","plugin_tags-viewer","plugin_category-utilities-and-tools","plugin_contributors-vrutti22","plugin_committers-vrutti22"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/db-table-viewer.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p>DB Table Viewer is a simple, read-only plugin that allows administrators to:<\/p>\n\n<ul>\n<li>Select any table in the WordPress database.<\/li>\n<li>View its data in a clean, paginated HTML table.<\/li>\n<li>Navigate through rows using AJAX-based pagination.<\/li>\n<\/ul>\n\n<p>This plugin is particularly useful for debugging or inspecting custom database tables without writing SQL queries.<\/p>\n\n<h4>Features<\/h4>\n\n<ul>\n<li>Dropdown to select from available database tables.<\/li>\n<li>Displays table data in a well-formatted, horizontally scrollable table.<\/li>\n<li>AJAX-based pagination that stays fast on large tables.<\/li>\n<li>Long values are shortened with a \"Show more\" toggle; NULL and binary values are clearly marked.<\/li>\n<li>Secure: nonce-protected requests, strict table validation and escaped output.<\/li>\n<li>Fully translation-ready.<\/li>\n<\/ul>\n\n<!--section=installation-->\n<ol>\n<li>Upload the <code>db-table-viewer<\/code> folder to the <code>\/wp-content\/plugins\/<\/code> directory, or install the plugin through the WordPress plugins screen.<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress.<\/li>\n<li>Navigate to <strong>Tools &gt; DB Table Viewer<\/strong> to use the plugin.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"who%20can%20use%20this%20plugin%3F\"><h3>Who can use this plugin?<\/h3><\/dt>\n<dd><p>Only administrators with the <code>manage_options<\/code> capability. On Multisite, only super admins can use it, because all sites share one database.<\/p><\/dd>\n<dt id=\"can%20this%20plugin%20modify%20database%20data%3F\"><h3>Can this plugin modify database data?<\/h3><\/dt>\n<dd><p>No, the plugin is read-only and does not allow any modifications to the database.<\/p><\/dd>\n<dt id=\"what%20happens%20if%20i%20select%20a%20table%20with%20no%20data%3F\"><h3>What happens if I select a table with no data?<\/h3><\/dt>\n<dd><p>The table's columns are shown along with a message that the table is empty.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.1<\/h4>\n\n<ul>\n<li>Security: added nonce verification to AJAX requests.<\/li>\n<li>Security: table names are now validated against the database's table list.<\/li>\n<li>Security: on Multisite, access is restricted to super admins.<\/li>\n<li>Fix: pagination now shows a compact page range instead of one button per page.<\/li>\n<li>Fix: empty tables show their column headers.<\/li>\n<li>Fix: invalid or out-of-range page numbers no longer cause SQL errors.<\/li>\n<li>Fix: PHP notices for missing request parameters and placeholder-less prepared queries.<\/li>\n<li>Improvement: long values are truncated with a \"Show more\" toggle; NULL and binary values are labelled.<\/li>\n<li>Improvement: wide tables scroll horizontally.<\/li>\n<li>Improvement: all JavaScript strings are translatable.<\/li>\n<li>Improvement: prefixed AJAX action, class and CSS names to avoid conflicts with other plugins.<\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>Initial release.<\/li>\n<\/ul>","raw_excerpt":"View and paginate database table data in a user-friendly format.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/218930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=218930"}],"author":[{"embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/vrutti22"}],"wp:attachment":[{"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=218930"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=218930"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=218930"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=218930"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=218930"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/tuk.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=218930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}