FAIR

Federated and Independent Repositories

SAC Database Inspector

Plugin Banner

SAC Database Inspector

by Joe

Download
Description

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.

  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.
  1. Database health gauge and overview

    Database health gauge and overview

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.

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
Back to top