query-design SKILL.md skillA
query-design from joelhooks/rat-stack is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add joelhooks/rat-stack/query-design@git:20261024.c525d23Pins git:20261024.c525d23 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- joelhooks/rat-stack
- Path
skills/query-design/SKILL.md- Versions recorded
- 2
- Latest version
- git:20261024.c525d23, committed Oct 24, 2026
- First version recorded
- Oct 13, 2026
- Size
- 13,850 bytes
- Repository stars
- 216
- License
- MIT
Design or review SQL reads, writes, scans, backfills, and slow database paths. Use before changing a store method or any loop that queries. Covers round-trip arithmetic, batching, keyset paging, index evidence, row budgets, PlanetScale Vitess limits, Hyperdrive connections, statement-count tests, and statement-template fences.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# Design queries around round trips Count round trips before writing SQL. Small tables can still produce slow runs when each row needs several database calls. ```text round trips per call × calls per run × RTT = wall time ``` RTT means round-trip time. This arithmetic estimates serial network time; query execution, decoding, and connection acquisition add costs. Consider an illustrative scan of about 9k threads: - Per-thread reads: 5 round trips × about 9.3k threads × 81 ms ≈ 63 minutes. - Paged and batched reads: 2 round trips × 93 pages × about 100 ms ≈ 20 seconds. - These are planning inputs. Measure RTT where the caller runs before choosing its budget. A [capability](/systems/capabilities) call has a constant round-trip budget, independent of result size. State that number and bound its result. A scan costs O(pages), never O(rows). Count transaction control statements and any final empty-page probe too. Done means the store implementation matches a written query plan, and checks detect violations of its statement and access-path budgets. ## 1. Name the question, caller, and rate Record these before changing the store: …
Read the whole file at its exact version.
How to install
claude plugin marketplace add https://markdownregistry.com/mp/a/art_ivtobsbgssjdgbkm/4363f0ed6825b42fe4773f9293f078917766d5c84401f91823faea5fb1c65115.json
Then /plugin install query-design@markdownregistry-ivtobsbgssjdgbkm in Claude Code. It installs git:20261024.c525d23, the one graded A here, pinned to the commit it was graded at, and leaves it there.
mdr add joelhooks/rat-stack/query-design@sha256:4363f0ed6825b42fThe line at the top of this page pins the label git:20261024.c525d23, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_ivtobsbgssjdgbkm)
3 badge image fetches in 30 days. What the badge shows.
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry
Then ask it: what changed in joelhooks/rat-stack/query-design since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.
Got a copy of query-design from somewhere else? Ask it: where did my query-design come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.
Versions
The registry has recorded 2 versions of this file, between Oct 13, 2026 and Oct 24, 2026, about one every 11 days.
Watch this file (sign in, one email per new version)
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261024.c525d23 latest | 2026-10-24 | c525d23 | 13,850 B | A | view · diff |
| git:20261013.481ab83 | 2026-10-13 | 481ab83 | 13,953 B | A | view |
Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.
It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.
Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.
mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml
It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.
Installed this file, say at .claude/skills/query-design/SKILL.md? Drop it here to learn which saved version you have and what changed since. Your browser works out its SHA-256 fingerprint and sends only that; the file itself never leaves your computer.
Or paste its contents
Your agent can run this same check on the agent markdown files you have installed, up to 50 in one ask. Add the registry once:
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry
Then ask it to check the files you have installed. No key and no account.
From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.
sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies
In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.
sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies
No sha256sum on your machine? shasum -a 256 prints the same lines.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (13850 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
joelhooks/rat-stack · 216 stars · license MIT · pushed 2026-11-19 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_ivtobsbgssjdgbkm GET https://markdownregistry.com/api/v1/resolve?ref=joelhooks/rat-stack/query-design GET https://markdownregistry.com/api/v1/blob/4363f0ed6825b42fe4773f9293f078917766d5c84401f91823faea5fb1c65115
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.