Clickhouse Io

---
name: clickhouse-io
description: ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
disable-model-invocation: true
---

# ClickHouse Analytics Patterns

> **Size budget: 8 KB** — `token-budget.mjs --check`.

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

## Working procedure

1. Establish the relevant mode and existing evidence; do not repeat completed intake.
2. Define the requested scope, baseline, success criteria and evidence before choosing a procedure. Verify current external requirements from primary sources. Distinguish observed facts from hypotheses and implemented controls from tested outcomes. Preserve user authorization, sensitive data, rollback options and the existing plan.
3. Read only the corresponding sections below before applying their examples.
4. Verify the result with meaningful positive, negative and failure controls. Record actual outcomes, limitations and next action.

## Selected references

- [When to Activate](references/procedure.md#when-to-activate) — read when this part of the task applies.
- [Overview](references/procedure.md#overview) — read when this part of the task applies.
- [Table Design Patterns](references/procedure.md#table-design-patterns) — read when this part of the task applies.
- [Query Optimization Patterns](references/procedure.md#query-optimization-patterns) — read when this part of the task applies.
- [Data Insertion Patterns](references/procedure.md#data-insertion-patterns) — read when this part of the task applies.
- [Materialized Views](references/procedure.md#materialized-views) — read when this part of the task applies.
- [Performance Monitoring](references/procedure.md#performance-monitoring) — read when this part of the task applies.
- [Common Analytics Queries](references/procedure.md#common-analytics-queries) — read when this part of the task applies.
- [Data Pipeline Patterns](references/procedure.md#data-pipeline-patterns) — read when this part of the task applies.
- [Best Practices](references/procedure.md#best-practices) — read when this part of the task applies.
- [Purpose](references/procedure.md#purpose) — read when this part of the task applies.
- [When NOT to use](references/procedure.md#when-not-to-use) — read when this part of the task applies.
- [Standards Cited](references/procedure.md#standards-cited) — read when this part of the task applies.
- [Anti-Patterns](references/procedure.md#anti-patterns) — read when this part of the task applies.

The [full procedure](references/procedure.md) preserves detailed examples and standards.
Load relevant excerpts rather than the entire reference. Runtime capabilities and higher-priority instructions govern imported templates.