{"id":330950,"date":"2026-07-16T22:30:48","date_gmt":"2026-07-16T22:30:48","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/doctor-db\/"},"modified":"2026-07-16T22:32:04","modified_gmt":"2026-07-16T22:32:04","slug":"cliniq-db","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/cliniq-db\/","author":23429449,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0.0","stable_tag":"1.0.0","tested":"7.0.1","requires":"6.3","requires_php":"8.0","requires_plugins":null,"header_name":"CliniQ DB","header_author":"Bilal Mahmood","header_description":"Database health inspector for WordPress \u2014 analyze table sizes, autoloaded option bloat, and safely clean up database waste.","assets_banners_color":"667773","last_updated":"2026-07-16 22:32:04","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/sitecliniq.com\/cliniq-db\/","header_author_uri":"https:\/\/bilalmahmood.dev","rating":0,"author_block_rating":0,"active_installs":0,"downloads":38,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"bilalmahmooddev","date":"2026-07-16 22:32:04"}},"upgrade_notice":{"1.0.0":"<p>Initial release.<\/p>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3610784,"resolution":"128x128","location":"assets","locale":"","width":128,"height":128},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3610784,"resolution":"256x256","location":"assets","locale":"","width":256,"height":256}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3610784,"resolution":"1544x500","location":"assets","locale":"","width":2203,"height":714},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3610784,"resolution":"772x250","location":"assets","locale":"","width":2203,"height":714}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3610784,"resolution":"1","location":"assets","locale":"","width":1216,"height":883},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3610784,"resolution":"2","location":"assets","locale":"","width":1204,"height":847},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3610784,"resolution":"3","location":"assets","locale":"","width":1199,"height":875},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3610784,"resolution":"4","location":"assets","locale":"","width":1216,"height":754}},"screenshots":[]},"plugin_section":[],"plugin_tags":[3786,153,732,3869,247],"plugin_category":[52,54,59],"plugin_contributors":[271956],"plugin_business_model":[],"class_list":["post-330950","plugin","type-plugin","status-publish","hentry","plugin_tags-cleanup","plugin_tags-database","plugin_tags-maintenance","plugin_tags-optimizer","plugin_tags-performance","plugin_category-performance","plugin_category-security-and-spam-protection","plugin_category-utilities-and-tools","plugin_contributors-bilalmahmood","plugin_committers-bilalmahmooddev"],"banners":{"banner":"https:\/\/ps.w.org\/cliniq-db\/assets\/banner-772x250.png?rev=3610784","banner_2x":"https:\/\/ps.w.org\/cliniq-db\/assets\/banner-1544x500.png?rev=3610784","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/cliniq-db\/assets\/icon-128x128.png?rev=3610784","icon_2x":"https:\/\/ps.w.org\/cliniq-db\/assets\/icon-256x256.png?rev=3610784","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/cliniq-db\/assets\/screenshot-1.png?rev=3610784","caption":""},{"src":"https:\/\/ps.w.org\/cliniq-db\/assets\/screenshot-2.png?rev=3610784","caption":""},{"src":"https:\/\/ps.w.org\/cliniq-db\/assets\/screenshot-3.png?rev=3610784","caption":""},{"src":"https:\/\/ps.w.org\/cliniq-db\/assets\/screenshot-4.png?rev=3610784","caption":""}],"raw_content":"<!--section=description-->\n<p>CliniQ DB scans your WordPress database and presents a plain-English health report \u2014 including a letter grade, an issue list, and exactly what to do about each problem.<\/p>\n\n<p><strong>Overview tab<\/strong><\/p>\n\n<ul>\n<li>Letter grade (A\u2013F) with a 0\u2013100 score<\/li>\n<li>Table count, total DB size, table overhead<\/li>\n<li>Autoloaded options size, revision count, transient count<\/li>\n<li>MySQL version, charset, WP DB version<\/li>\n<li>Spam\/trash comment count, orphaned postmeta count<\/li>\n<\/ul>\n\n<p><strong>Tables tab<\/strong><\/p>\n\n<ul>\n<li>Full list of all database tables sorted by size, overhead, or row count<\/li>\n<li>Per-table: data size, index size, overhead, engine, collation<\/li>\n<li>One-click Optimize button for tables with overhead<\/li>\n<\/ul>\n\n<p><strong>Autoloaded Options tab<\/strong><\/p>\n\n<ul>\n<li>Lists the top 150 autoloaded options by size<\/li>\n<li>Per-option: name, size in bytes, percentage of total, value preview<\/li>\n<li>Highlights options over 10 KB in amber, over 50 KB in red<\/li>\n<\/ul>\n\n<p><strong>Cleanup tab<\/strong><\/p>\n\n<ul>\n<li>Expired transients<\/li>\n<li>Post revisions<\/li>\n<li>Auto-draft posts<\/li>\n<li>Spam comments<\/li>\n<li>Trashed comments<\/li>\n<li>Orphaned postmeta<\/li>\n<li>Orphaned commentmeta<\/li>\n<\/ul>\n\n<p>Each cleanup card shows the row count before cleaning and a confirmation message after. All operations are permanent \u2014 back up your database first.<\/p>\n\n<h3>Source Files &amp; Build Process<\/h3>\n\n<p>The compiled JavaScript at <code>assets\/build\/index.js<\/code> is human-readable ES5 code that uses WordPress's bundled <code>wp.element<\/code> (React) directly \u2014 no minification or transpilation is applied. The JSX source components in <code>assets\/src\/<\/code> are included for reference.<\/p>\n\n<p>To compile from JSX source:<\/p>\n\n<ol>\n<li>Run <code>npm install<\/code> in the plugin folder.<\/li>\n<li>Run <code>npm run build<\/code>.<\/li>\n<\/ol>\n\n<p>Build requirements: Node 18+, <code>@wordpress\/scripts<\/code> ^26.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the <code>cliniq-db<\/code> folder to <code>\/wp-content\/plugins\/<\/code>.<\/li>\n<li>Activate the plugin through the <strong>Plugins<\/strong> screen in WordPress.<\/li>\n<li>Navigate to <strong>CliniQ DB<\/strong> in the left admin menu.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"is%20it%20safe%20to%20run%20the%20cleanup%20operations%3F\"><h3>Is it safe to run the cleanup operations?<\/h3><\/dt>\n<dd><p>Yes. Every cleanup task only removes data WordPress no longer uses \u2014 expired transients, deleted-post leftovers, spam and trash. Back up your database before running cleanup on a production site as a precaution.<\/p><\/dd>\n<dt id=\"will%20this%20affect%20my%20site%27s%20front%20end%3F\"><h3>Will this affect my site's front end?<\/h3><\/dt>\n<dd><p>No. CliniQ DB is an admin-only tool. It does not output anything to the front end and does not modify published content.<\/p><\/dd>\n<dt id=\"how%20is%20the%20health%20score%20calculated%3F\"><h3>How is the health score calculated?<\/h3><\/dt>\n<dd><p>Each detected issue reduces the score: critical issues subtract 30 points, warnings subtract 15, and informational issues subtract 3. The letter grade maps to score ranges: A (90\u2013100), B (75\u201389), C (60\u201374), D (45\u201359), F (0\u201344).<\/p><\/dd>\n<dt id=\"does%20this%20work%20with%20multisite%3F\"><h3>Does this work with Multisite?<\/h3><\/dt>\n<dd><p>The plugin scans the current site's database tables. Full Multisite network-wide support is not included in this version.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.0<\/h4>\n\n<p>Initial release.\n* Added translators comments to all i18n strings with placeholders.\n* Fixed: esc_sql() applied to table name in OPTIMIZE TABLE query.\n* Updated Tested up to: 7.0.\n* Added languages\/ directory for future translations.\n* Added uninstall.php to remove plugin data on deletion.<\/p>\n\n<h4>1.0.0<\/h4>\n\n<p>Initial release.<\/p>","raw_excerpt":"WordPress database health inspector \u2014 scan table sizes, autoloaded bloat, and clean up database waste with one click.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/330950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=330950"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/bilalmahmooddev"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=330950"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=330950"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=330950"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=330950"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=330950"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=330950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}