CtrlK
BlogDocsLog inGet started
Tessl Logo

testland/mvcc-isolation-tests

Build per-database MVCC isolation-level tests - Read Uncommitted vs Read Committed vs Repeatable Read vs Serializable; verify which anomalies are prevented at each level (dirty read, non-repeatable read, phantom read, serialization anomaly, write skew). Per PostgreSQL transaction isolation docs; analogous patterns for MySQL InnoDB, SQL Server, and DynamoDB. Use when two concurrent transactions can touch the same rows (balance debit, seat booking, stock decrement), or before changing a service's default isolation level.

76

Quality

96%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Overview
Quality
Evals
Security
Files

Quality

Content

92%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is lean, highly actionable, and clearly sequenced with validation and retry feedback loops, though it relies on a few undefined test fixtures and one stubbed test. Its main weakness is progressive disclosure: everything lives inline in one file with no reference bundle to offload detail.

Suggestions

Move the per-database differences table (Step 8) and/or the full test catalog into a references/ file (e.g. PER_DB_MATRIX.md) and link to it from the body so SKILL.md stays a concise overview.

Define the test fixtures (setup_balance, setup_orders, setup_doctors, count_on_call) or note them as assumed helpers so the examples are fully copy-paste runnable.

Complete the test_serializable_retry_completes stub or mark it explicitly as an exercise, rather than leaving a bare ellipsis body.

DimensionReasoningScore

Conciseness

The body is code- and table-forward (anomaly catalog, isolation matrix, harness, per-DB matrix) with no rambling on concepts Claude already knows; "The Steps 4-6 workloads use time.sleep(0.5) ... can flake on slow CI" adds only the non-obvious timing caveat. It earns its tokens rather than padding, fitting the 'lean and efficient' anchor and not the 'mostly efficient but could be tightened' bar (2).

3 / 3

Actionability

Real executable psycopg code with concrete assertions is provided throughout (two_connection_test harness, non-repeatable-read, phantom, write-skew, serializable tests, retry helper); the substantive logic is copy-paste ready. Undefined fixtures (setup_balance, setup_doctors, count_on_call) and one stubbed retry test are minor gaps that do not drop it to the pseudocode/missing-key-details bar (2).

3 / 3

Workflow Clarity

Steps 1-9 are clearly sequenced (catalog -> matrix -> harness -> per-anomaly tests -> per-DB -> retry), with assert-based validation in each test and an explicit retry feedback loop (Step 9) plus a deterministic-variant note for flake recovery; anti-patterns and limitations act as checklists, matching the 'clear sequence with explicit validation steps; feedback loops' anchor rather than missing checkpoints (2).

3 / 3

Progressive Disclosure

The file is well-organized by section but entirely monolithic: the anomaly catalog, isolation matrix, full test library, per-DB table, and retry pattern are all inline in a single ~290-line SKILL.md with no split-out reference files (no references/ bundle exists). This fits 'content that should be separate is inline' (2) rather than the well-signaled one-level-deep references of the 3 anchor.

2 / 3

Total

11

/

12

Passed

Description

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.

The description is specific, third-person, and clearly answers both what the skill does and when to use it with concrete scenario triggers. It is distinguishable from sibling skills and avoids vague fluff or over-claims.

DimensionReasoningScore

Specificity

"Build per-database MVCC isolation-level tests" and "verify which anomalies are prevented at each level" list multiple concrete actions (build tests, verify anomaly prevention) and enumerate specific anomalies and four databases, matching the 'lists multiple specific concrete actions' anchor; it is not merely naming a domain (2) and goes well beyond vague language (1).

3 / 3

Completeness

It clearly states what ("Build ... tests", "verify which anomalies are prevented") and an explicit when clause ("Use when two concurrent transactions can touch the same rows ... or before changing a service's default isolation level"), satisfying the 'clearly answers both what AND when with explicit triggers' anchor rather than leaving when implied (2).

3 / 3

Trigger Term Quality

"Use when two concurrent transactions can touch the same rows (balance debit, seat booking, stock decrement), or before changing a service's default isolation level" surfaces natural scenario terms a user would actually say; it exceeds the 'some relevant keywords' bar (2) with good coverage of common variations.

3 / 3

Distinctiveness Conflict Risk

The MVCC isolation-testing niche with triggers like concurrent-row conflicts and isolation-level changes is clearly distinct and unlikely to trigger for unrelated skills; it clears the 'clear niche with distinct triggers' anchor instead of overlapping with similar skills (2).

3 / 3

Total

12

/

12

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Reviewed

Table of Contents