Database Manager

Browse and edit database tables, run SQL, clean revisions, spam, transients and orphaned data, manage autoloaded options, import/export and roll back with snapshots.

Pro Elephanta → Database Manager 2 min read Updated
On this page

The Database Manager lets administrators look after the WordPress database without phpMyAdmin: browse and edit tables, run SQL, clean up clutter, manage autoloaded options, import/export and undo changes with snapshots.

Choose what to clean; each item explains what it removes.

#Overview and tables

See the database size, table count and the largest tables. Open Tables to browse rows, view the structure, edit, insert or delete rows, and search.

#SQL console

Run SQL queries and see the results. Save frequently used queries with a name.

#Cleanup & Optimize

Every cleanup item explains what it removes:

Item What it removes
Post revisions Older revisions (the newest few of every post are kept)
Auto-drafts Empty drafts WordPress creates when you open the editor
Trashed posts & pages / comments Items already in the trash
Spam, pending comments, pingbacks & trackbacks Comment clutter (review pending comments first)
oEmbed cache Cached embed HTML; WordPress rebuilds it on the next view
Orphaned post, comment, user and term meta Data left behind by deleted items
Orphaned term relationships Category/tag links to deleted posts
Duplicate post meta Identical custom fields stored twice (the oldest is kept)
Edit locks Temporary "someone is editing" markers
Expired / all transients Cached values
Unused tags Tags with no posts
WooCommerce Completed scheduled actions and expired sessions

Then optimize tables to reclaim space. Cleanups can be scheduled.

#Options & Autoload

Large autoloaded options slow down every page. This tab shows the biggest options and lets you switch autoload off for options that don't need it.

#Import & Export

Export the database or single tables as SQL, CSV or JSON, and import an .sql file or CSV rows.

#Snapshots

Take a snapshot before risky changes. Elephanta also takes one automatically before actions like replacing rows from a CSV. Restore a snapshot to roll back.

Know what you are changing

Editing rows or running SQL changes your live data directly. Take a snapshot first, and avoid changing tables you don't recognise.