What is clickadvisor AGENTS.md?

Um guia de trabalho para agentes que desenvolvem o ClickAdvisor, uma ferramenta local para analisar consultas SQL do ClickHouse, um banco de dados voltado a grandes volumes de dados.

Serve para orientar a leitura da documentação, a criação e o registro de regras de análise, o tratamento de contexto ausente e as verificações antes de modificar o repositório.

Impede que recomendações de produção dependam apenas de texto gerado por inteligência artificial e exige que regras, documentação e contexto sejam conferidos no próprio projeto.

How olyannaa/clickadvisor configures Codex and OpenCode

Reuse

Borrowing it

Nothing to install: this file belongs to olyannaa/clickadvisor. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file

curl -O https://raw.githubusercontent.com/olyannaa/clickadvisor/main/AGENTS.md

Clone the repo

git clone --depth 1 https://github.com/olyannaa/clickadvisor

Made for: Codex, OpenCode.

Wrote 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.

README.md

[![agentmods](https://agentmods.dev/badge/instructions/olyannaa/clickadvisor/agents-md/github.svg)](https://agentmods.dev/instructions/olyannaa/clickadvisor/agents-md)

Your own site

<a href="https://agentmods.dev/instructions/olyannaa/clickadvisor/agents-md"><img src="https://agentmods.dev/badge/instructions/olyannaa/clickadvisor/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.

Your own site · 80×15

<a href="https://agentmods.dev/instructions/olyannaa/clickadvisor/agents-md"><img src="https://agentmods.dev/badge/instructions/olyannaa/clickadvisor/agents-md.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 783 This file is loaded in full into every session.

When invoked 783 The same file — it is already loaded in full.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

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.00783	$0.00783
Opus 5.5	$0.00313	$0.00313
Sonnet 5.5	$0.00157	$0.00157
Haiku 4.5	$0.00078	$0.00078

Measured 2mo ago against content hash dc8e40a5619a, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

clickadvisor 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 2mo 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.

AGENTS.md · 87 lines

How it starts

The opening of the file, as written. The whole thing — 87 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Правила Работы Агентов С Репозиторием

Этот файл описывает, как AI-агенты должны работать с ClickAdvisor.

Базовый принцип

ClickAdvisor — local-first анализатор ClickHouse SQL. Доверенный runtime path: детерминированный rule engine, ML evaluation surface и локальный retrieval. Generative LLM не должен становиться источником production-рекомендаций внутри CLI/MCP.

Перед изменениями

Начинай с чтения README.md, docs/ARCHITECTURE.md, docs/evaluation.md и релевантных файлов из docs/rules/.
Проверяй текущее состояние через git status -sb.
Не перетирай пользовательские изменения и не используй destructive git commands без явной просьбы.
Для поиска используй rg / rg --files.

Правила каталога

У каждого runtime rule должен быть card в docs/rules/cards/.
У каждого card со статусом implemented должна быть зарегистрированная реализация в clickadvisor/rules/registry.py.
Нельзя добавлять duplicate rule_id.
Если правилу нужен schema/environment/explain context, отсутствие контекста должно давать None, а не догадочную находку.
Tier 2 правила являются advisory. Не добавляй automatic rewrite, если card явно не содержит безопасный шаблон.
Environment rules должны читать только QueryContext.environment и дополнительные доступные context-поля.

Тесты и benchmark

Для нового или измененного правила нужны прямые unit-тесты:

positive case;
no-trigger или no-context case;
проверка ожидаемого rule_id.

Если правило можно представить в benchmark schema, добавь case в benchmark/cases/synthetic_expanded/.

Benchmark labels должны отражать реальные multi-label overlaps. В strict mode не должно быть неожиданных FP/FN.

Документация

Основная документация репозитория ведется на русском языке.
README должен соответствовать фактическим счетчикам rules/tests/benchmark.
Не заявляй speedup, production LLM, query replay или автоматические DDL изменения, если этого нет в коде и проверках.
Enterprise/security формулировки должны подчеркивать zero data egress: SQL, DDL, EXPLAIN и environment context не отправляются во внешние LLM/API.

Read the full file on GitHub · 87 lines

Changes

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.

2mo ago First seen · 87 lines · 783 tokens per session scan A dc8e40a5619a

Subscribe to this mod's changes

clickadvisor AGENTS.md is an instructions file published in the GitHub repository olyannaa/clickadvisor (18 stars, last pushed 6d ago), licensed MIT. It adds 783 tokens to every session, about $0.0031 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.

Databases Python RAG and vectors cli clickhouse mcp

clickadvisor AGENTS.md next to 6 instructions from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
clickadvisor AGENTS.mdolyannaa/clickadvisor	Instructions file	18	6d ago	MIT	A	783	Codex, OpenCode
vscode buildNext.instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	9,719	GitHub Copilot
next.js AGENTS.mdvercel/next.js	Instructions file	143k	today	MIT	A	7,461	Codex, OpenCode
vscode oss-third-party-notices.instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	5,516	GitHub Copilot
langchain AGENTS.mdlangchain-ai/langchain	Instructions file	149k	today	MIT	A	4,680	Codex, OpenCode
vscode copilot-instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	3,093	GitHub Copilot
vscode ai-customization.instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	1,907	GitHub Copilot

clickadvisor: Instructions file for Codex