# ClickHouse

> [llms.txt](https://www.mintlify.com/llms.txt)

[clickhouse.com/docs](https://clickhouse.com/docs)

- **Overall score:** 99/100 (Grade A)
- **Checks passed:** 28 / 35
- **Last computed:** 2026-10-29

## Components

### Content Discoverability

- **Score:** 100/100 · **Status:** pass
- **Summary:** 7 AFDocs checks pass.
- **Rationale:** Agents need a clear entry point and crawl map before they can reliably discover the right pages.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **LLMS TXT Exists** — llms.txt found at 2 locations; using https://clickhouse.com/docs/llms.txt as canonical
- ✅ **LLMS TXT Valid** — llms.txt follows the proposed structure (H1, blockquote, heading-delimited link sections)
- ✅ **LLMS TXT Size** — llms.txt is 23,878 characters (under 50,000 threshold)
- ✅ **LLMS TXT Links Resolve** — All 15 same-origin sampled links resolve (145 total links)
- ✅ **LLMS TXT Links Markdown** — 15/15 same-origin sampled links point to markdown content (100%) (1 external link excluded)
- ✅ **LLMS TXT Directive Html** — llms.txt directive found in HTML of all 15 sampled pages, near the top of content
- ✅ **LLMS TXT Directive MD** — llms.txt directive found in markdown of all 15 sampled pages, near the top of content

### Markdown Availability

- **Score:** 100/100 · **Status:** pass
- **Summary:** 2 AFDocs checks pass.
- **Rationale:** When markdown is available directly, agents spend less effort stripping presentation markup and guessing structure.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **Markdown Url Support** — 15/15 sampled pages support .md URLs (100%)
- ✅ **Content Negotiation** — 15/15 sampled pages support content negotiation (100%)

### Page Size and Truncation Risk

- **Score:** 94/100 · **Status:** fail
- **Summary:** 2 failed and 2 warnings across 6 AFDocs checks.
- **Rationale:** Large pages, delayed primary content, and markdown that cannot be read in one fetch increase truncation risk and make retrieval less reliable.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **Rendering Strategy** — All 15 sampled pages contain server-rendered content
- ❌ **Page Size Markdown** — 1 of 15 pages exceed 100K chars (max 104K) 1 of 15 markdown pages exceed 100K characters and will be truncated by agents. Break these into smaller pages or restructure serialized tabbed content.
- ❌ **Page Size Html** — 1 of 15 sampled pages convert to over 100K chars (max 2993K HTML → 111K markdown (95% boilerplate)) 1 of 15 pages convert to over 100K characters of markdown. Break large pages into smaller units, reduce navigation boilerplate, or provide markdown versions that bypass the HTML conversion overhead.
- ⚠️ **Page Size Transfer** — 1 of 15 sampled pages serve 1MB–10MB (max 3.1MB served → 24KB content (~130:1)) 1 of 15 pages serve 1MB-10MB of HTML. Truncate-first and raw-ingestion agents consume mostly non-content bytes on these pages. Identify what the non-content bytes are (usually inline serialization: framework hydration payloads, embedded duplicate page source, resolved data objects visible in the page source). Avoid shipping the same content twice in different formats, load large data payloads on demand, and confirm markdown variants are available and discoverable so agents have a cheaper path. 1 of the oversized page ships many times more bytes than content (up to ~130:1). That ratio is an architecture signature (hydration payloads, embedded duplicate content), so the fix lives in framework configuration, not in the docs themselves.
- ⚠️ **Content Start Position** — 1 of 15 sampled pages have content starting at 10–50% (worst 14%) 1 of 15 pages have documentation content starting 10-50% into the converted output. Reduce navigation, breadcrumb, and sidebar markup that precedes the content area.
- ✅ **Single Fetch Completeness** — All 15 sampled markdown pages deliver complete content in one fetch (no pagination detected)

### Content Structure

- **Score:** 100/100 · **Status:** pass
- **Summary:** 5 AFDocs checks pass.
- **Rationale:** Predictable sections, valid code fences, serialized tabs, portable links, and pages not dominated by bulk data make the content easier for agents to parse correctly.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **Tabbed Content Serialization** — No tabbed content detected across 15 sampled pages
- ✅ **Section Header Quality** — No tabbed content found; header quality check not applicable
- ✅ **Markdown Code Fence Validity** — All 128 code fences properly closed across 17 pages
- ✅ **Markdown Link Portability** — All 670 links across 15 sampled markdown pages are absolute; 13 sampled links resolve to the expected representation
- ✅ **Embedded Data Serialization** — No bulk data elements detected across 15 sampled pages

### URL Stability and Redirects

- **Score:** 100/100 · **Status:** pass
- **Summary:** 2 AFDocs checks pass.
- **Rationale:** Stable URLs and sane redirect behavior prevent retrieval drift and broken tool references.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **Http Status Codes** — All 15 sampled pages return proper error codes for bad URLs
- ✅ **Redirect Behavior** — No redirects detected across 15 sampled pages

### Observability and Content Health

- **Score:** 99/100 · **Status:** partial
- **Summary:** 1 warning across 3 AFDocs checks.
- **Rationale:** Coverage, parity, and cache behavior determine whether agents can trust the content they retrieve.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **LLMS TXT Coverage** — llms.txt covers 100% of 24943 sitemap doc pages; 10 llms.txt links not in sitemap (may indicate stale links or incomplete sitemap)
- ⚠️ **Markdown Content Parity** — 1 of 15 pages have minor content differences between markdown and HTML 1 pages have minor content differences between their markdown and HTML versions. If this is intentional audience segmentation, adjust --parity-pass-threshold and --parity-warn-threshold (set both to 0 for informational mode).
- ✅ **Cache Header Hygiene** — All 17 endpoints have appropriate cache headers

### Authentication and Access

- **Score:** 100/100 · **Status:** partial
- **Summary:** 1 skipped across 3 AFDocs checks.
- **Rationale:** Agents need public access, or a clear alternative path when documentation is gated behind auth, without bot protection blocking automated fetches.
- **Reference:** [AFDocs reference](https://afdocs.dev)

**Checks**

- ✅ **Auth Gate Detection** — All 15 sampled pages are publicly accessible
- ⏭️ **Auth Alternative Access** — All docs pages are publicly accessible; no alternative access paths needed
- ✅ **Bot Protection Interference** — No bot-protection interference observed across 469 requests; 1 failed to fetch (not volume-correlated)

### Full Content Discoverability

- **Score:** 75/100 · **Status:** fail
- **Summary:** llms-full.txt has 1 failing check.
- **Rationale:** A full-document snapshot gives long-context agents a single canonical corpus to ingest without repeated crawling.
- **Reference:** [llms-full.txt guide](https://www.mintlify.com/docs/ai/llmstxt#llms-full-txt)

**Checks**

- ✅ **LLMS Full Exists** — Found llms-full.txt.
- ❌ **LLMS Full Size** — llms-full.txt size falls outside the expected range.
- ✅ **LLMS Full Valid** — llms-full.txt has a recognizable markdown structure.
- ✅ **LLMS Full Links Resolve** — llms-full.txt links resolve successfully.

### Agent Skills

- **Score:** 100/100 · **Status:** pass
- **Summary:** skill.md passes all checks.
- **Rationale:** Agent skills provide product-specific operating guidance that plain documentation pages do not encode on their own.
- **Reference:** [skill.md guide](https://www.mintlify.com/docs/ai/skillmd)

**Checks**

- ✅ **Skill MD** — Found an agent skill definition.

### MCP Server

- **Score:** 100/100 · **Status:** pass
- **Summary:** MCP passes all checks.
- **Rationale:** A discoverable MCP server lets agents use first-class tools instead of scraping pages and inferring behavior.
- **Reference:** [MCP guide](https://www.mintlify.com/docs/ai/model-context-protocol)

**Checks**

- ✅ **MCP Server Discoverable** — Found an MCP server.
- ✅ **MCP Tool Count** — The MCP server exposes tools.