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.
Elephanta → Database ManagerTake snapshot#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.
Editing rows or running SQL changes your live data directly. Take a snapshot first, and avoid changing tables you don't recognise.