What clickhouse-local is

clickhouse-local is a ClickHouse tool for processing data without a server, so SQL can be run directly against files on a local machine as well as remote sources such as AWS S3. It handles format conversions and can be driven by configuration files, making it suitable for querying, converting and transforming data in place. The ClickHouse documentation maintains guidance on when to use clickhouse-local as opposed to a full ClickHouse server deployment. It is part of the wider ClickHouse project rather than a separate product.

  • SQL queries over local files
  • Reads remote sources such as AWS S3
  • Converts between data formats
  • Runs without a database server
  • Supports configuration files

Source: clickhouse-local - ClickHouse Documentation

Download and access

clickhouse-local is distributed as part of the standard ClickHouse binary, which is fetched with the command curl https://clickhouse.com/ | sh. The same downloaded binary can run the other ClickHouse tools and utilities. Users who want a database server rather than the local tool are directed to the ClickHouse Quick Start guide instead.

  • Download command: curl https://clickhouse.com/ | sh
  • One binary covers ClickHouse tools and utilities
  • Quick Start covers server deployment

Source: clickhouse-local - ClickHouse Documentation

Changes in ClickHouse 25.5

The June 2025 ClickHouse newsletter notes that release 25.5 made clickhouse-local easier to use by allowing FROM and SELECT to be skipped when reading from stdin. The same release moved the vector similarity index from experimental to beta, added Hive metastore catalog support and extended the Parquet reader to handle Geo types. These items are summarised in the newsletter alongside a link to the full release post.

  • Skip FROM and SELECT with stdin
  • Parquet reader handles Geo types
  • Released as part of ClickHouse 25.5

Source: June 2025 Newsletter | ClickHouse

Community and release communications

ClickHouse publishes a monthly newsletter that rounds up releases, engineering deep dives and community news, including updates affecting clickhouse-local. Each issue lists community calls, free training sessions and meetups across the Americas, EMEA and APAC. Monthly community calls accompany each version release.

  • Monthly ClickHouse newsletter
  • Versioned community calls, such as v25.6
  • Free virtual and in-person training sessions
  • Meetups and conference appearances worldwide

Sources: May 2025 Newsletter | ClickHouse, June 2025 Newsletter | ClickHouse

Sources

  1. Data warehousing with ClickHouse | ClickHouse https://clickhouse.com/use-cases/data-warehousing Verified 17 Sep 2026
  2. May 2025 Newsletter | ClickHouse https://clickhouse.com/blog/202505-newsletter Verified 14 Nov 2026
  3. June 2025 Newsletter | ClickHouse https://clickhouse.com/blog/202506-newsletter Verified 14 Nov 2026
  4. clickhouse-local - ClickHouse Documentation https://clickhouse.com/docs/concepts/features/tools-and-utilities/clickhouse-local Verified 02 Oct 2026

Last verified 01 Nov 2026. This entry is compiled from the public web pages listed above. Nothing here is stated that those pages do not, and each of them was read on the date shown.