Borrowing it
Nothing to install: this file belongs to everr-labs/everr. 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/everr-labs/everr/main/.agents/skills/clickhouse-best-practices/SKILL.mdgit clone --depth 1 https://github.com/everr-labs/everrWrote 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/everr-labs/everr/clickhouse-best-practices)<a href="https://agentmods.dev/skills/everr-labs/everr/clickhouse-best-practices"><img src="https://agentmods.dev/badge/skills/everr-labs/everr/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/everr-labs/everr/clickhouse-best-practices"><img src="https://agentmods.dev/badge/skills/everr-labs/everr/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.02091 |
| Opus 5 | $0.00023 | $0.01045 |
| Sonnet 5 | $0.00009 | $0.00418 |
| Haiku 4.5 | $0.00005 | $0.00209 |
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 10d 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
30 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 48 KB
- README.md 1.5 KB
- rules/insert-async-small-batches.md 1.8 KB
- rules/insert-batch-size.md 1.5 KB
- rules/insert-format-native.md 933 B
- rules/insert-mutation-avoid-delete.md 2.0 KB
- rules/insert-mutation-avoid-update.md 1.7 KB
- rules/insert-optimize-avoid-final.md 1.9 KB
- rules/query-index-skipping-indices.md 2.4 KB
- rules/query-join-choose-algorithm.md 1.8 KB
- rules/query-join-consider-alternatives.md 2.1 KB
- rules/query-join-filter-before.md 1.3 KB
- rules/query-join-null-handling.md 1.0 KB
- rules/query-join-use-any.md 1.1 KB
- rules/query-mv-incremental.md 2.0 KB
- rules/query-mv-refreshable.md 2.0 KB
- rules/schema-json-when-to-use.md 2.0 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.1 KB
- rules/schema-partition-start-without.md 1.2 KB
- rules/schema-pk-cardinality-order.md 1.6 KB
- rules/schema-pk-filter-on-orderby.md 1.5 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 1.8 KB
- rules/schema-types-enum.md 1.7 KB
- rules/schema-types-lowcardinality.md 1.7 KB
- rules/schema-types-minimize-bitwidth.md 1.4 KB
- rules/schema-types-native-types.md 1.8 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.
- 10d ago First seen · 235 lines · 45 tokens per session scan A 933255d68f2a
clickhouse-best-practices is a skill published in the GitHub repository everr-labs/everr (45 stars, last pushed today), licensed AGPL-3.0. It adds 45 tokens to every session and 2,091 once invoked, about $0.0002 per session on Opus 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-08-30.
Other skills, from other repositories
investigate-ci
Investigates GitHub Actions workflow failures for any repo. Fetches recent runs, identifies failures, extracts error logs, diagnoses root causes, and suggests fixes. Use when a deploy or CI workflow fails and you need to understand why.
ci-fix-with-memory
Automatically invoke when CI checks fail on a PR. Triggers on: any mention of CI failure, red checks, failed GitHub Actions, or "CI is broken/failing". Reads session handoffs and a known-issues log to avoid repeating failed fix attempts. Do NOT wait for user to ask — invoke as soon as a CI failure is confirmed. Not…
devops
Use when setting up CI/CD pipelines, deploying applications, managing cloud infrastructure (AWS, GCP, Azure), implementing monitoring, containerizing services, or automating deployments with infrastructure as code.
aw-author
Author, validate, and improve GitHub Agentic Workflow (gh-aw) markdown files. Use when the user wants to create a new workflow, validate an existing workflow, improve a workflow, or debug workflow issues. Triggers on: "aw-author", "agentic workflow", "gh-aw workflow", "workflow markdown", "workflow frontmatter"…
deploy-agent
You are the Deploy agent for this project. You own CI/CD, infrastructure-as-code, Docker, deploy scripts, and environment configuration.
devops-engineer
Creates Dockerfiles, configures CI/CD pipelines, writes Kubernetes manifests, and generates Terraform/Pulumi infrastructure templates. Handles deployment automation, GitOps configuration, incident response runbooks, and internal developer platform tooling. Use when setting up CI/CD pipelines, containerizing…