{"id":332621,"date":"2026-06-29T05:25:12","date_gmt":"2026-06-29T05:25:12","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/naveencodes-database-monitor\/"},"modified":"2026-06-29T05:24:47","modified_gmt":"2026-06-29T05:24:47","slug":"naveencodes-database-monitor","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/naveencodes-database-monitor\/","author":16310057,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0.1","stable_tag":"1.0.1","tested":"7.0","requires":"6.5","requires_php":"8.1","requires_plugins":null,"header_name":"NaveenCodes Database Monitor","header_author":"Naveen Goyal","header_description":"Complete database health dashboard \u2014 table inspector, one-click cleanup, scheduled maintenance, and real-time health scoring. Zero external requests.","assets_banners_color":"22190d","last_updated":"2026-06-29 05:24:47","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/wordpress.org\/plugins\/naveencodes-database-monitor\/","header_author_uri":"https:\/\/naveencodes.com\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":49,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.1":{"tag":"1.0.1","author":"shinu1503","date":"2026-06-29 05:24:47"}},"upgrade_notice":{"1.0.1":"<p>Fixes WP.org review issues. Update recommended.<\/p>","1.0.0":"<p>Initial release \u2014 no upgrade action needed.<\/p>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3589452,"resolution":"128x128","location":"assets","locale":"","width":128,"height":128},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3589452,"resolution":"256x256","location":"assets","locale":"","width":256,"height":256}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3589452,"resolution":"1544x500","location":"assets","locale":"","width":1544,"height":500},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3589452,"resolution":"772x250","location":"assets","locale":"","width":772,"height":250}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.1"],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"Dashboard \u2014 health gauge, stat cards, top tables bar chart","2":"Table Manager \u2014 full table list with optimize\/repair actions","3":"Cleanup Tools \u2014 8 cleanup cards with live counts","4":"Settings \u2014 automated cleanup, optimization, and email reports"}},"plugin_section":[262246],"plugin_tags":[3786,153,269364,4074,3869],"plugin_category":[52,59],"plugin_contributors":[232463],"plugin_business_model":[],"class_list":["post-332621","plugin","type-plugin","status-publish","hentry","plugin_section-dashboard-widgets","plugin_tags-cleanup","plugin_tags-database","plugin_tags-db-health","plugin_tags-monitor","plugin_tags-optimizer","plugin_category-performance","plugin_category-utilities-and-tools","plugin_contributors-shinu1503","plugin_committers-shinu1503"],"banners":{"banner":"https:\/\/ps.w.org\/naveencodes-database-monitor\/assets\/banner-772x250.png?rev=3589452","banner_2x":"https:\/\/ps.w.org\/naveencodes-database-monitor\/assets\/banner-1544x500.png?rev=3589452","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/naveencodes-database-monitor\/assets\/icon-128x128.png?rev=3589452","icon_2x":"https:\/\/ps.w.org\/naveencodes-database-monitor\/assets\/icon-256x256.png?rev=3589452","generated":false},"screenshots":[],"raw_content":"<!--section=description-->\n<p><strong>NaveenCodes Database Monitor<\/strong> is a professional, OOP-based plugin that gives WordPress site owners and developers complete visibility and control over their database.<\/p>\n\n<h4>Features<\/h4>\n\n<p><strong>Dashboard<\/strong>\n* Animated circular health score (0\u2013100) calculated from real overhead and junk data\n* Database size, table count, total rows, and overhead \u2014 live-refreshing every 60 seconds\n* Top-tables bar chart with animated fill\n* Quick actions: Run Cleanup \/ Optimize All<\/p>\n\n<p><strong>Table Manager<\/strong>\n* Full table list with data size, index size, overhead, row count, and engine\n* Per-table Optimize and Repair with real-time status\n* Bulk \"Optimize All tables with overhead\" with confirmation dialog\n* Live search\/filter across all table names<\/p>\n\n<p><strong>Cleanup Tools<\/strong>\n* 8 cleanup types \u2014 each with a live count and single-click clean:\n  * Post Revisions\n  * Auto Drafts\n  * Trashed Posts (with orphaned postmeta)\n  * Spam Comments (with orphaned commentmeta)\n  * Trashed Comments\n  * Expired Transients\n  * Orphaned Post Meta\n  * Orphaned Comment Meta\n* \"Run Full Cleanup\" button runs all enabled types at once\n* Full cleanup history log with duration, items removed, and trigger source<\/p>\n\n<p><strong>Query Runner<\/strong>\n* SELECT-only safe query textarea with syntax hint\n* Ctrl+Enter shortcut to run\n* 6 built-in quick-query templates\n* Results table with execution time and row count<\/p>\n\n<p><strong>Automated Maintenance<\/strong>\n* Scheduled cleanup: daily, weekly, or monthly (WP-Cron)\n* Scheduled table optimization: daily, weekly, or monthly\n* Per-type cleanup toggle \u2014 enable only what you need\n* Weekly database health email report<\/p>\n\n<p><strong>Settings<\/strong>\n* Full control over all automation and email settings\n* Log retention: configurable 7\u2013365 days\n* Query Runner toggle (developer sites only)<\/p>\n\n<p><strong>Design<\/strong>\n* Animated database cylinder in page headers\n* Floating 3D cubes background decoration\n* Responsive \u2014 works on all screen sizes<\/p>\n\n<h4>Free Forever<\/h4>\n\n<p>No upsells. No premium version. All features free, forever.<\/p>\n\n<h4>Privacy<\/h4>\n\n<p>This plugin does not collect or transmit any data outside your own WordPress site. Email reports are sent only to the configured admin email address.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the <code>naveencodes-database-monitor<\/code> folder to the <code>\/wp-content\/plugins\/<\/code> directory.<\/li>\n<li>Activate the plugin through the <strong>Plugins<\/strong> menu in WordPress.<\/li>\n<li>Navigate to <strong>DB Monitor<\/strong> in the admin sidebar.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"is%20this%20plugin%20safe%20to%20use%20on%20production%20sites%3F\"><h3>Is this plugin safe to use on production sites?<\/h3><\/dt>\n<dd><p>Yes. All cleanup operations use WordPress API functions and standard SQL with <code>$wpdb-&gt;prepare()<\/code>. The Query Runner is restricted to SELECT queries only.<\/p><\/dd>\n<dt id=\"can%20i%20undo%20a%20cleanup%3F\"><h3>Can I undo a cleanup?<\/h3><\/dt>\n<dd><p>Cleanup operations permanently delete data (revisions, drafts, spam, etc.). Always take a database backup before running bulk operations.<\/p><\/dd>\n<dt id=\"what%20does%20the%20health%20score%20measure%3F\"><h3>What does the Health Score measure?<\/h3><\/dt>\n<dd><p>The score starts at 100 and deducts points for overhead percentage, tables with &gt;1 MB overhead, and total cleanable item count. A score of 80+ is excellent.<\/p><\/dd>\n<dt id=\"does%20it%20work%20with%20custom%20table%20prefixes%3F\"><h3>Does it work with custom table prefixes?<\/h3><\/dt>\n<dd><p>Yes. All queries use <code>$wpdb<\/code> table properties and properly handle any table prefix.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>Fixed: Dashboard widget CSS is now loaded via wp_add_inline_style() instead of an inline style tag.<\/li>\n<li>Removed: Query Runner feature \u2014 removed in response to WP.org guidelines on raw SQL from user input.<\/li>\n<li>Updated: Tested up to WordPress 7.0.<\/li>\n<\/ul>\n\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Initial release.<\/li>\n<li>Dashboard with animated health gauge and bar chart.<\/li>\n<li>Table Manager with per-table optimize\/repair.<\/li>\n<li>Cleanup Tools for 8 junk data types.<\/li>\n<li>Scheduled cleanup and optimization via WP-Cron.<\/li>\n<li>Weekly email health report.<\/li>\n<li>Full cleanup operation log.<\/li>\n<\/ul>","raw_excerpt":"WordPress database monitor \u2014 health scoring, table manager, one-click cleanup, and scheduled maintenance. Zero external requests.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/332621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=332621"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/shinu1503"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=332621"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=332621"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=332621"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=332621"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=332621"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=332621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}