analyzing-range-distribution
Analyzes CockroachDB range distribution across tables and indexes using SHOW RANGES to identify range count, size patterns, leaseholder placement, and replication health. Use when investigating hotspots, uneven data distribution, range fragmentation, or validating zone configuration effects without DB Console access.
90
88%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Passed
No known issues
Quality
Discovery
100%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This is an excellent skill description that clearly defines specific capabilities (range distribution analysis via SHOW RANGES), includes rich domain-specific trigger terms that a CockroachDB user would naturally use, and provides an explicit 'Use when' clause with concrete scenarios. The description is concise, uses third person voice, and occupies a distinct niche that minimizes conflict risk with other skills.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Lists multiple specific concrete actions: analyzes range distribution, uses SHOW RANGES, identifies range count, size patterns, leaseholder placement, and replication health. These are precise, actionable capabilities. | 3 / 3 |
Completeness | Clearly answers both 'what' (analyzes CockroachDB range distribution using SHOW RANGES to identify range count, size patterns, leaseholder placement, replication health) and 'when' (explicit 'Use when' clause covering hotspots, uneven distribution, range fragmentation, and validating zone configurations without DB Console). | 3 / 3 |
Trigger Term Quality | Includes strong natural keywords users would say: 'CockroachDB', 'range distribution', 'SHOW RANGES', 'hotspots', 'uneven data distribution', 'range fragmentation', 'zone configuration', 'leaseholder', 'replication health', 'DB Console'. Good coverage of terms a DBA would naturally use. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive with a clear niche: CockroachDB range analysis via SHOW RANGES. The combination of database-specific terminology (CockroachDB, leaseholder, zone configuration) and specific tool (SHOW RANGES) makes it very unlikely to conflict with other skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
77%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is a strong, highly actionable skill with excellent executable SQL queries, clear interpretation guidance, and well-structured workflows. Its main weakness is verbosity - the Core Concepts section explains CockroachDB fundamentals Claude likely knows, and the document overall is longer than necessary for a skill that should serve as an overview pointing to references. The safety warnings and production impact table are genuinely valuable additions that justify their token cost.
Suggestions
Move the 'Core Concepts' section to a reference file (e.g., references/concepts.md) and retain only a brief summary with link - Claude understands range-based distribution, Raft, and leaseholders.
Consolidate the 'When to Use This Skill' bullet list since it largely repeats the skill description and could be reduced to 2-3 key trigger conditions.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The skill includes useful domain-specific content but is verbose in places. The 'Core Concepts' section explains range architecture, leaseholders, and fragmentation at a level Claude likely already knows. The 'When to Use This Skill' section largely duplicates the description. However, the safety warnings and interpretation guidance earn their tokens. | 2 / 3 |
Actionability | All six core queries are fully executable SQL with specific column references, JSON extraction syntax, and concrete thresholds for interpretation. Workflows include copy-paste ready examples with remediation commands. The troubleshooting table provides specific fixes for each issue. | 3 / 3 |
Workflow Clarity | Three workflows are clearly sequenced with numbered steps, each referencing specific queries by number. Safety validation is explicit throughout - the DETAILS option warnings serve as validation checkpoints, the production impact table provides clear go/no-go guidance, and the fragmentation workflow includes a critical guardrail (never increase range_max_bytes above 512MB). | 3 / 3 |
Progressive Disclosure | The skill references two bundle files (references/sql-queries.md and references/permissions.md) and links to related skills, which is good structure. However, the Core Concepts section (40+ lines) and the extensive Safety Considerations section could be moved to reference files. The main SKILL.md is quite long for an overview document, with inline content that would benefit from being split out. | 2 / 3 |
Total | 10 / 12 Passed |
Validation
100%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
- Repository
- cockroachlabs/cockroachdb-skills
- Commit
84bc1e4
- Reviewed
Table of Contents
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.