Drupal Cleanup

Drupal Cleanup finds and removes the leftover data a Drupal site builds up over time: search index rows, moderation states, queue items and custom table rows for content that no longer exists, plus abandoned batch jobs that core never purges.

Core cleans up after itself when content is deleted normally. But real sites also delete content in ways that skip the entity API: migrations, direct SQL, a bulk delete that dies halfway, or old code from before core handled it. What gets left behind never goes away. It bloats tables, slows queries and backups, and can surface dead results. This module finds those rows safely and removes them on a schedule, with a dry run so you can see what it would do first.