skills.rest
dr-robert-li
dr-robert-liCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

diagnostic-db-revisions

Analyze WordPress post revision counts and estimate database savings via WP-CLI.

27|1|Updated Feb 16, 2026
Search Tags:#performance#database#optimization#revisions#wordpress#wp-cli
One-click install
npx skills add https://github.com/dr-robert-li/cowork-wordpress-expert --skill diagnostic-db-revisions
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: diagnostic-db-revisions
Source: https://github.com/dr-robert-li/cowork-wordpress-expert/tree/main/skills/diagnostic-db-revisions
Command: npx skills add https://github.com/dr-robert-li/cowork-wordpress-expert --skill diagnostic-db-revisions

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you identify and manage excessive post revision accumulation in your WordPress database, which can lead to bloat, slow queries, and larger backups.

Core Features & Use Cases

  • Revision Count: Analyzes the total number of post revisions stored.
  • Post Type Breakdown: Identifies which post types are generating the most revisions.
  • Configuration Check: Verifies the WP_POST_REVISIONS setting in wp-config.php.
  • Savings Estimation: Estimates database space that can be saved by limiting revisions.
  • Use Case: A site with thousands of revisions across many posts can be slowed down. This skill pinpoints the issue and provides actionable steps to clean up and prevent future bloat.

Quick Start

Analyze the post revision status for the connected WordPress site.

Frequently Asked Questions about diagnostic-db-revisions

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check WordPress post revisions accumulating in my database?▼

To check WordPress post revisions accumulating in your database, the Skill counts total revisions, breaks down counts by parent post type, and computes per-post averages using WP-CLI database queries to pinpoint bloat.

Why does my WordPress database have slow queries and large backups?▼

Slow WordPress queries and large backups often stem from excessive post revision accumulation. Analyzing revision counts by post type and estimating database savings identifies this bloat for cleanup.

How do I verify the WP_POST_REVISIONS setting in wp-config.php?▼

To verify the WP_POST_REVISIONS setting in wp-config.php, the Skill checks the configuration via WP-CLI, dynamically handling all four possible constant values to determine your current revision limit.

Can I estimate database space saved by limiting WordPress post revisions?▼

Yes, you can estimate database space saved by limiting WordPress post revisions. The Skill computes post counts for per-post averages and estimates potential database savings from cleaning up accumulated revisions.

Do I need WP-CLI to analyze WordPress post revision accumulation?▼

Yes, you need WP-CLI to analyze WordPress post revision accumulation. The Skill utilizes WP-CLI for database queries and configuration checks, dynamically retrieving table prefixes to perform the analysis.

Related Skills

Explore More Software Engineering Skills→
dr-robert-lidr-robert-li
27

diagnostic-db-autoload

Measure WordPress wp_options autoload size and list options over 10KB with plugin attribution.

Community
Advanced
dr-robert-lidr-robert-li
27

diagnostic-config-security

Analyze wp-config.php remotely via SSH for critical security misconfigurations.

Community
Advanced
bobmatnycbobmatnyc
68

wordpress-advanced-architecture

Create custom REST API endpoints, WP-CLI commands, and caching strategies for WordPress.

Community
Advanced
WPdoactionWPdoaction
9

wp-performance

Profile WordPress backend performance with WP-CLI and Node.js scripts.

Official
Advanced