CliniQ DB

Description

CliniQ DB scans your WordPress database and presents a plain-English health report — including a letter grade, an issue list, and exactly what to do about each problem.

Overview tab

• Letter grade (A–F) with a 0–100 score
• Table count, total DB size, table overhead
• Autoloaded options size, revision count, transient count
• MySQL version, charset, WP DB version
• Spam/trash comment count, orphaned postmeta count

Tables tab

• Full list of all database tables sorted by size, overhead, or row count
• Per-table: data size, index size, overhead, engine, collation
• One-click Optimize button for tables with overhead

Autoloaded Options tab

• Lists the top 150 autoloaded options by size
• Per-option: name, size in bytes, percentage of total, value preview
• Highlights options over 10 KB in amber, over 50 KB in red

Cleanup tab

• Expired transients
• Post revisions
• Auto-draft posts
• Spam comments
• Trashed comments
• Orphaned postmeta
• Orphaned commentmeta

Each cleanup card shows the row count before cleaning and a confirmation message after. All operations are permanent — back up your database first.

Source Files & Build Process

The compiled JavaScript at assets/build/index.js is human-readable ES5 code that uses WordPress’s bundled wp.element (React) directly — no minification or transpilation is applied. The JSX source components in assets/src/ are included for reference.

To compile from JSX source:

1. Run npm install in the plugin folder.
2. Run npm run build.

Build requirements: Node 18+, @wordpress/scripts ^26.