CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

ddia-systems

Design data systems by understanding storage engines, replication, partitioning, transactions, and consistency models. Use when the user mentions "database choice", "replication lag", "partitioning strategy", "consistency vs availability", "stream processing", "ACID transactions", "eventual consistency", or "LSM tree vs B-tree". Also trigger when choosing between SQL and NoSQL, designing data pipelines, or debugging distributed system consistency issues. Covers data models, batch/stream processing, and distributed consensus. For system design, see system-design. For resilience, see release-it.

Quality

83%

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

SKILL.md
Quality
Evals
Security

Quality

Content

71%Weight 40%Scale 1-5

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

A well-structured framework skill with excellent progressive disclosure, real reference files, and concrete pattern tables, weakened mainly by token efficiency: much of the "Key insights" content restates distributed-systems knowledge Claude already has, and the author bio, affiliate book link, and duplicated reference index add pure overhead.

Suggestions

Cut the "About the Author" section and the affiliate-tagged Amazon link — they consume tokens without improving skill execution; a one-line attribution to Kleppmann's DDIA suffices.

Trim the "Key insights" bullets to only non-obvious, opinionated guidance (e.g. keep "write skew occurs when two transactions read the same data... no row-level lock prevents this") and cut restatements of textbook knowledge Claude already has (e.g. definitions of LSM vs B-tree, the isolation-level spectrum).

Remove the duplicated "Reference Files" section (or the per-section "See:" links) so each reference is listed once, and replace the missing common trigger term "sharding"/"CAP theorem" coverage gap by mentioning them where partitioning and consistency trade-offs are introduced.

DimensionReasoningScore

Conciseness

The format is dense bullets rather than padded prose, but the "Key insights" lists re-explain textbook concepts Claude already knows (LSM vs B-tree trade-offs, isolation-level spectrum, fault-vs-failure definitions), and the "About the Author" paragraph, the affiliate-tagged book link, and a "Reference Files" section duplicating the per-section "See:" links are unnecessary padding. Fits anchor 3 (mostly efficient, some unnecessary explanation); not anchor 2 because there is no verbose tutorial-style prose and the tables are tight.

3 / 5

Actionability

The "Code applications" tables give concrete, specific guidance — PostgreSQL primary + read replicas behind pgBouncer, Debezium CDC publishing to Kafka, `SELECT ... FOR UPDATE`, `retry(max=3, backoff=exponential(base=1s, max=30s))` with jitter — and the SQL transfer example is executable. Minor gaps (no complete copy-paste-ready workflows) keep it below anchor 5, but it is well above anchor 3's pseudocode-level guidance.

4 / 5

Workflow Clarity

The Scoring section gives an explicit output protocol ("rate them 0-10... Always provide the current score and specific improvements needed to reach 10/10") and the Quick Diagnostic is a structured Question → If No → Action checklist, giving the framework a clear evaluation procedure. Below anchor 5 because the sequence for applying the seven domains to a real review is implicit, not step-by-step; no destructive/batch operations, so no validation cap applies.

4 / 5

Progressive Disclosure

The body is a well-split overview: each of the seven domains summarizes core concept, key insights, and applications, then clearly signals its one-level-deep reference ("See: [references/data-models.md]"), and all seven referenced files exist in the bundle. The trailing "Reference Files" index is mild duplication but serves as a navigation summary; navigation is easy and references are never nested.

5 / 5

Total

16

/

20

Passed

Description

87%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description that explicitly answers both what and when with a rich set of natural trigger phrases, and even routes users away from adjacent skills. The only gaps are a few missing common synonyms ("sharding", "CAP theorem") and a topic-coverage framing that slightly dilutes the action list.

DimensionReasoningScore

Specificity

Lists several concrete actions ("Design data systems", "choosing between SQL and NoSQL", "designing data pipelines", "debugging distributed system consistency issues") tied to named subdomains. Falls short of anchor 5 because the primary framing "by understanding storage engines, replication..." leans on topic coverage rather than a comprehensive list of distinct action verbs, but is well above anchor 3's 1-2 actions.

4 / 5

Completeness

Clearly answers what ("Design data systems by understanding storage engines, replication, partitioning, transactions, and consistency models... Covers data models, batch/stream processing, and distributed consensus") and when with explicit concrete trigger phrases ("Use when the user mentions... Also trigger when..."). This is a direct match for the anchor 5 example pattern.

5 / 5

Trigger Term Quality

Eight quoted natural trigger phrases ("database choice", "replication lag", "ACID transactions", "eventual consistency", "LSM tree vs B-tree") plus three additional trigger conditions give good keyword coverage. Not anchor 5 because common synonyms a user would naturally say — e.g. "sharding" and "CAP theorem" — are missing; not anchor 3 since far more than a few relevant keywords are present.

4 / 5

Distinctiveness Conflict Risk

Clear niche (data-intensive systems design) with distinct, domain-specific triggers, and it explicitly disambiguates against sibling skills ("For system design, see system-design. For resilience, see release-it."), keeping conflict risk minimal. Only marginal adjacency is "designing data pipelines", which is not enough to drop to anchor 4's "minor overlap risk".

5 / 5

Total

18

/

20

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 — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

valeriibeck-star/claude-skills

Path

skills/ddia-systems/SKILL.md

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.