Auto-Drafts and Trash Cleanup Tool
Adds Tools > Clean Up Drafts and Trash with counts of leftover auto-drafts, trashed posts and trashed or spam comments, and a button to remove them all permanently after confirmation.
Snippet Library
Performance snippets for WordPress
Snippets that make WordPress lighter and faster: remove emoji scripts and embeds, control the Heartbeat API, limit revisions and load scripts only where they are needed. For developers and site owners chasing better Core Web Vitals.
Autoloaded Options Inspector
Adds Tools > Autoloaded Options showing the total size of options WordPress loads on every page and the 40 largest ones, with a button to stop autoloading any option that does not need it.
Cache User Counts on Large Sites
Caches the per-role user counts shown on the Users screen and dashboard for 12 hours, avoiding a heavy query on sites with many users.
Clear the Embed (oEmbed) Cache
Run on demand to delete every cached embed (videos, tweets and other oEmbed results) from the database, so they are fetched fresh and stale or broken embeds disappear.
Convert MyISAM Database Tables to InnoDB
Run on demand to convert your site's remaining MyISAM tables to InnoDB, the modern MySQL engine that handles many visitors at once far better and survives crashes more safely.
Database Table Sizes and Optimize Buttons
Adds Tools > Database Tables listing every table of your site with its row count, data and index size and reclaimable space, sorted by size, with an Optimize button for tables that need it.
Delete All Pingbacks and Trackbacks
Run on demand to permanently delete every pingback and trackback stored as a comment, which on older blogs are often thousands of spammy rows nobody reads.
Duplicate Database Queries Report for Administrators
Add ?wpide_queries=1 to any page while logged in as an administrator to see, at the bottom of the page, the queries that ran more than once and the ten slowest queries, with the code that called them.
Empty the Trash After 7 Days
Permanently removes trashed posts, pages and comments after 7 days instead of 30, keeping the database lean.
Keep WooCommerce Logs for 7 Days
Makes WooCommerce delete its log entries (payment gateways, shipping, webhooks and more) after 7 days instead of 30, keeping the log table and folder small.
Limit Post Revisions
Keeps only the five most recent revisions of each post, which stops the database from growing with old copies.
Log Pages That Run Too Many Database Queries
Records front-end URLs that run more database queries than a limit you set, with the query count and load time, and lists the worst offenders under Tools > Heavy Pages.
Old Revisions Cleanup Tool
Adds Tools > Clean Up Revisions, which shows how many post revisions your database holds and deletes revisions older than a chosen number of days after you confirm, always keeping the newest few per post.
Orphaned Metadata Cleanup Tool
Adds Tools > Orphaned Metadata, which counts post, comment, term and user meta rows whose post, comment, term or user no longer exists, and removes them after you confirm.
Remove Duplicate Post Meta Rows
Run on demand to find custom field rows that are exact duplicates (same post, key and value) and keep only one of each, a common side effect of buggy imports and plugins.
Remove Expired Login Sessions From the Database
Once a day, removes expired login sessions that WordPress keeps in user meta until the user logs in again, which on membership sites and shops adds up to a lot of dead data.
Remove Leftover Data From Uninstalled Plugins
Adds Tools > Leftover Plugin Data, where you enter a prefix (such as old_slider_) to see how many options, post meta, user meta and scheduled tasks use it, and delete them after reviewing the counts.
Remove Orphaned Term Relationships and Fix Term Counts
Run on demand to delete category and tag links that point to posts that no longer exist, and then recount how many posts each term has.
Remove the Months Filter From Admin Lists
Drops the "All dates" dropdown from post and media lists, saving a slow query on sites with many thousands of posts or files.
Revision Limits per Post Type
Keeps a different number of revisions for each content type, for example many for posts and none for products.
Server-Timing Header for Administrators
Adds a Server-Timing header with PHP time, database query count and peak memory to pages viewed by administrators, so you can read the numbers in your browser's developer tools Network tab.
Speed Up the Custom Fields Meta Box
Skips the slow database query that fills the Custom Fields key dropdown, which can freeze the classic editor on sites with lots of post meta.
Stop Crawlers Paging Endlessly Through Old Archives
Returns a "not found" page for archive pages beyond page 50 (such as /page/873/) for logged-out visitors, which keeps bots from hammering your database with very slow deep pagination queries.
Stop Yoast SEO Building Indexables on Small or Busy Sites
Turns off Yoast SEO's indexables, the background tables Yoast fills for every post and term, which removes heavy database writes on large sites or cheap hosting.