Borrowing it
Nothing to install: this file belongs to speakeasy-api/gram. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/speakeasy-api/gram/main/.agents/skills/clickhouse-architecture-advisor/SKILL.mdgit clone --depth 1 https://github.com/speakeasy-api/gramWrote 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.
[](https://agentmods.dev/skills/speakeasy-api/gram/clickhouse-architecture-advisor)<a href="https://agentmods.dev/skills/speakeasy-api/gram/clickhouse-architecture-advisor"><img src="https://agentmods.dev/badge/skills/speakeasy-api/gram/clickhouse-architecture-advisor/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.
<a href="https://agentmods.dev/skills/speakeasy-api/gram/clickhouse-architecture-advisor"><img src="https://agentmods.dev/badge/skills/speakeasy-api/gram/clickhouse-architecture-advisor.svg" alt="Reviewed on agentmods" width="80" height="20"></a>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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00049 | $0.00680 |
| Opus 5.5 | $0.00020 | $0.00272 |
| Sonnet 5.5 | $0.00010 | $0.00136 |
| Haiku 4.5 | $0.00005 | $0.00068 |
Grade A, and why
clickhouse-architecture-advisor 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 1mo 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.
The source is not reproduced here
Licensed AGPL-3.0
The repository is licensed AGPL-3.0, which this catalogue does not treat as permission to reproduce the file. Read it at the source.
What ships with it
14 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.
- AGENTS.md 2.2 KB
- examples/finserv-market-surveillance.md 3.1 KB
- examples/observability-high-throughput.md 2.6 KB
- examples/README.md 501 B
- examples/siem-security-analytics.md 1.9 KB
- mappings/doc_links.yaml 1.1 KB
- metadata.json 920 B
- README.md 2.0 KB
- rules/decision-ingestion-strategy.md 2.6 KB
- rules/decision-join-enrichment.md 2.2 KB
- rules/decision-late-arriving-upserts.md 2.3 KB
- rules/decision-partitioning-timeseries.md 2.3 KB
- rules/decision-real-time-preaggregation.md 2.3 KB
- schemas/recommendation_schema.yaml 452 B
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.
- 1mo ago First seen · 137 lines · 49 tokens per session scan A e8dbd3f05c9d
clickhouse-architecture-advisor is a skill published in the GitHub repository speakeasy-api/gram (277 stars, last pushed today), licensed AGPL-3.0. It adds 49 tokens to every session and 680 once invoked, about $0.0002 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-10-01.
clickhouse-architecture-advisor compared with skills from other repositories
| Mod | Type | Stars | Last push | Licence | Scan | Tokens | Works with |
|---|---|---|---|---|---|---|---|
| clickhouse-architecture-advisorspeakeasy-api/gram | Skill | 277 | today | AGPL-3.0 | A | 49 | Claude Code, Codex |
| cis-aws-compute-12.3CyberStrikeus/CyberStrike | Skill | 3.4k | 4d ago | AGPL-3.0 | A | 23 | Claude Code, Codex |
| dynamodb-toolbox-patternsgiuseppe-trisciuoglio/developer-kit | Skill | 367 | 1mo ago | MIT | A | 76 | Claude Code |
| webiny-api-opensearch-catalogwebiny/webiny-js | Skill | 8.0k | yesterday | none | A | 19 | Claude Code, Codex |
| webiny-api-key-value-store-catalogwebiny/webiny-js | Skill | 8.0k | yesterday | none | A | 19 | Claude Code, Codex |
| prismaashish7802/awesome-api-skills | Skill | 13 | yesterday | MIT | A | 0 | Claude Code, Codex |
| pn-backend-architectureperniemann/pnCore | Skill | 0 | 5d ago | MIT | A | 37 | Cursor |