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-best-practices/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-best-practices)<a href="https://agentmods.dev/skills/speakeasy-api/gram/clickhouse-best-practices"><img src="https://agentmods.dev/badge/skills/speakeasy-api/gram/clickhouse-best-practices/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-best-practices"><img src="https://agentmods.dev/badge/skills/speakeasy-api/gram/clickhouse-best-practices.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.00045 | $0.02598 |
| Opus 5.5 | $0.00018 | $0.01039 |
| Sonnet 5.5 | $0.00009 | $0.00520 |
| Haiku 4.5 | $0.00005 | $0.00260 |
Grade A, and why
clickhouse-best-practices 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
36 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 62 KB
- metadata.json 643 B
- README.md 2.5 KB
- rules/_sections.md 1.8 KB
- rules/_template.md 624 B
- rules/agent-connect-mcp.md 4.9 KB
- rules/agent-discovery-schema.md 6.0 KB
- rules/agent-query-safety.md 6.2 KB
- rules/insert-async-small-batches.md 1.9 KB
- rules/insert-batch-size.md 1.6 KB
- rules/insert-format-native.md 1.1 KB
- rules/insert-mutation-avoid-delete.md 2.1 KB
- rules/insert-mutation-avoid-update.md 2.2 KB
- rules/insert-optimize-avoid-final.md 2.0 KB
- rules/query-index-skipping-indices.md 2.6 KB
- rules/query-join-choose-algorithm.md 2.1 KB
- rules/query-join-consider-alternatives.md 2.2 KB
- rules/query-join-filter-before.md 1.3 KB
- rules/query-join-null-handling.md 1.3 KB
- rules/query-join-use-any.md 1.2 KB
- rules/query-mv-incremental.md 2.0 KB
- rules/query-mv-refreshable.md 2.2 KB
- rules/schema-json-when-to-use.md 2.2 KB
- rules/schema-partition-lifecycle.md 1.5 KB
- rules/schema-partition-low-cardinality.md 1.6 KB
- rules/schema-partition-query-tradeoffs.md 1.2 KB
- rules/schema-partition-start-without.md 1.3 KB
- rules/schema-pk-cardinality-order.md 1.7 KB
- rules/schema-pk-filter-on-orderby.md 1.7 KB
- rules/schema-pk-plan-before-creation.md 2.0 KB
- rules/schema-pk-prioritize-filters.md 1.2 KB
- rules/schema-types-avoid-nullable.md 2.0 KB
- rules/schema-types-enum.md 1.9 KB
- rules/schema-types-lowcardinality.md 1.8 KB
- rules/schema-types-minimize-bitwidth.md 1.6 KB
- rules/schema-types-native-types.md 2.1 KB
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 · 279 lines · 45 tokens per session scan A 68e596da9f26
clickhouse-best-practices is a skill published in the GitHub repository speakeasy-api/gram (277 stars, last pushed today), licensed AGPL-3.0. It adds 45 tokens to every session and 2,598 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-best-practices compared with skills from other repositories
| Mod | Type | Stars | Last push | Licence | Scan | Tokens | Works with |
|---|---|---|---|---|---|---|---|
| clickhouse-best-practicesspeakeasy-api/gram | Skill | 277 | today | AGPL-3.0 | A | 45 | 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 |