CtrlK
BlogDocsLog inGet started
Tessl Logo

designing-application-transactions

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

Quality

82%

Does it follow best practices?

Impact

Pending

No eval scenarios have been run

SecuritybySnyk

Passed

No known issues

SKILL.md
Quality
Evals
Security

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.

DimensionReasoningScore

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.

DimensionReasoningScore

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.

Validation10 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

skill_md_line_count

SKILL.md is long (589 lines); consider splitting into references/ and linking

Warning

Total

10

/

11

Passed

Repository
cockroachlabs/cockroachdb-skills
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.