1-Click Database & Spam Cleanup Guide

Over time, WordPress databases accumulate thousands of unwanted records: post revisions, auto-drafts, spam comments, trashed items, expired transients, and orphaned postmeta. This bloat slows down database queries and increases backup sizes.

With Digent Smart AI, you don't need heavy database maintenance plugins. You can safely clean your database with a single conversational command.

Safe Dry-Run Mode

Digent Smart AI always supports a --dry-run mode. This allows your AI assistant to calculate exactly how many records can be safely cleared before executing the purge:

Ask your AI:

"Perform a dry-run cleanup of my WordPress database and tell me how many revisions, auto-drafts, spam comments, and expired transients are cleanable."

The AI will invoke cli_db_clean with dry_run: true and return a precise breakdown:

• Revisions: 412
• Auto-drafts: 85
• Spam comments: 1,420
• Expired transients: 320
• Orphaned postmeta: 98

Executing the Safe Cleanup

Once you are satisfied with the dry-run numbers, simply confirm:

"Proceed with the cleanup and optimize all database tables."

The engine will:

1. Delete post revisions and auto-drafts.
2. Purge spam and trash comments.
3. Remove expired transients.
4. Clean orphaned post metadata.
5. Run MySQL OPTIMIZE TABLE on all core WordPress tables to reclaim disk space.