Guides application developers in designing correct and performant transaction patterns for CockroachDB, covering transaction lifetime, implicit vs explicit transactions, retry handling with exponential backoff, pushing invariants into SQL, selective pessimistic locking, set-based operations, connection pooling, prepared statements, keyset pagination, follower reads, and separating business logic from database logic. Use when building applications on CockroachDB, designing transaction workflows, handling retries, optimizing application-layer database interactions, or configuring connection pools.
85
82%
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 comprehensively lists specific capabilities, includes abundant natural trigger terms, explicitly states both what the skill does and when to use it, and occupies a clearly distinct niche around CockroachDB application transaction patterns. The only minor concern is that the description is quite long, but the density of information is justified by the breadth of topics covered.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | The description lists numerous specific concrete actions and topics: transaction lifetime, implicit vs explicit transactions, retry handling with exponential backoff, pessimistic locking, keyset pagination, follower reads, connection pooling, prepared statements, and more. | 3 / 3 |
Completeness | Clearly answers both 'what' (guides developers in designing transaction patterns covering a detailed list of topics) and 'when' (explicit 'Use when building applications on CockroachDB, designing transaction workflows, handling retries, optimizing application-layer database interactions, or configuring connection pools'). | 3 / 3 |
Trigger Term Quality | Includes strong natural keywords users would say: 'CockroachDB', 'transaction', 'retry handling', 'connection pooling', 'prepared statements', 'pagination', 'exponential backoff', 'pessimistic locking'. These cover a wide range of terms developers would naturally use when seeking help with CockroachDB application patterns. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive due to the specific focus on CockroachDB application-layer transaction patterns. The combination of CockroachDB-specific terminology and application development context creates a clear niche unlikely to conflict with general SQL, other database, or generic transaction skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
64%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is a highly actionable and comprehensive skill with excellent executable code examples covering CockroachDB transaction patterns. Its main weaknesses are length (could be more concise by splitting advanced topics into reference files) and the lack of explicit validation checkpoints in multi-step workflows. The content is well-organized with a useful decision guide and safety considerations section.
Suggestions
Split advanced/detailed sections (connection pooling, key design, monitoring, session guardrails) into separate reference files and keep SKILL.md as a concise overview with links, reducing the main file to ~150 lines.
Add explicit validation checkpoints to multi-step workflows — e.g., after implementing retry logic, verify with 'SELECT crdb_internal.transaction_contention_events' or run a concurrent test to confirm retries work correctly.
Trim the 'When to Use This Skill' and 'Prerequisites' sections — Claude doesn't need 13 bullet points to know when to apply transaction design patterns.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The skill is comprehensive and mostly efficient, but includes some unnecessary explanations (e.g., 'Why it matters' bullets that restate what Claude would already know about contention, the Prerequisites section, and verbose introductory text). The 'When to Use This Skill' list is overly long. However, most content earns its place with concrete examples and CockroachDB-specific guidance. | 2 / 3 |
Actionability | Excellent actionability throughout — nearly every section includes executable code examples in SQL, Python, or Java/YAML config. The retry loop, UNNEST batch pattern, CTE pattern, keyset pagination, and connection pool configuration are all copy-paste ready with specific, concrete guidance. | 3 / 3 |
Workflow Clarity | The 18 steps are clearly numbered and sequenced from basic to advanced, and the SQLSTATE table provides good error-handling guidance. However, there are no explicit validation checkpoints or feedback loops for multi-step processes like the transaction retry workflow or the read-write split pattern. The monitoring/testing steps (17-18) defer to a reference file rather than providing inline validation checklists. | 2 / 3 |
Progressive Disclosure | The skill references companion skills (cockroachdb-sql, benchmarking-transaction-patterns) and a monitoring reference file, which is good structure. However, the main body is very long (~400+ lines) with 18 detailed sections that could benefit from splitting advanced topics (connection pooling config, key design, monitoring) into separate reference files. The referenced bundle file 'references/monitoring-and-concurrency-testing.md' is not provided, making it impossible to verify navigation accuracy. | 2 / 3 |
Total | 9 / 12 Passed |
Validation
90%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 10 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
skill_md_line_count | SKILL.md is long (589 lines); consider splitting into references/ and linking | Warning |
Total | 10 / 11 Passed | |
84bc1e4
Table of Contents
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.