Turquoise abstract wavy W logo on a black background
Turquoise abstract wavy W logo on a black background
White WP PowerSuite logo on a black background
White WP PowerSuite logo on a black background

Summarize with AI:

On This Page
Last updated: 20/08/2026

Database Cleanup

Ownership-aware cleanup for revisions, transients, and orphans. Browse tables and options safely—templates, builder data, and active plugin tables stay protected.

Overview

Over time, a WordPress database can collect revisions, drafts, expired transients, spam comments, orphaned metadata, leftover plugin data, and other records that are no longer useful. Finding what can safely be removed becomes increasingly difficult as a site grows.

Database Cleanup gives you a dedicated workspace to scan, review, and clean WordPress database bloat. It goes beyond basic cleanup by identifying ownership across plugins, themes, and WordPress itself, while protecting core data, installed-plugin tables, builder content, templates, and other important records.

Database Cleanup is available as a Pro module in WP PowerSuite.

Solid black square
Solid black square
Who is this for?
  • Site owners dealing with years of accumulated WordPress database bloat
  • Agencies maintaining and optimizing client websites
  • WooCommerce sites with growing sessions and Action Scheduler data
  • Developers who need deeper control over tables, options, metadata, transients, and cron
  • Administrators who want safer database cleanup with ownership and protection checks

Features

Scan Before You Clean
Run a database scan to see its current size, removable items and estimated space, revision count, autoload size, spam comments, and cleanup categories that need attention.
Clean Revisions, Drafts & Trashed Content
Remove old post revisions while keeping your preferred number of recent versions, clean auto-drafts, and optionally review old drafts and trashed posts before removing them.
Remove Expired Transients
Clean expired transients and orphaned transient timeout records while leaving active transients intact.
Find Orphaned Database Data
Detect orphaned post, comment, user, and term metadata, along with orphaned term relationships and other records that no longer have a valid parent.
Ownership-Aware Database Cleanup
WP PowerSuite identifies whether database items belong to WordPress core, installed plugins, themes, or leftover components, helping distinguish genuine leftovers from data that is still in use.
Database Table Manager
Browse tables with information such as size, overhead, engine, and ownership. Optimize, repair, or convert supported tables to InnoDB, and identify leftover tables from plugins that are no longer installed.
Options Explorer
Inspect WordPress options, review their values and ownership, control autoload behavior, and remove orphaned options while keeping protected core options out of destructive cleanup actions.
Action Scheduler Cleanup
Clean completed or canceled Action Scheduler records and old logs, with more sensitive pending and failed data kept behind advanced cleanup controls.
Scheduled Database Cleanup
Automatically run selected safe cleanup tasks hourly, twice daily, daily, weekly, or monthly. Review-sensitive and advanced tasks are deliberately excluded from unattended cleanup.
Cleanup History
Keep a record of manual and scheduled cleanup runs, including what was cleaned during each operation.

Clean More Than the Usual WordPress Clutter

Basic database optimization tools often stop at revisions, spam comments, and expired transients.
Database Cleanup goes deeper.
Along with routine content cleanup, you can inspect database tables, options, post meta, user meta, comment meta, term meta, transients, cron events, post types, WooCommerce sessions, and Action Scheduler data from dedicated browsers
That makes the module useful both for routine maintenance and for investigating why a database has become unusually large.

Know What Data Belongs To

Deleting an unfamiliar database table or option based only on its name can be risky.
Database Cleanup includes an ownership-aware system designed to associate database data with WordPress core, plugins, and themes.
This helps you distinguish between something that appears unused and data belonging to software that is still installed.
Tables belonging to WordPress core or currently installed plugins are protected from orphan-table deletion. Important post types, templates, builder libraries, core options, and protected metadata are also kept away from destructive bulk actions.
For unusual setups, ownership information can be reviewed and manually adjusted when necessary.

Browse Before You Delete

For deeper maintenance, Database Cleanup provides dedicated entity browsers instead of treating your database as one large cleanup button.
You can inspect tables and their sizes, look through options, find expired or large transients, investigate orphaned metadata, and identify cron hooks without registered callbacks.
Filters such as Belongs To help narrow large datasets and understand where records originated.
This makes it easier to investigate database growth before deciding what should actually be removed.

Clean Large Databases Without One Huge Request

Database cleanup can involve thousands of records, particularly on established WooCommerce, membership, publishing, and high-activity sites.
WP PowerSuite processes manual scans and cleanup operations in AJAX batches rather than trying to handle everything in one long-running request.
Progress can be processed incrementally, and manual operations can be aborted when needed.

Automate Routine Cleanup Without Automating Risky Tasks

Database Cleanup can handle recurring maintenance automatically while keeping higher-risk operations under manual control.
Choose from hourly, twice-daily, daily, weekly, or monthly schedules and select which Safe cleanup tasks should run.
Review and Advanced tasks cannot be added to unattended scheduled cleanup.
You can also receive an email report when a scheduled cleanup actually removes database records.

Use Cases

  • Clean Up an Older WordPress Site
    Remove accumulated revisions, drafts, spam, expired transients, orphaned metadata, and other unnecessary records left behind over years of use.
  • Investigate a Large Database
    Browse tables, options, metadata, transients, and other database entities to identify where unnecessary database growth is coming from.
  • Clean Up After Removing Plugins
    Identify orphaned options and leftover database tables associated with plugins that are no longer installed while protecting data belonging to installed plugins.
  • Automate Routine Database Maintenance
    Schedule safe cleanup tasks while keeping review-sensitive and advanced operations under manual administrator control.

Frequently Asked Questions

Related Modules

One-click removal of inactive plugins and themes to declutter and harden the install.
Disabled
Build contact and lead forms manually or with AI assistance. Uploads, notifications, entries, and spam protection—no external form SaaS.
Disabled
At-a-glance site health, environment, updates, and storage on the dashboard—expand what you need.
Disabled
Managed snippets for head, body, footer, or shortcodes—HTML, CSS, JS, and PHP.
Disabled
Pause automatic updates for core, plugins, themes, or translations when you stage releases yourself. Long-term blocking can leave security gaps—use with a...
Disabled
Edit wp-config.php in the admin with backup-before-save safeguards.
Disabled
Download ZIP link on each plugin for backup or migration without FTP.
Disabled
Inject header, body, or footer snippets site-wide—analytics, pixels, chat, meta tags—without touching the theme.
Disabled
Coming-soon or maintenance landing pages; staff and allowed roles bypass to the real site.
Disabled
Adds Alpine.js on the front end and/or admin for small reactive UI without a heavy framework.
Disabled