SweepPress is an easy-to-use plugin for WordPress, built around 42 different Sweepers for database cleanup (the Pro version has 45), support for WP-CLI, and WP REST API to perform the cleanup operations.
Modes of sweeping
Auto Sweep: available on the dashboard, running many (not all) sweepers without user input.
Quick Sweep: available on the dashboard, allowing the sweepers to be selected.
Full Sweep: available on an own panel, with detailed information about sweepers and no limit run.
All sweepers use optimized SQL queries to find the data for removal, and the removal is also done using SQL queries. This is the fastest and most efficient way for data removal, allowing for the quick removal of a large amount of data.
Quick Video Overview
List of Sweepers
Posts: Auto Drafts
Posts: Spam Content
Posts: Trashed Content
Posts: Posts Revisions
Posts: Posts Orphaned Revisions
Posts: Draft Posts Revisions (v2.1)
Posts: Postmeta Locks
Posts: Postmeta Last Edits
Posts: Postmeta Oembeds
Posts: Postmeta Old Data (v2.1)
Posts: Postmeta Orphans
Comments: Spam Comments
Comments: Trashed Comments
Comments: Unapproved Comments
Comments: Orphaned Comments
Comments: Comments User Agents
Comments: Commentmeta Orphans
Comments: Pingbacks Cleanup
Comments: Trackbacks Cleanup
Comments: Akismet Meta Records (v1.1)
Terms: Terms Orphans
Terms: Termmeta Orphans
Users: Usermeta Orphans
Options: Expired Transients
Options: RSS Feeds
Options: All Transients
Options: CRON Jobs
Options: Unhooked CRON Jobs (v2.4)
Network: Expired Transients
Network: All Transients
Network: Inactive Signups (v2.0)
Database: Optimize Database Tables
Database: Repair Database Tables (v1.6)
ActionScheduler: Log Entries (v2.2)
ActionScheduler: Orphaned Log Entries (v2.2)
ActionScheduler: Failed Actions (v2.2)
ActionScheduler: Completed Actions (v2.2)
ActionScheduler: Canceled Actions (v2.2)
BuddyPress: Activity Meta Orphans (v2.4)
BuddyPress: Groups Meta Orphans (v2.4)
BuddyPress: Messages Meta Orphans (v2.4)
BuddyPress: Notifications Meta Orphans (v2.4)
WP-CLI and WP REST API Support
The plugin registers new CLI commands for running sweep operations from the command line (WP-CLI is required). And the plugin also registers the REST API endpoint for the same purpose to run remote sweep operations (only for the administrator role!). CLI and REST API support can be enabled through plugin settings.
Action Scheduler Support
The plugin can cleanup the ActionScheduler tables. These tables are used by the Action Schedule plugin and components developed for WooCommerce, but used in many other WordPress plugins including WP Rocket and Rank Math. For these sweepers to be visible, at least one plugin using those tables needs to be active.
Special Notice
The plugin will show the backup reminder notice by default (and it can be disabled) on every plugin page. It is essential to understand that once the data is deleted by the plugin, it can’t be restored. So, if you change your mind later, it is important to make the backup before the data removal. The sweepPress plugin is not responsible for any loss of data – make sure to have backups!
SweepPress Lite edition, available on WordPress.org, is a fully functional plugin with no limits to its operations. But, SweepPress Pro contains some additional features not available in the Lite version:
Create and manage Sweeper Jobs: create custom background sweeper jobs to run at a specific date or as a recurring job.
Control and track WordPress CRON jobs: list all the WordPress CRON jobs, track and display the source, and more.
Sweeper Monitor: monitor the website for cleanup daily or weekly, and send notifications when the sweeping limit is reached.
Database Tables: an overview of all tables in the database with source information and various actions for better control.
Sweeper File Log: log every sweeper execution into a log file with all sweeper/removal SQL queries executed by each used sweeper.
GravityForms Support: three additional sweepers to remove all trashed forms, spammed, and trash entries by form.
CLI Command to list CRON jobs: list all registered WP CRON jobs via the command line