Title: SAC Database Inspector
Author: Ask Adam
Published: <strong>January 27, 2026</strong>
Last modified: August 10, 2026

---

Search plugins

![](https://ps.w.org/sac-database-inspector/assets/banner-772x250.jpg?rev=3448058)

![](https://ps.w.org/sac-database-inspector/assets/icon-256x256.png?rev=3448149)

# SAC Database Inspector

 By [Ask Adam](https://profiles.wordpress.org/jackofall1232/)

[Download](https://downloads.wordpress.org/plugin/sac-database-inspector.1.1.1.zip)

 * [Details](https://kal.wordpress.org/plugins/sac-database-inspector/#description)
 * [Reviews](https://kal.wordpress.org/plugins/sac-database-inspector/#reviews)
 *  [Installation](https://kal.wordpress.org/plugins/sac-database-inspector/#installation)
 * [Development](https://kal.wordpress.org/plugins/sac-database-inspector/#developers)

 [Support](https://wordpress.org/support/plugin/sac-database-inspector/)

## Description

SAC Database Inspector helps administrators understand what is using the WordPress
database before deciding whether maintenance is appropriate.

It is inspection-first: no background cleanup, “clean everything” action, telemetry,
paid feature, or automatic external request is included.

#### Database diagnostics

 * Runtime, storage, and maintenance health categories
 * Deterministic and explainable health penalty score
 * Database and table sizes when the host permits access
 * Graceful fallback when `information_schema` is restricted
 * Object-cache status and bounded maintenance counts

#### Ownership and footprints

 * Conservative plugin option, metadata, transient, and custom-table estimates
 * Active, inactive, not-installed, WordPress core, theme, and unknown owner states
 * Explicit ownership confidence and evidence
 * Inactive installed plugins are never treated as missing

#### Autoload and ghost data

 * Paginated, searchable, size-sorted autoload inspector
 * Serialized, protected, owner, status, confidence, and size indicators
 * Capped option previews with centralized sensitive-name redaction
 * Orphan metadata, expired transient, missing-plugin option/table, and stale cron
   findings
 * Heuristic findings are read-only and never automatically deleted

#### Controlled maintenance and rollback

 * Capability, nonce, target, read-only-mode, and explicit-confirmation checks
 * At most 100 records changed per request
 * Lightweight local safety snapshots before supported changes
 * Restoration for options, autoload state, and orphan metadata
 * Protected WordPress options cannot have autoload changed

#### Reports and optional AI

 * Redacted JSON, CSV, and HTML exports from one normalized report
 * Optional WordPress 7.0 AI Client explanations when a text provider is configured
 * Provider-neutral integration with no SAC API-key settings
 * AI receives capped metadata, not raw option values or database credentials
 * AI cannot run SQL, clean data, change options, or restore snapshots
 * All deterministic features work without AI

### Privacy and external services

SAC has no telemetry or tracking. Database inspection and exports are local.

If an administrator explicitly requests an AI explanation, SAC passes a capped and
redacted metadata-only diagnostic context to the provider selected through WordPress
Settings  Connectors. The external service, data handling, and terms depend on the
connector/provider configured by the site owner. SAC does not store provider credentials
and does not send raw option values, database credentials, WordPress salts, private
keys, or authentication tokens.

## Screenshots

[⌊Database health overview and bounded maintenance actions⌉⌊Database health overview
and bounded maintenance actions⌉[

Database health overview and bounded maintenance actions

## Installation

 1. Upload the plugin folder to `/wp-content/plugins/`, or install it through the Plugins
    screen.
 2. Activate SAC Database Inspector.
 3. Open Tools  DB Inspector.

## FAQ

### Does the plugin change data automatically?

No. Scanning is read-only. Every maintenance action is initiated explicitly by an
administrator, handles a bounded batch, and creates a safety snapshot where practical.

### Is plugin ownership guaranteed?

No. SAC uses conservative exact-prefix evidence and reports confidence. Unknown 
data remains unknown, and heuristic ownership never authorizes deletion.

### Is data from an inactive plugin considered orphaned?

No. Inactive but installed plugins have a distinct status and are not treated as
missing.

### What happens when database size access is restricted?

Table and total-size fields are marked unavailable. Other diagnostics continue to
work, and restricted `information_schema` access is not treated as database failure.

### How are snapshots stored?

Snapshots are stored locally in a non-autoloaded WordPress option, limited to 20
operations and 14 days, and removed when the plugin is uninstalled. Snapshot values
are excluded from exports and AI context.

### Does AI have access to cleanup tools?

No. AI is an optional explanation layer. It receives a capped, redacted metadata
report only after an administrator requests an explanation. No mutation ability 
or database credential is exposed.

### Does SAC contact an AI provider when AI is unavailable?

No. AI UI is enabled only when WordPress reports that configured text generation
is supported. All other functionality is independent of AI.

### Can I disable every maintenance action?

Yes. Add `add_filter( 'wpdi_read_only', '__return_true' );` in site-specific code.

## Reviews

![](https://secure.gravatar.com/avatar/cd4bf5ad28b1eb36e0cc0c73fda49a08bb6e024e8ee5e743eb0dca0c8e6080b1?
s=60&d=retro&r=g)

### 󠀁[works well](https://wordpress.org/support/topic/works-well-3161/)󠁿

 [pagrob](https://profiles.wordpress.org/pagrob/) April 14, 2026 1 reply

works well does what is necessary without creating problems

 [ Read all 1 review ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/)

## Contributors & Developers

“SAC Database Inspector” is open source software. The following people have contributed
to this plugin.

Contributors

 *   [ Ask Adam ](https://profiles.wordpress.org/jackofall1232/)

[Translate “SAC Database Inspector” into your language.](https://translate.wordpress.org/projects/wp-plugins/sac-database-inspector)

### Interested in development?

[Browse the code](https://plugins.trac.wordpress.org/browser/sac-database-inspector/),
check out the [SVN repository](https://plugins.svn.wordpress.org/sac-database-inspector/),
or subscribe to the [development log](https://plugins.trac.wordpress.org/log/sac-database-inspector/)
by [RSS](https://plugins.trac.wordpress.org/log/sac-database-inspector/?limit=100&mode=stop_on_copy&format=rss).

## Changelog

#### 1.1.1

 * Fixed PHP warnings and deprecations from information_schema table metadata on
   MySQL 8 hosts.
 * Fixed AI interpretation failing with a 400 error on providers that reject an 
   explicit temperature.
 * Fixed CSV export deprecation on PHP 8.4 and made output RFC 4180 compliant.
 * Collected the diagnostic report once per request instead of re-scanning per section.
 * Refreshed the admin interface with a cleaner, more professional design.
 * Excluded development files from the production package.

#### 1.1.0

 * Added modular report, ownership, cleanup, snapshot, export, and AI services.
 * Added normalized deterministic diagnostic reports and explainable health categories.
 * Added conservative plugin database footprint estimates and owner status distinctions.
 * Added read-only ghost data findings with confidence and reasons.
 * Added paginated/searchable autoload inspection, protected options, and redacted
   previews.
 * Added bounded cleanup, local safety snapshots, and supported restoration.
 * Added redacted JSON, CSV, and HTML exports.
 * Added optional provider-neutral WordPress 7.0 AI Client explanations.
 * Preserved existing cleanup identifiers, hooks, AJAX names, read-only mode, and
   flat statistics response.
 * Added PHPUnit, WordPress Coding Standards, PHP compatibility, and production-
   build configuration.
 * Removed no functionality and added no telemetry, paid features, provider SDKs,
   or automatic external calls.

#### 1.0.0

 * Stable release with the original inspection dashboard and manual cleanup actions.

#### 0.2.0

 * Added contextual source identification to the autoload table.

#### 0.1.1

 * Naming and compliance updates.

#### 0.1.0

 * Initial database inspection dashboard, manual cleanup, read-only mode, and multisite
   support.

## Meta

 *  Version **1.1.1**
 *  Last updated **3 weeks ago**
 *  Active installations **10+**
 *  WordPress version ** 7.0 or higher **
 *  Tested up to **7.0.4**
 *  PHP version ** 7.4 or higher **
 *  Language
 * [English (US)](https://wordpress.org/plugins/sac-database-inspector/)
 * Tags
 * [autoload](https://kal.wordpress.org/plugins/tags/autoload/)[database](https://kal.wordpress.org/plugins/tags/database/)
   [database cleaner](https://kal.wordpress.org/plugins/tags/database-cleaner/)[diagnostics](https://kal.wordpress.org/plugins/tags/diagnostics/)
   [performance](https://kal.wordpress.org/plugins/tags/performance/)
 *  [Advanced View](https://kal.wordpress.org/plugins/sac-database-inspector/advanced/)

## Ratings

 5 out of 5 stars.

 *  [  1 5-star review     ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/?filter=5)
 *  [  0 4-star reviews     ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/?filter=4)
 *  [  0 3-star reviews     ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/?filter=3)
 *  [  0 2-star reviews     ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/?filter=2)
 *  [  0 1-star reviews     ](https://wordpress.org/support/plugin/sac-database-inspector/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/sac-database-inspector/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/sac-database-inspector/reviews/)

## Contributors

 *   [ Ask Adam ](https://profiles.wordpress.org/jackofall1232/)

## Support

Got something to say? Need help?

 [View support forum](https://wordpress.org/support/plugin/sac-database-inspector/)