SAC Database Inspector

外掛說明

SAC Database Inspector is a lightweight, admin-only utility designed to help site administrators understand what is stored in their site’s database and cache — and clean it up safely when needed.

Unlike aggressive “optimizer” plugins, Database Inspector focuses on visibility first, showing you where bloat exists before offering optional, manual cleanup actions.

Key features:

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

All cleanup actions require explicit confirmation and are protected by nonces and capability checks.

Developer Notes

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

Filters and actions are provided for extensibility.

螢幕擷圖

  • Database health gauge and overview

安裝方式

  1. Upload the plugin folder to /wp-content/plugins/, or install via the Plugins screen.
  2. Activate the plugin through the Plugins menu.
  3. Navigate to Tools DB Inspector to view database statistics.

常見問題集

Is this plugin safe to use?

Yes. All cleanup actions are manual, protected, and clearly labeled. No background jobs or automatic deletions are performed.

Does this work on shared hosting?

Yes. If database size information is restricted by your host, the plugin degrades gracefully without errors.

Does this support multisite?

Yes. Multisite installations are supported, including site transients and object cache detection.

Does this affect frontend performance?

No. The plugin loads only in the admin area.

Can I disable cleanup actions?

Yes. Developers can enable read-only mode using the wpdi_read_only filter.

How does the plugin identify option sources?

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.

使用者評論

這個外掛目前沒有任何使用者評論。

參與者及開發者

以下人員參與了開源軟體〈SAC Database Inspector〉的開發相關工作。

參與者

將〈SAC Database Inspector〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

0.2.0

  • Added: Source identification column in autoloaded options table
  • Added: Pattern-based detection for common plugins and WordPress core options
  • Improved: Better context for understanding option origins

0.1.1

  • Naming and compliance updates
  • Plugin Check fixes
  • No functional changes

0.1.0

  • Initial release
  • Database inspection dashboard
  • Safe manual cleanup actions
  • Read-only mode support
  • Multisite compatibility