Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add instructions/smi2/phpclickhouse/claude-mdgit clone --depth 1 https://github.com/smi2/phpClickHouseWhat 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 | $0.01929 | $0.01929 |
| Opus 5 | $0.00964 | $0.00964 |
| Sonnet 5 | $0.00386 | $0.00386 |
| Haiku 4.5 | $0.00193 | $0.00193 |
Grade A, and why
phpClickHouse CLAUDE.md scanned grade A with 1 finding 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 3d 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.
Makes network callslowCapability
Not a fault in itself. Listed so you know the mod talks to something, and to what.
PHP client library for ClickHouse (`smi2/phpclickhouse`). Pure PHP, no dependencies beyond ext-curl and ext-json. Supports PHP 8.1+. How it starts
The opening of the file, as written. The whole thing — 191 lines — stays where its author put it; the contents beside it link to each section on GitHub.
CLAUDE.md — phpClickHouse
Project Overview
PHP client library for ClickHouse (smi2/phpclickhouse). Pure PHP, no dependencies beyond ext-curl and ext-json. Supports PHP 8.1+.
Principles
- Follow existing patterns in surrounding code — the codebase uses Doctrine coding standard (phpcs.xml.dist)
- Write tests for new functionality — all tests require a running ClickHouse instance
- Keep changes focused — avoid over-engineering, this is a lightweight HTTP client
- Security: all user-supplied values must go through
ValueFormatter::formatValue()or bindings (:param), never raw string interpolation into SQL - Use
declare(strict_types=1)in every PHP file - PSR-4 autoloading:
ClickHouseDB\namespace maps tosrc/ - Backward compatibility is sacred: NEVER rename, remove, or change signatures of public methods. Public API must remain fully compatible across versions. New parameters — only with default values. Deprecate, but don't break.
Architecture
Client (API) → Http (transport) → CurlerRequest/CurlerRolling (curl) → Statement (results)
↑ ↑
Settings Query + Degenerations (SQL generation)
- Client.php — user-facing API:
select(),write(),insert(),selectAsync() - Statement.php — result wrapper with lazy parsing, implements Iterator
- Settings.php — connection config (timeouts, compression, HTTPS, readonly)
- Transport/Http.php — HTTP layer, auth methods (header/basic/query string), URL construction
- Transport/CurlerRolling.php — async execution via
curl_multi_* - Query/Query.php — SQL + format management, degeneration pipeline
- Query/Degeneration/Bindings.php — parameter binding (
:param→ escaped value) - Query/Degeneration/Conditions.php — conditional SQL template blocks
- Quote/ValueFormatter.php — type-aware value escaping for SQL safety
- Cluster.php — multi-node cluster support with health checks
Key Notes
Running Tests
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.
- 3d ago First seen · 191 lines · 1,929 tokens per session scan A 825d70604db3
phpClickHouse CLAUDE.md is an instructions file published in the GitHub repository smi2/phpClickHouse (853 stars, last pushed 2mo ago), licensed MIT. It adds 1,929 tokens to every session, about $0.0096 per session on Opus 5. A static security scan graded it A with 1 finding (makes network calls). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other instructions, from other repositories
Addax AGENTS.md
AGENTS.md instructions for wgzhao/Addax, covering agents.md, 概述, 通用偏好, 编译 and 整体编译.
Tracely-ai CLAUDE.md
Claude Code instructions for Jwuthri/Tracely-ai, covering claude.md, commands, architecture, hard rules and gotchas.
symfony-flex-backend CLAUDE.md
Instructions for tarlepp/symfony-flex-backend, covering what is this?, table of contents ᐞ, ai documentation map ᐞ, version sources of truth ᐞ and project architecture ᐞ.
FreshRSS php.instructions.md
Instructions for FreshRSS/FreshRSS, covering php files and autoloader.
LarAgent AGENTS.md
Instructions for MaestroError/LarAgent, covering purpose, key principles, planning, executing plan and testing.
dory CLAUDE.md
Instructions for dorylab/dory, covering dory - claude code guidelines, project structure, package manager, shadcn/ui and dependency upgrades.