{"id":277390,"date":"2026-01-27T16:44:30","date_gmt":"2026-01-27T16:44:30","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/sac-database-inspector\/"},"modified":"2026-01-27T19:14:29","modified_gmt":"2026-01-27T19:14:29","slug":"sac-database-inspector","status":"publish","type":"plugin","link":"https:\/\/szl.wordpress.org\/plugins\/sac-database-inspector\/","author":18772735,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.2.0","stable_tag":"0.2.0","tested":"6.9.4","requires":"6.9","requires_php":"7.4","requires_plugins":null,"header_name":"SAC Database Inspector","header_author":"jackofall1232","header_description":"Read-only administrative utility for inspecting database tables and cache usage to help identify potential bloat.","assets_banners_color":"a6b6bd","last_updated":"2026-01-27 19:14:29","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/github.com\/jackofall1232\/sac-database-inspector","header_author_uri":"https:\/\/wordpress.org","rating":0,"author_block_rating":0,"active_installs":10,"downloads":158,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"0.1.3":{"tag":"0.1.3","author":"jackofall1232","date":"2026-01-27 16:44:11"},"0.2.0":{"tag":"0.2.0","author":"jackofall1232","date":"2026-01-27 19:14:29"}},"upgrade_notice":{"0.1.2":"

Compliance update. No functional changes.<\/p>"},"ratings":[],"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":3448149,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":3448058,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.1.3","0.2.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3448058,"resolution":"1","location":"assets","locale":""}},"screenshots":{"1":"Database health gauge and overview","2":"Cleanup actions dashboard","3":"Top autoloaded options table"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[39231,146,4654,247,12113],"plugin_category":[52,54],"plugin_contributors":[249752],"plugin_business_model":[],"class_list":["post-277390","plugin","type-plugin","status-publish","hentry","plugin_tags-admin-tools","plugin_tags-cache","plugin_tags-database-cleaner","plugin_tags-performance","plugin_tags-transients","plugin_category-performance","plugin_category-security-and-spam-protection","plugin_contributors-jackofall1232","plugin_committers-jackofall1232"],"banners":{"banner":"https:\/\/ps.w.org\/sac-database-inspector\/assets\/banner-772x250.jpg?rev=3448058","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/sac-database-inspector\/assets\/icon-256x256.png?rev=3448149","icon_2x":"https:\/\/ps.w.org\/sac-database-inspector\/assets\/icon-256x256.png?rev=3448149","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/sac-database-inspector\/assets\/screenshot-1.png?rev=3448058","caption":"Database health gauge and overview"}],"raw_content":"\n

SAC Database Inspector<\/strong> is a lightweight, admin-only utility designed to help site administrators understand what is stored in their site\u2019s database and cache \u2014 and clean it up safely when needed.<\/p>\n\n

Unlike aggressive \u201coptimizer\u201d plugins, Database Inspector focuses on visibility first<\/strong>, showing you where bloat exists before offering optional, manual cleanup actions.<\/p>\n\n

Key features:<\/h3>\n\n
    \n
  • Database health gauge with clear visual feedback<\/li>\n
  • View total database size (when supported by hosting)<\/li>\n
  • Inspect autoloaded options that load on every page<\/li>\n
  • Identify expired and unused transients<\/li>\n
  • Detect post revisions, auto-drafts, spam, and trash<\/li>\n
  • Find orphaned post meta and comment meta<\/li>\n
  • Flush external object cache (when enabled)<\/li>\n
  • Optional read-only mode via filter for audit-only environments<\/li>\n
  • Multisite-aware and shared-host safe<\/li>\n
  • No frontend impact \u2014 admin-only<\/li>\n
  • Contextual source identification for autoloaded options<\/li>\n<\/ul>\n\n

    All cleanup actions require explicit confirmation and are protected by nonces and capability checks.<\/p>\n\n

    Developer Notes<\/h3>\n\n

    This plugin follows coding standards and avoids aggressive optimization tactics. It is intended as a transparent inspection and maintenance tool, not an automatic optimizer.<\/p>\n\n

    Filters and actions are provided for extensibility.<\/p>\n\n\n

      \n
    1. Upload the plugin folder to \/wp-content\/plugins\/<\/code>, or install via the Plugins screen.<\/li>\n
    2. Activate the plugin through the Plugins<\/strong> menu.<\/li>\n
    3. Navigate to Tools \u2192 DB Inspector<\/strong> to view database statistics.<\/li>\n<\/ol>\n\n\n
      \n

      Is this plugin safe to use?<\/h3><\/dt>\n

      Yes. All cleanup actions are manual, protected, and clearly labeled. No background jobs or automatic deletions are performed.<\/p><\/dd>\n

      Does this work on shared hosting?<\/h3><\/dt>\n

      Yes. If database size information is restricted by your host, the plugin degrades gracefully without errors.<\/p><\/dd>\n

      Does this support multisite?<\/h3><\/dt>\n

      Yes. Multisite installations are supported, including site transients and object cache detection.<\/p><\/dd>\n

      Does this affect frontend performance?<\/h3><\/dt>\n

      No. The plugin loads only in the admin area.<\/p><\/dd>\n

      Can I disable cleanup actions?<\/h3><\/dt>\n

      Yes. Developers can enable read-only mode using the wpdi_read_only<\/code> filter.<\/p><\/dd>\n

      How does the plugin identify option sources?<\/h3><\/dt>\n

      The plugin uses pattern matching based on option name prefixes and common WordPress naming conventions. This is an educated guess, not definitive information. Source identification helps you understand which plugin or system component likely created an option.<\/p><\/dd>\n\n<\/dl>\n\n\n

      0.2.0<\/h4>\n\n
        \n
      • Added: Source identification column in autoloaded options table<\/li>\n
      • Added: Pattern-based detection for common plugins and WordPress core options<\/li>\n
      • Improved: Better context for understanding option origins<\/li>\n<\/ul>\n\n

        0.1.1<\/h4>\n\n
          \n
        • Naming and compliance updates<\/li>\n
        • Plugin Check fixes<\/li>\n
        • No functional changes<\/li>\n<\/ul>\n\n

          0.1.0<\/h4>\n\n
            \n
          • Initial release<\/li>\n
          • Database inspection dashboard<\/li>\n
          • Safe manual cleanup actions<\/li>\n
          • Read-only mode support<\/li>\n
          • Multisite compatibility<\/li>\n<\/ul>","raw_excerpt":"Inspect database usage, autoloaded options, transients, and safely clean database clutter from a single admin dashboard.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/277390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=277390"}],"author":[{"embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/jackofall1232"}],"wp:attachment":[{"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=277390"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=277390"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=277390"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=277390"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=277390"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/szl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=277390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}