gerrygooner

This WordPress plugin will cleanup your WordPress database, performing the following actions:
<ul>
<li>Remove all post revisions.</li>
<li>Remove all spam comments.</li>
<li>Remove all unapproved comments.</li>
<li>Remove all unused tags.</li>
<li>Remove all unused post meta.</li>
<li>Optimize MySQL tables by removing all unused table space.</li>
</ul>
Based on WP-Cleanup by JortK, this plugin replaces usage of mysql_query() that was deprecated in PHP 5.5 with WP_Query functions .

WP-CleanDB

Freemius

WPMagic

Automatically delete old or outdated WordPress posts safely — keep your site clean, fast, and relevant. 
This plugin lets you automatically remove outdated content from your WordPress site with ease. 
Schedule deletions, filter by category, tag, post type, or status, and optionally redirect deleted posts to relevant pages to preserve SEO. 
Perfect for bloggers, news sites, e-commerce stores, and anyone who wants a clean, optimized site without manual cleanup.
<h3>Features</h3>
<ul>
<li>🕒 Automatic Deletion – Schedule post deletions automatically — no manual work needed. </li>
<li>🗂️ Flexible Filtering – Choose which posts to delete based on date, category, tag, post type, authors, or status.</li>
<li>🚫 Exclude Important Posts – Protect specific posts from deletion. </li>
<li>🔁 SEO-Friendly Redirects – Automatically redirect deleted posts to their closest match or a custom URL (optional). </li>
<li>💾 Safe & Controlled – Logs last deletion for easy review, so you always know what happened.</li>
<li>🧰 Supports Custom Post Types – Works with any posts type.</li>
<li>🔄 “Set It and Forget It” Automation – Once configured, it keeps your site clean automatically. </li>
<li>💡 Lightweight & Fast – No bloat, minimal database load, and compatible with all major themes and plugins. </li>
<li>❌ Delete the post permanently (PRO version).</li>
<li>❌ Delete post attachments 📎 🏞️ when the post is deleted (PRO version).</li>
</ul>
<h3>Why You Might Need This Plugin</h3>
Keeping your WordPress site clean and relevant is important — but deleting old content manually takes time. 
This plugin helps you automatically remove outdated posts, drafts, or custom content types on a schedule, based on your rules.
You might need this plugin if:
<ul>
<li>📰 You run a blog with time-sensitive posts (e.g., events, announcements, deals) that should disappear after a certain date. </li>
<li>🏪 You manage a WooCommerce store and want to automatically remove expired or seasonal products. </li>
<li>🎓 You run a membership, e-learning, or event site with temporary content that should be cleaned up regularly. </li>
<li>🗞️ You operate a news or magazine site and want to auto-delete posts older than 30, 60, or 90 days to keep your archive light. </li>
<li>⚙️ You’re a developer or site maintainer managing multiple WordPress installations and need a reliable cleanup automation tool. </li>
<li>🧠 You care about SEO and performance, and want to remove outdated or low-value content safely — optionally redirecting deleted posts to newer ones. </li>
<li>✅ You simply want a “set it and forget it” way to keep your WordPress dashboard clean and your site running fast.</li>
</ul>
<h3>Supported languages:</h3>
<ul>
<li>English</li>
<li>Deutsch</li>
<li>Nederlands</li>
<li>Français</li>
<li>Italiana</li>
<li>Norwegian</li>
<li>Hindi</li>
<li>Bengali</li>
</ul>
If you want, you can help <a href="https://translate.wordpress.org/projects/wp-plugins/delete-old-posts-programmatically/" rel="nofollow ugc">translate</a> the “Auto Post Cleaner” plugin into another language. Many thanks! 
Please note that there are no guarantees that translations from the original English are accurate.

Auto Post Cleaner

Cannot delete pages (only posts).

Keep your website clean by automatically deleting posts using a wide range of powerful filters.

WP-CleanDB vs Auto Post Cleaner