Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance vs Better Find and Replace – AI-Powered Suggestions

Advanced Database Cleaner is a complete WordPress optimization plugin that helps you clean up database clutter and optimize database performance by removing unused data such as old revisions, auto drafts, spam comments, expired transients, unused post meta, duplicated post meta, unused user meta, etc. It is designed to help you improve website speed by reducing database bloat and ensuring a lean, efficient WordPress installation. It also provides detailed previews, powerful filters, and automation tools to safely control what gets cleaned. With the ✨Premium version✨, you can unlock even more advanced features, such as detecting and cleaning orphaned options, orphaned tables, orphaned post meta, orphaned user meta, orphaned transients, and orphaned cron jobs. It also gives you clear insights into how your database evolves over time through built-in analytics, lets you monitor plugin and theme activity to better understand when new data is created or when leftovers appear, and much more. Why use Advanced Database Cleaner❓ 👉 Get a clear overview: see how many tables, options, transients, cron jobs, metadata… records you have, and identify which are unused or orphaned. 👉 Save time: configure what to clean, how far back to keep data, and how often to run automations. The plugin will then handle recurring cleanups for you. 👉 Save space and improve performance: removing unnecessary data reduces database size, makes backups faster, and can improve query performance, especially on busy or older sites. ✅ Main Features Delete old revisions of posts and pages Delete old auto-drafts Delete trashed posts Delete pending comments Delete spam comments Delete trashed comments Delete pingbacks Delete trackbacks Delete unused post meta Delete unused comment meta Delete unused user meta Delete unused term meta Delete unused relationships Delete expired transients Delete duplicated post meta Delete duplicated user meta Delete duplicated comment meta Delete duplicated term meta Delete oEmbed caches Display the database size that will be freed before cleaning for each item type, and the total size to be freed Display and preview items to clean before performing a database cleanup to ensure safety Sorting capability in cleanup preview tables (by name, date, size, site id, etc.) View options value content in original or formatted mode for serialized or JSON structures (and other items types as well). Keep last X days of data: clean only data older than the number of days you specify ✅ Automation Schedule database cleanup to run automatically Create scheduled cleanup tasks and specify which items each task should clean Schedule database optimization and/or repair to run automatically Execute scheduled tasks based on several frequencies: once, hourly, twice a day, daily, weekly, or monthly Specify the “keep last X days” rule for each item type in a scheduled task Pause/Resume scheduled tasks whenever needed Create as many scheduled cleanup tasks as needed and specify what each task should clean ✅ Tables Display the list of database tables with information such as number of rows, table size, engine, etc. Sort tables by any column such as table name or table size Display table contents along with their column structure, indexes, status, and more Detect and filter tables with invalid prefixes (tables that do not belong to the current WordPress installation), this can be enabled or disabled from the settings page Optimize database tables (the plugin notifies you when tables require optimization) Repair corrupted or damaged database tables (the plugin notifies you when tables are corrupted) Convert tables to InnoDB for better performance Empty rows of database tables Clean and delete database tables ✅ Options Display the options list with information such as option name, option value, option size, and autoload status Sort options by any column such as option name or option size View option value content in original or formatted mode for serialized or JSON structures. Notify you if autoloaded options are large and help reduce autoload size for better performance Detect large options that may slow down your website Set option autoload to yes/no Clean and delete options ✅ Cron Jobs Display the list of active cron jobs (scheduled tasks) with information such as arguments, action, next run, schedule, etc. Sort cron jobs by any column such as action name or next run time Detect cron jobs with no valid actions Clean and delete scheduled tasks ✅ Post Meta Display the post meta list with information such as meta key, value, size, associated post ID, etc. Sort post meta by any column such as meta key, meta size, or post ID View post meta value content in original or formatted mode for serialized or JSON structures. Detect unused post meta (meta not associated with any existing posts) Detect duplicated post meta (same meta key/value for the same post ID) Clean and delete post meta ✅ Post types Display post types with information such as name, post count, visibility (public or non-public), etc. Sort post types by columns such as name, post count, visibility, etc. View posts corresponding to each post type, along with their details Detect unused or orphaned post types Clean orphaned post types ✅ User Meta Display the user meta list with information such as meta key, value, size, associated user ID, etc. Sort user meta by any column such as meta key, meta size, or user ID View user meta value content in original or formatted mode for serialized or JSON structures. Detect unused user meta (meta not associated with any existing users) Detect duplicated user meta (same meta key/value for the same user ID) Clean and delete user meta ✅ Transients Display the list of transients with information such as name, value, size, and expiration time Sort transients by any column such as transient name, size, or expiration time View transient value content in original or formatted mode for serialized or JSON structures. Clean expired transients Detect large transients that may slow down your website Clean and delete transients Set transient autoload to yes/no ✅ Other Tools Display current database size Logging system for easy troubleshooting Access the WordPress debug log directly from the plugin interface Multisite support (network-wide database cleanup and optimization from the main site) Modern, responsive interface powered by React for a smooth experience without page reloads Show/hide plugin tabs for better usability ⚡ Premium Features ⚡ Official website Unlock the full power of database cleanup and optimization with Advanced Database Cleaner Premium – packed with smart features that take accuracy, speed, and cleanup control to the next level. ✅ Remote SmartScan Local scan + Remote SmartScan technology to accurately detect the true owners of tables, options, post meta, user meta, transients, and cron jobs Cloud-enhanced ownership detection using a large and continuously improving remote database Improved accuracy for identifying orphaned items left by deleted plugins and themes Ability to edit ownership of any item and correct misidentified owners Ability to send ownership corrections to improve the global detection database Enhanced “Belongs to” ownership column everywhere using cloud data + local data Display multiple possible owners for each item when applicable Display owner status (active, inactive, not installed) to simplify cleanup decisions Check your remote scan credits to monitor usage ✅ Action Scheduler Cleanup Clean Action Scheduler Completed actions Clean Action Scheduler Failed actions Clean Action Scheduler Canceled actions Clean Action Scheduler Completed logs Clean Action Scheduler Failed logs Clean Action Scheduler Canceled logs Clean Action Scheduler Orphan logs ✅ General Cleanup Enhancements Keep last X items feature in General Cleanup Keep last X items per parent (e.g., per post) Keep last X items globally (e.g., keep the last 10 pingbacks) Combine Keep Last X Days with Keep Last X Items for advanced cleanup safety ✅ Advanced Filters Advanced filters in all modules (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Filter by size, value content, autoload, expiration, metadata type, and more Filter by plugin owner, theme owner, WordPress core, orphan, or unknown Filter by multisite site ID with full per-site visibility Filter by action frequency and interval in cron jobs Filter by duplicated, unused, large, not-yet-scanned, or expired items ✅ Advanced Automation Unlimited automation tasks (Free version is limited to 5 tasks) Create any number of scheduled cleanup tasks with different configurations Create scheduled optimization and repair tasks Use Keep Last X Items and Keep Last X Days inside scheduled tasks Run automation tasks hourly, twice daily, daily, weekly, monthly, or at any supported frequency Pause/resume/delete automation tasks without losing settings Per-task automation event logging showing executed actions, number of items cleaned, execution timestamps, and detailed logs ✅ Database Analytics Daily tracking of total database size and number of tables Daily and monthly charts showing database growth trends Raw data tab with all recorded measurements Table-level analytics showing size growth, rows growth, and daily changes Ability to detect abnormal table growth caused by logs, caches, or runaway actions Multi-table selection and search for analyzing multiple tables at once ✅ Addons Activity Automatically track plugin activations, deactivations, and uninstalls Automatically track theme switches and uninstalls Display activity in a color-coded timeline for better readability All timestamps shown in your local timezone Multisite support (activity recorded on the main site) ✅ Full Multisite Support Clean any site or all sites Filter items by site ID in every module (Tables, Options, Post Meta, User Meta, Transients, Cron Jobs) Display which site each item belongs to Run automation tasks across the entire network

Smart Search, Replace & Media Tool (with AI) for WordPress Better Find and Replace lets you easily search and replace text, HTML, links and media across your entire WordPress site — no coding needed. Perfect for database cleanup, content updates or post-migration edits. Replace text or media in bulk with full support for serialized data, custom tables and dry-run previews. AI-powered suggestions help you rewrite or improve content instantly, making your edits smarter and faster. Easily find and replace images using drag-and-drop and auto-regenerate thumbnails. You can also update or add alt text, captions and metadata with the suggestion of AI for better SEO. Want to change content without editing your database? Use real-time masking to update text, links or HTML before the page loads — instantly and safely. Built for developers, agencies and site owners, individual ( everyone ) who want fast, accurate control over their content management system — all in one clean, intuitive interface. Key Features AI-Powered Suggestions – Use artificial intelligence (AI) to get smart replacement suggestions, enhancing accuracy and efficiency. Easy to Use – Clean, user-friendly interface designed for effortless navigation and configuration. Search and Replace Text – Find and replace any text across your site, whether in static or dynamic content. Search and Replace Ajax/jQuery Content – Works seamlessly with content loaded via Ajax or jQuery on the frontend. Find and Replace URLs – Quickly search and replace outdated or incorrect URLs throughout your website. Replace Images and Attachment URLs – Replace image links and attachment URLs site-wide with precision. Word Masking – Mask specific words site-wide using flexible find and replace rules. Temporary Find-Replace Rules – Create live, non-permanent replacements without altering your database. Edit Footer Credit – Remove or update footer text without modifying HTML or database content. HTML Code Replacement – Replace anything within HTML code blocks, tags, or content. Real-Time Image Replacement – Replace images instantly during page rendering for dynamic updates. Comment Word Filtering – Automatically find and replace inappropriate words in user-submitted comments. Language Replacement – Change words or phrases from one language to another across your site. RegEx Supported – Use regular expressions for complex and pattern-based search and replace operations. HTML Tag & Attribute Replacement – Locate and replace specific HTML tags or attributes throughout your content. Lightning Fast Database Replace – High-speed search and replace operations in posts, postmeta, options, and more. Table Selection – Choose specific database tables for targeted replacements. Dry Run Preview – See a preview of all replacements before applying them to the database. Whole Word Match – Replace only exact word matches in the database to avoid partial replacements. Serialized Data Support – Safely search and replace serialized data without breaking structure or integrity. Remove Serialized Items – Delete specific items from serialized arrays in the database. Role-Based Access – Assign plugin management to specific user roles for better control. Gutenberg and Page Builder Compatible – Fully supports real-time replacements inside block editors and builders. Targeted DB Replacement – Refine search by limiting database replacements to post titles, content, or excerpts. How to replace in DB? Start by generating a report: Select the Dry Run option located at the bottom of the settings section. Review the report: A modal window will appear, showing the specific rows and data that will be affected by the replacement. Proceed if satisfied: If the preview looks accurate and matches what you intend to replace, simply close the report window, uncheck Dry Run, and click the Find & Replace button. ⚠️ Attention: Please carefully review the dry run report before making any changes. Once replacements are applied to the database, they cannot be undone. The PRO version includes an undo feature, but it must be installed before performing the replacement. ✅ Important Tip: Always run a dry report first to ensure your search term and replacement are correct. If anything looks off, adjust the keyword and repeat the process until the preview shows the desired results. Pro Features Database Replacement Features: Powerful search and replace in database Ultimate solution for search & replace in serialized data & remove item Automatic backup of the search and replacement data Ultimate easy solution for restore data what you have replaced by mistake Ability to check & replace each item separately which going to be replaced in the database Bulk Replacement on report’s page, generate by dry run option All tables in database Search and replace Unicode Characters UTF-8 ( e.g: U+0026, REČA ) in Database Additional filtering options in default / custom URLs Filter new comments before inserting into Database Filter new post before inserting into Database (Good for auto post generation website) Special feature to search and replace in large table Real-Time Rendering Features: RegEx supported Advance Regex – Powerful code blocks / multi-lines find and replace in real-time (masking) rendering Advance Regex – Any (CSS / JS / HTML) code Block find and replacement in real-time (masking) rendering Masking on Shortcodes Advance filtering options :- Case insensitive – search and replace case sensitive or insensitive Whole Word – search and replace whole word Unicode – search and replace Unicode Characters Skip posts / page / custom taxonomies etc.. urls Skip CSS – External, Internal, Inline Skip JavaScript – External, Internal Skip pages – if you don’t want to apply rules on any specific page Skip posts – if you don’t want to apply rules on any specific posts Bypass rule – keep texts unchanged on specific area with special pattern Bypass rule – keep base links / urls ( post, pages, custom taxonomies etc..) unchanged where find word exists in that URL. Advance Regex – Code blocks / multi lines find and replacement example – (Real-time Rendering) Find code block and replace with your own or keep blank *replacement field to remove code block. Let consider the following CSS code block for replace. Put following code block in find field* html { margin-top: 32px !important; } * html body { margin-top: 32px !important; } @media screen and ( max-width: 782px ) { html { margin-top: 46px !important; } * html body { margin-top: 46px !important; } } Then put following code block in *Replace field to replace the above code block* .site-title a{color: red;} Join the elite web professionals who enjoy Better Find And Replace Pro! ➡️ Basic Documentation To Get Started Setup Video Guide – How to install and setup search and replace rules 👉 Real-time search and replace General options for filtering Live Demo & Documentation Advance options for filtering Live Demo & Documentation 👉 Search and replace in Database Live Demo & Documentation Find and replace in Database tables Live Demo & Documentation Find and replace in Database URLs Live Demo & Documentation Forum and Feature Request For Quick Support, feature request and bug reporting Visit our website To Get Instant Support For more dedicated support or feature request write to us at [email protected] or create a ticket Support Center Visit our forum to share your experience or request features Visit our forum As it’s open source, check our github development Status Check development status or issues in github.com/CodeSolz/real-time-auto-find-and-replace