ClickHouse Utility

• clickhouse-local — Allows running SQL queries on data without stopping the ClickHouse server, similar to how awk does this.
• clickhouse-copier — Copies (and reshards) data from one cluster to another cluster.
• clickhouse-benchmark — Loads server with the custom queries and settings.

Original article