# Install clickhouse with Homebrew Cask Column-oriented database management system. Version 26.8.6.5-lts via Homebrew Cask; verified 2026-09-18. Also installable with nix: nix profile install nixpkgs#clickhouse. ## Install ```sh sudo av install cask:clickhouse ``` Additional install commands: ### macOS - Homebrew Cask (100%): ```sh brew install --cask clickhouse ``` Evidence: local Homebrew cask metadata ## Package facts - **Package key:** cask:clickhouse - **Package manager:** Homebrew Cask - **Package manager page:** - **Version:** 26.8.6.5-lts - **Source summary:** Column-oriented database management system - **Homepage:** - **Repository:** - **Upstream docs:** - **Source archive:** - **Last updated:** 2026-09-18T15:49:00Z - **Generated:** 2026-09-19T06:45:57+00:00 ## Executables - clickhouse (binary) - clickhouse (alias) ## Install behavior - Post-install hook: not defined - Bottle: not available ## Freshness - Page generated: 2026-09-19 - Package-manager version: 26.8.6.5-lts - Package-manager updated: 2026-09-18 - Local data: ok - Upstream repository: https://github.com/ClickHouse/ClickHouse - info: No cached GitHub release or tag data was available. ## Project history and usage ClickHouse is a column-oriented analytical database created for fast aggregation over large, continuously arriving datasets. It began inside Yandex's web-analytics infrastructure, entered production in 2012, and became open source in 2016. ### Project history Alexey Milovidov began the work that became ClickHouse while developing web-analytics infrastructure at Yandex. The first repository commit dates to May 2009; the server and client appeared in 2012, and MergeTree-based storage subsequently became central to production use. Yandex released ClickHouse as open source under the Apache 2.0 license on 15 June 2016. Development continued publicly with a large contributor community and regular releases, while ClickHouse Inc. later developed a commercial managed-cloud offering around the same database. ### Adoption history ClickHouse was first deployed internally for log processing in 2012. By 2014 it powered Yandex.Metrica and had spread to other internal teams; CERN was an early external deployment. Its adoption widened after the 2016 open-source release, particularly for observability, event analytics, data warehousing, and other high-volume analytical workloads. ### How it is used Operators use ClickHouse for real-time analytics, observability data, event streams, data warehouses, and large-scale reporting. The packaged executable can support client and local workflows, while server deployments use XML configuration and typically require deliberate storage, networking, authentication, and resource-limit configuration. ### Why package nerds care ClickHouse is notable to package enthusiasts because one distribution supplies server, client, and local analytical workflows, while its rapid release cadence and performance-oriented native binaries make versioning and platform packaging unusually visible. It is also a prominent example of infrastructure software moving from an internal web-analytics system to a broadly deployed open-source database. ### Timeline - 2009: First commit in the codebase that became ClickHouse. - 2012: ClickHouse server and client entered production use for log processing. - 2014: ClickHouse powered Yandex.Metrica and spread to additional internal workloads. - 2016: Yandex released ClickHouse as open source under Apache 2.0. - 2026: ClickHouse marked ten years as an open-source project. ### Related projects - ClickHouse Cloud is the vendor-managed service built around ClickHouse. - ClickHouse integrations commonly connect the database to ingestion, visualization, migration, and client-driver ecosystems. ### Sources - Official ClickHouse documentation: https://clickhouse.com/docs - Official ClickHouse retrospective: https://clickhouse.com/blog/open-source-10 - source_facts.description - source_facts.repo ## Security Notes No matching local secret-handling manifest was found for clickhouse. Package metadata is still published here so future coverage has a stable package URL. ## Configuration and credential file locations These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval. ## Configuration files - Unix: /etc/clickhouse-server/config.xml, /etc/clickhouse-server/config.d/*.xml, ~/.clickhouse-client/config.xml ## Credential files - Unix: /etc/clickhouse-server/users.xml, /etc/clickhouse-server/users.d/*.xml ## Source Database Details - **Source Database:** Homebrew cask API - **Tap:** homebrew/cask - **Full Token:** clickhouse - **Names:** ClickHouse - **Artifacts:** Binary: 1, Target: 1 - **Deprecated:** no - **Disabled:** no ## Other Package-Manager Records - Nix - clickhouse: normalized package name match | nixpkgs package indexes: pkgs/by-name/cl/clickhouse/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - clickhouse-client - 18.16.1+ds-7.4build2: normalized package name match | Ubuntu 24.04 LTS package indexes: clickhouse-client from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | column-oriented database system (cli client) | https://clickhouse.yandex/ - Ubuntu apt - clickhouse-common - 18.16.1+ds-7.4build2: normalized package name match | Ubuntu 24.04 LTS package indexes: clickhouse-common from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | column-oriented database system (common files) | https://clickhouse.yandex/ - Ubuntu apt - clickhouse-server - 18.16.1+ds-7.4build2: normalized package name match | Ubuntu 24.04 LTS package indexes: clickhouse-server from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | column-oriented database system (server runner) | https://clickhouse.yandex/ - Ubuntu apt - clickhouse-tools - 18.16.1+ds-7.4build2: normalized package name match | Ubuntu 24.04 LTS package indexes: clickhouse-tools from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | column-oriented database system (tools) | https://clickhouse.yandex/ ## Related links - [Homebrew Cask packages](https://pkg.so/homebrew-cask-packages/) - Generated from Homebrew Cask package-manager metadata. - [Homebrew Cask binaries](https://pkg.so/homebrew-cask-binaries/) - Cask artifact metadata includes a binary. ## Combined YAML source View the package source record on GitHub. [combined/clickhouse.yml](https://github.com/mxcl/pkgdb/blob/main/combined/clickhouse.yml) ## Sources - pkg.so package database - package-page enrichment - curated configuration and credential file locations - curated package history - package version freshness - package relationship graph - external package-manager database matches - cross-ecosystem install command graph