DBDoctor | Database Manager, Cleaner & Backups for WordPress

DBDoctor | Database Manager, Cleaner, Search & Replace and Backups inside wp-admin

DBDoctor gives a WordPress site the database tools it otherwise needs phpMyAdmin and three plugins for: browse and edit tables with secrets masked, run SQL safely, migrate URLs with a search & replace that never breaks serialised data, clean what has piled up, fix autoload bloat, move data in and out in chunks, and keep scheduled backups — on the server or in your S3 bucket.

Key Features

• 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 search; inline edit, insert and delete with confirmation; password hashes, keys, tokens and secret-looking options masked, a logged 15-minute reveal
• SQL console: one statement at a time, read-only by default (SELECT, SHOW, EXPLAIN, DESCRIBE), writes unlocked per session; dangerous statements refused; EXPLAIN, row limit, timing, history, CSV export
• Search & replace that never corrupts serialised data: values are unserialised, replaced and reserialised, JSON handled the same; dry run with per-table counts and samples; guid column excluded; URL migration preset
• Cleaner: revisions beyond the number you keep, auto-drafts, trash, spam, pingbacks, expired transients, orphaned post / comment / user / term meta, expired sessions, oEmbed caches — measured first, removed per category
• Maintenance: OPTIMIZE, REPAIR, CHECK, ANALYZE; MyISAM to InnoDB; collation conversion; autoload audit with the heaviest options and autoload off / on (core options protected)
• Export through mysqldump (credentials in a temporary defaults file) or a PHP writer, gzip, selected tables, one-time download link; SQL import in resumable chunks that ignore upload limits; CSV import with column mapping
• Scheduled backups (hourly, daily, weekly) in a private folder with retention, S3-compatible offload (AWS S3, R2, B2, MinIO, Wasabi), download and one-click restore
• Slow queries from performance_schema, the slow log or SAVEQUERIES, with suggestions: MyISAM tables, collation mismatches, missing primary keys, duplicate indexes, autoload bloat, postmeta growth
• Administrators only, optionally an allow-list of user ids; a full audit log; Site Health check; wp dbdoctor tables|query|replace|clean|optimize|backup|autoload

A Domain Migration in Four Steps

1. Backups › Run now (or rely on the schedule)
2. Search & replace › URL preset: old domain, new domain, Dry run
3. Read the per-table counts and samples; adjust the tables if needed
4. Apply — serialised options, widgets and builder data keep their correct lengths

Installation

1. Download the zip from your Library
2. In wp-admin go to Plugins › Add New › Upload Plugin, choose the zip and activate it
3. A new menu entry appears in the admin sidebar; open it
4. DBDoctor › Settings: choose who may use it and the backup schedule; add S3 credentials if you offload

Requirements

• WordPress 6.0 or newer (tested up to 7.0)
• PHP 8.0 or newer
• MySQL 5.7+ or MariaDB 10.3+
• Optional: mysqldump on the server (a PHP writer is used otherwise)

What You Get

• DBDoctor 1.0.0 for WordPress (dbdoctor-1.0.0.zip)
• Full, readable PHP and JavaScript source, no obfuscation
• Updates for the term of your licence

Works With

Part of the Alpha WordPress line, built with one admin kit; ServerPulse shows the server around the database: ServerPulse, SecureShield, CodeForge, SiteStats, MailDoctor, AlphaLogin.

The screenshots show the plugin on our demo site with sample data.