DBDoctor

Browse

• Every table with engine, collation, rows, size and overhead, grouped by plugin prefix; structure with columns, indexes and the CREATE statement
• Rows with paging, sorting, a column filter and a search across text columns; inline edit and delete with confirmation (tables with a primary key); insert a row
• Password hashes, activation keys, tokens and secret-looking option values are masked; a 15-minute "reveal" is logged to the audit

Console

• One statement at a time, read-only by default (SELECT / SHOW / EXPLAIN / DESCRIBE), writes unlocked per session for 30 minutes; the dangerous statements (OUTFILE, LOAD DATA, GRANT, SET GLOBAL, SHUTDOWN…) are refused outright
• EXPLAIN, row limit, timing, per-user history of the last 50 statements, CSV export of a read result

Search & replace

• Serialised PHP data is unserialised, replaced and reserialised (never corrupted lengths); JSON strings are handled the same way; invalid serialised data and incomplete objects are left untouched
• Dry run with per-table counts and sample before/after snippets, then apply; case sensitivity switch; the posts guid column excluded by default; URL migration preset

Cleaner

• Revisions beyond the number you keep, auto-drafts, trashed posts and comments, spam, pingbacks, expired transients, orphaned post / comment / user / term meta and relationships, expired login sessions, oEmbed caches — measured first, removed per category

Maintenance

• OPTIMIZE, REPAIR, CHECK, ANALYZE per table; convert MyISAM to InnoDB; convert a table's collation; autoload audit with the heaviest options and autoload off / on (core options protected)

Export, import, backups

• SQL export through mysqldump (a temporary defaults file, never the password on the command line) or a PHP writer, gzip, selected tables, DROP TABLE option, one-time download link
• SQL import in chunks that ignore PHP upload limits, statement by statement with a resumable offset; CSV import into a table with column mapping
• Scheduled backups (hourly / daily / weekly) in a private folder with retention, optional S3-compatible offload (AWS S3, R2, B2, MinIO, Wasabi), download, one-click restore

Watch

• Slow queries from performance_schema, the server's slow log when readable, or SAVEQUERIES; suggestions: MyISAM tables, collation mismatches, overhead, tables without a primary key or any index, duplicate indexes, autoload bloat, postmeta growth
• Access limited to administrators, optionally to an allow-list of user ids; every action in the audit log; Site Health check; wp dbdoctor tables|query|replace|clean|optimize|backup|autoload