SAC Database Inspector
| 开发者 | jackofall1232 |
|---|---|
| 更新时间 | 2026年9月15日 05:40 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPL-2.0-or-later |
| 版权网址: | 版权信息 |
详情介绍:
- Clean, card-based interface designed for quick scanning
- Severity-colored health score with a plain-language rating
- Refined data tables, stat tiles, and status badges
- Fully responsive layout that works on small screens
- No external fonts, scripts, or tracking of any kind
- 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_schemais restricted - Object-cache status and bounded maintenance counts
- 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
- 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
- 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
- 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
安装:
- Upload the plugin folder to
/wp-content/plugins/, or install it through the Plugins screen. - Activate SAC Database Inspector.
- Open Tools → DB Inspector.
屏幕截图:
常见问题:
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.
Why is the AI interpretation unavailable on my site?
The optional AI features use the WordPress 7.0 AI Client. WordPress needs a text-generation connector configured under Settings → Connectors; the Reports & AI tab links there directly. Every deterministic diagnostic works without it.
Can I disable every maintenance action?
Yes. Add add_filter( 'wpdi_read_only', '__return_true' ); in site-specific code.
更新日志:
- Added new WordPress.org screenshots showing the redesigned dashboard.
- Added a direct Settings → Connectors link where AI interpretation is configured, and clearer guidance when no connector is set up.
- Added a single, dismissible review invitation shown only on the plugin's own page after the first successful maintenance action. It never repeats once dismissed and sends no data anywhere.
- Refreshed the plugin description and FAQ. No diagnostic behavior changed.
- 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.
- 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.
- Stable release with the original inspection dashboard and manual cleanup actions.
- Added contextual source identification to the autoload table.
- Naming and compliance updates.
- Initial database inspection dashboard, manual cleanup, read-only mode, and multisite support.