Ask Adam

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.
<h3>Key features:</h3>
<ul>
<li>Database health gauge with clear visual feedback</li>
<li>View total database size (when supported by hosting)</li>
<li>Inspect autoloaded options that load on every page</li>
<li>Identify expired and unused transients</li>
<li>Detect post revisions, auto-drafts, spam, and trash</li>
<li>Find orphaned post meta and comment meta</li>
<li>Flush external object cache (when enabled)</li>
<li>Optional read-only mode via filter for audit-only environments</li>
<li>Multisite-aware and shared-host safe</li>
<li>No frontend impact — admin-only</li>
<li>Contextual source identification for autoloaded options</li>
<li>Full WordPress 7.0 compatibility</li>
</ul>
All cleanup actions require explicit confirmation and are protected by nonces and capability checks.
<h3>Developer Notes</h3>
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.

SAC Database Inspector

Inspect database usage, autoloaded options, transients, and safely clean database clutter from a single admin dashboard.

altaris

Altaris Cleaner is a free WordPress plugin that safely detects and removes unnecessary database leftovers.
When you remove a plugin, WordPress only deletes the files. The database records — options, post meta, and custom tables — remain behind. Altaris Cleaner finds them and cleans them up.
<h4>Features</h4>
<ul>
<li>Orphan Post Meta Scanner — Finds meta records belonging to deleted posts</li>
<li>Orphan Options Scanner — Detects wp_options records not belonging to any active plugin</li>
<li>Transient Cleaner — Removes expired transients with one click</li>
<li>Revision Cleaner — Lists and removes old post revisions (30/60/90 days)</li>
<li>Orphan Table Scanner — Detects custom tables not belonging to any active plugin</li>
<li>Snapshot-Based Confidence System — Rates each orphan table as high/medium/low risk using snapshot comparison</li>
<li>Code Analysis Engine — Scans PHP source code to extract DB fingerprints and compare with actual database</li>
<li>Theme Remnant Scanner — Detects leftover options from removed or switched themes</li>
<li>Custom Prefix Scanner — Scan the database for any user-defined option prefix</li>
<li>Reverse Scan — Finds DB records that exist but are not referenced in any code</li>
<li>Clean Uninstall — Removes DB leftovers when uninstalling a plugin</li>
<li>SQL Export — Download a .sql backup before deleting any records or tables</li>
<li>Snapshot System — Tracks plugin changes to detect leftover data</li>
<li>Simulation Mode — Preview what would be deleted before actually deleting</li>
<li>Undo — Restore deleted options within 24 hours</li>
<li>Action Log — Every cleanup action is logged with timestamp and user</li>
</ul>
<h4>Code Analysis Engine (New in 1.0.0)</h4>
The Code Analysis engine is a unique feature not found in any other WordPress plugin. It scans theme and plugin PHP files to extract database fingerprints — every option, post type, post meta, user meta, transient, widget, custom table, shortcode, cron job, and taxonomy registered in the code.
It then compares these fingerprints with the actual database to identify:
<ul>
<li>In use — Key exists in both code and database</li>
<li>Not in use — Key exists in database but not in code (remnant)</li>
<li>Removed sources — Theme/plugin was deleted but its fingerprint is saved, so remnants can still be detected</li>
</ul>
The engine supports 13 scan categories and detects dynamic keys like <code>get_option("prefix_{$id}")</code>.
<h4>How the Snapshot System Works</h4>
When Altaris Cleaner is activated, it takes a snapshot of all wp_options keys and database tables. When a plugin is later removed, the snapshot comparison reveals exactly which options and tables were left behind.
The Orphan Table Scanner uses this data to show a confidence badge for each table:
<ul>
<li>Snapshot match (red) — Table existed at snapshot time; its plugin may have been removed</li>
<li>New table (yellow) — Table appeared after the snapshot; origin unknown</li>
<li>Unknown (blue) — No snapshot available or no prefix match; inspect carefully</li>
</ul>
<h4>Security</h4>
<ul>
<li>WP core options and tables are never touched</li>
<li>Every action requires nonce + capability check</li>
<li>Mandatory preview before any deletion</li>
<li>SQL backup option before every delete operation</li>
<li>WordPress-style modal confirmation dialogs</li>
<li>Batch processing (max 1000 records per request)</li>
<li>realpath() protection against path traversal</li>
</ul>
<h4>Supported Languages</h4>
Turkish (default), English, German, French, Spanish
<h3>External Services</h3>
This plugin connects to altaris.com.tr to fetch the Altaris plugin list displayed on the Plugins tab. This request is made only when that admin page is visited. No personal user data is transmitted.
Service provider: Altaris 
Website: https://altaris.com.tr 
Terms of Use: https://altaris.com.tr/kullanim-kosullari/ 
Privacy Policy: https://altaris.com.tr/gizlilik-politikasi/

Altaris Cleaner

Clean up orphaned database records left behind by removed plugins. Safe, fast and free.

SAC Database Inspector vs Altaris Cleaner