See what fills your database and clean out expired cached values
Find the biggest tables in your WordPress database, count what is in them and delete expired cached values that plugins left behind. Nothing visitors see is lost.
- Difficulty
- Intermediate
- Time
- about 15 min
My WordPress database seems large. Show me the biggest tables with their row counts and sizes, and tell me in plain words what each holds. Count the [things to count, e.g. post revisions, spam comments and orphaned post meta] with read-only queries. Then delete every expired cached value, and list any large cached values from plugins I should ask about. Tell me what you could not clean and how it is usually cleaned.
Already connected?
If SAR is already in your AI app, this is enough:
Show me what fills my database and delete expired cached values.
What happens
- The AI app lists the database tables with row counts and sizes.
- It runs read-only queries to count what you asked about; queries cannot change anything, and secrets are never returned.
- It lists the cached values plugins keep (transients) by name, size and expiry, never their contents.
- It deletes the expired ones; plugins rebuild what they cache, so this needs no approval and nothing visitors see is lost.
- It tells you what SAR does not delete, such as old revisions, and how that is usually done in wp-admin or with a cleanup plugin.
Approvals involved
Nothing here changes your site: no approval needed.
wordpress_list_db_tablesDatabase tablesNonewordpress_list_transientsCached valuesNonewordpress_query_databaseQuery the databaseNonewordpress_delete_transientsDelete cached valuesNone
What you get
A clear picture of your database, expired leftovers gone, and a short list of what else is worth cleaning.
Related recipes
- Maintenance · about 20 minFind what makes wp-admin slow, from the databaseLook for the usual database causes of a slow dashboard, such as oversized settings loaded on every page, with read-only queries. Nothing is changed.
- Maintenance · about 10 minRun a weekly check-up of your WordPress siteOnce a week, ask for one short list: what is wrong on the site, which updates are waiting, which tasks are overdue and how fast the home page loads.
- Maintenance · about 15 minUpdate plugins one at a time, with a backup checked firstSee which plugin updates are waiting, check how old the last backup is, then update one plugin at a time with your password and a check after each.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.