ddia-systems

ddia-systems is a skill for Claude Code, Codex from clubpay/ronykit. It costs 128 tokens per session (4,092 once invoked), scanned A, original, BSD-3-Clause.

A guide to designing systems that store and process data reliably. It covers databases, indexes, replication, partitioning, transactions, and consistency, which describes how data stays correct across failures and concurrent requests.

In plain words
What is it for?
Use it when designing schemas, choosing between PostgreSQL, Redis, and object storage, planning partitions, or handling concurrent writes and repeated requests.
Why use it?
It helps avoid slow queries, conflicting updates, unsafe retries, stale reads, and poor choices about where application state should live.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it when designing schemas, choosing between PostgreSQL, Redis, and object storage, planning partitions, or handling concurrent writes and repeated requests.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/clubpay/ronykit/ddia-systems
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add clubpay/ronykit --skill ddia-systems
Clone the repo
git clone --depth 1 https://github.com/clubpay/ronykit

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for ddia-systems

README.md
[![agentmods](https://agentmods.dev/badge/skills/clubpay/ronykit/ddia-systems/github.svg)](https://agentmods.dev/skills/clubpay/ronykit/ddia-systems)
Your own site
<a href="https://agentmods.dev/skills/clubpay/ronykit/ddia-systems"><img src="https://agentmods.dev/badge/skills/clubpay/ronykit/ddia-systems/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for ddia-systems

Your own site · 80×15
<a href="https://agentmods.dev/skills/clubpay/ronykit/ddia-systems"><img src="https://agentmods.dev/badge/skills/clubpay/ronykit/ddia-systems.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 128 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 4,092 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00128 $0.04092
Opus 5.5 $0.00051 $0.01637
Sonnet 5.5 $0.00026 $0.00818
Haiku 4.5 $0.00013 $0.00409

Measured 23d ago against content hash 57f7772dd98b, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

ddia-systems scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 23d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

ronyup/internal/skeleton/skills/ddia-systems/SKILL.md · 276 lines

How it starts

The opening of the file, as written. The whole thing — 276 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Designing Data-Intensive Applications Framework

A principled approach to building reliable, scalable, and maintainable data systems. Apply these principles when choosing databases, designing schemas, architecting distributed systems, or reasoning about consistency and fault tolerance.

When to use

  • Writing SDD §6 (data design): tables, keys, indexes, retention, partitioning.
  • Choosing where state lives: Postgres (default), Redis, S3/MinIO, or a process-local cache.
  • An app method does read-modify-write and could race with itself.
  • A write must be safe under retries, duplicate delivery, or workflow replays.
  • Queries degrade as a table grows, or replicas/caches serve stale data.

RonyKit mapping (scaffolded apps)

Concern RonyKit default Read
System of record Postgres + sqlc in internal/repo/v0, migrations in data/db/migrations MCP architecture/postgres-sqlc
Growing append-only tables Postgres declarative RANGE partitioning with automated maintenance MCP architecture/table-partitioning
Shared/distributed state, counters, limits Redis via x/datasource.InitRedis; x/ratelimit on top MCP characteristics/redis
Hot read cache in one process x/cache (Ristretto) — never shared state MCP characteristics/cache
Blobs/files x/datasource S3/MinIO MCP packages/datasource
Retry-safe writes Idempotency keys + unique constraints; upserts in sqlc MCP characteristics/idempotent
Multi-step / cross-service consistency flow workflows (sagas, compensation) instead of distributed transactions MCP characteristics/workflow

Rules of thumb for feature modules:

  • Let the database enforce invariants it can: UNIQUE, CHECK, FOREIGN KEY, and NOT NULL beat app-side checks that race. Map constraint violations to rony/errs conflict errors in the repo adapter and cover them in the repo integration tests (go-testing).
  • Name the isolation you rely on. Postgres defaults to READ COMMITTED; a check-then-write in internal/app is a lost-update bug unless you use SELECT … FOR UPDATE, an atomic UPDATE … WHERE, optimistic versioning, or a unique constraint.
  • Index for the queries in data/db/queries, not for every column; verify with EXPLAIN on realistic volumes.
  • Cache is a derived view. Define its invalidation and staleness budget in the SDD before adding it.
  • Vendor names below are illustrations, not recommendations. MongoDB, Cassandra, Kafka, Flink, and the rest show where each trade-off lives. In a RonyKit workspace, adding a datastore or broker beyond the defaults above is an SDD decision that needs the user's approval.

Read the full file on GitHub · 276 lines

Files

What ships with it

7 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 23d ago First seen · 276 lines · 128 tokens per session scan A 57f7772dd98b

Subscribe to this mod's changes

ddia-systems is a skill published in the GitHub repository clubpay/ronykit (38 stars, last pushed today), licensed BSD-3-Clause. It adds 128 tokens to every session and 4,092 once invoked, about $0.0005 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-26.

Related

Other skills, from other repositories

db-infra-mocks

Propose minimal seams and local substitutes so tests run without real RDBMS/Redis/Mongo infrastructure.

pilinux/gorest · 27 tokens

accounting-audit-system-builder

Routes an accounting or audit request to the right module skill, from software selection through monthly closing, asking only what is missing. Use for books of accounts or audit files.

sickn33/agentic-awesome-skills · 41 tokens

sq

Guides use of the sq CLI to query SQL databases and tabular files with SLQ (sq's jq-like query language) or native SQL, manage sources, choose output formats, and run inspect, diff, and table commands. Use when the user mentions sq, SLQ, wrangling CSV/Excel/JSON/DB data, cross-source joins, or command-line data…

neilotoole/sq · 89 tokens

golang-database

Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use when writing, reviewing, or debugging Golang code that interacts with PostgreSQL…

samber/cc-skills-golang · 99 tokens

golang-samber-hot

In-memory caching in Golang using samber/hot — eviction algorithms (LRU, LFU, TinyLFU, W-TinyLFU, S3FIFO, ARC, TwoQueue, SIEVE, FIFO), TTL, cache loaders, sharding, stale-while-revalidate, missing key caching, and Prometheus metrics. Apply when using or adopting samber/hot, when the codebase imports…

samber/cc-skills-golang · 122 tokens

vendor-update

Upgrade Go/Node.js vendor dependencies and sync tool versions. Use whenever the user says "upgrade dependencies", "update vendors", "vendor update", "run vendor-upgrade", "bump dependencies", "update packages", or asks to run the vendor-update Make target. This skill also checks scripts/build/version.mk after…

apache/skywalking-banyandb · 95 tokens