# Clickhouse

> ClickHouse OLAP column-store database reference. Covers SQL analytics queries, MergeTree engine family, ReplacingMergeTree, materialized views, distributed tables, real-time aggregation, data types, HTTP API, monitoring, backup, and performance tuning.

- Skill: `bytesagain/clickhouse` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add bytesagain/clickhouse`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bytesagain/clickhouse/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: bytesagain (https://skillmd.com/u/bytesagain)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/bytesagain/clickhouse

---


# ClickHouse Reference

Fastest open-source OLAP database.

## Commands

| Command | Description |
|---------|-------------|
| `intro` | Overview, comparison |
| `sql` | Queries, analytics, types |
| `engines` | MergeTree, replication, views |
| `operations` | Install, monitor, backup |