ClickHouse/agent-skills is a collection of packaged instructions that give AI coding agents specialized guidance for ClickHouse databases and chdb, an in-process version of ClickHouse for Python. It helps agents design schemas, write queries, ingest data, analyze results, and troubleshoot performance with ClickHouse or ClickHouse Cloud. The catalogue entries are the repository’s skills, plugins, and instruction for using these systems.
Borrowing it
Nothing to install: this file belongs to ClickHouse/agent-skills. 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/ClickHouse/agent-skills/main/AGENTS.mdgit clone --depth 1 https://github.com/ClickHouse/agent-skillsWrote 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/instructions/clickhouse/agent-skills/agents-md)<a href="https://agentmods.dev/instructions/clickhouse/agent-skills/agents-md"><img src="https://agentmods.dev/badge/instructions/clickhouse/agent-skills/agents-md/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/instructions/clickhouse/agent-skills/agents-md"><img src="https://agentmods.dev/badge/instructions/clickhouse/agent-skills/agents-md.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.01897 | $0.01897 |
| Opus 5.5 | $0.00759 | $0.00759 |
| Sonnet 5.5 | $0.00379 | $0.00379 |
| Haiku 4.5 | $0.00190 | $0.00190 |
Grade A, and why
agent-skills AGENTS.md 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.
How it starts
The opening of the file, as written. The whole thing — 212 lines — stays where its author put it; the contents beside it link to each section on GitHub.
AGENTS.md
This file provides guidance to AI coding agents (Claude Code, Cursor, Copilot, etc.) when working with code in this repository.
Repository Overview
A collection of skills for AI agents working with ClickHouse databases and chdb (in-process ClickHouse for Python). Skills are packaged instructions and guidelines that extend agent capabilities for database design, query optimization, operational best practices, and in-process data analytics.
Repository Structure
agent-skills/
├── skills/
│ ├── clickhouse-best-practices/ # ClickHouse optimization guidelines
│ │ ├── SKILL.md # Skill definition (overview)
│ │ ├── AGENTS.md # Full compiled guide (generated)
│ │ ├── metadata.json # Version, organization, abstract
│ │ ├── README.md # Maintainer guide
│ │ └── rules/ # Individual rule files
│ │ ├── _sections.md # Section metadata
│ │ ├── _template.md # Template for new rules
│ │ └── *.md # Rule files (e.g., query-use-prewhere.md)
│ ├── chdb-datastore/ # chdb pandas-compatible DataStore API
│ │ ├── SKILL.md # Skill definition and quick-start
│ │ ├── metadata.json # Version, organization, abstract
│ │ ├── README.md # Maintainer guide
│ │ ├── references/ # API reference docs
│ │ │ ├── api-reference.md # DataStore method signatures
│ │ │ └── connectors.md # All data source connection methods
│ │ ├── examples/
│ │ │ └── examples.md # Runnable examples
│ │ └── scripts/
│ │ └── verify_install.py # Environment verification
│ └── chdb-sql/ # chdb SQL API
│ ├── SKILL.md # Skill definition and quick-start
│ ├── metadata.json # Version, organization, abstract
│ ├── README.md # Maintainer guide
│ ├── references/ # SQL reference docs
│ │ ├── api-reference.md # query/Session/connect signatures
│ │ ├── table-functions.md # ClickHouse table functions
│ │ └── sql-functions.md # Commonly used SQL functions
│ ├── examples/
│ │ └── examples.md # Runnable examples
│ └── scripts/
│ └── verify_install.py # Environment verification
├── packages/
│ └── clickhouse-best-practices-build/ # Build tooling
│ ├── package.json # Bun scripts
│ ├── tsconfig.json # TypeScript config
│ └── src/
│ ├── config.ts # Path configuration
│ ├── types.ts # Type definitions
│ ├── parser.ts # Markdown parser
│ ├── build.ts # Build script
│ ├── validate.ts # Rule validator
│ ├── validate-sql.ts # SQL syntax validator
│ └── check-links.ts # Internal link checker
└── .github/
└── workflows/
└── clickhouse-best-practices-ci.yml # CI workflow
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 · 212 lines · 1,897 tokens per session scan A 676acaaebfb6
agent-skills AGENTS.md is an instructions file published in the GitHub repository ClickHouse/agent-skills (551 stars, last pushed today), licensed Apache-2.0. It adds 1,897 tokens to every session, about $0.0076 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-08-30.
Other instructions, from other repositories
vscode buildNext.instructions.md
Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).
next.js AGENTS.md
AGENTS.md instructions for vercel/next.js, covering next.js development guide, codebase structure, monorepo overview, core package: packages/next and other important packages.
vscode oss-third-party-notices.instructions.md
Instructions for microsoft/vscode, covering vs code oss third-party-notices pipeline, architecture, pipeline flow in ci, cache eligibility and rollout and applying the notice (cutover).
langchain AGENTS.md
AGENTS.md instructions for langchain-ai/langchain, covering global development guidelines for the langchain monorepo, corridor security analysis, project architecture and context, monorepo structure and development tools & commands.
vscode copilot-instructions.md
Copilot instructions for microsoft/vscode, covering vs code copilot instructions, project overview, root folders, core architecture (src/ folder) and built-in extensions (extensions/ folder).
deepseek-harness AGENTS.md
AGENTS.md instructions for deepseek-ai/deepseek-harness, covering agents.md, pre-stable apis and released session data, repository layout, commands and host sandbox failures.