clickhouse
Installation
SKILL.md
ClickHouse
ClickHouse is an open-source, column-oriented database for real-time analytics at scale, built to run aggregations over billions of rows in milliseconds. It powers observability platforms, product and web analytics, data warehousing, time-series and ML workloads, and increasingly the data layer behind AI agents.
Products
- ClickHouse: the open-source column-oriented database for real-time analytics.
- ClickHouse Cloud: the fully managed service for both ClickHouse and Postgres. Handles scaling, backups, upgrades, security, and enterprise operations.
- Postgres: fully managed Postgres in ClickHouse Cloud.
- ClickStack: open-source observability stack built on OpenTelemetry, ClickHouse, and HyperDX for logs, metrics, and traces. Also available as a managed service in ClickHouse Cloud.
- chDB: in-process ClickHouse: an embeddable SQL engine you can run inside Python and other languages with no server.
- ClickPipes: managed, continuous data ingestion into ClickHouse Cloud from Kafka, object storage, Postgres, and more.
- Langfuse: open-source LLM engineering and observability platform, backed by ClickHouse.
- clickhousectl: the official CLI for ClickHouse, for both local and Cloud. Supports ClickHouse, Postgres and ClickPipes.
- Agentic data stack: ClickHouse + LibreChat + the ClickHouse MCP server + Langfuse for building AI-native data applications.