{"id":"clickhouse-api","name":"ClickHouse","af_score":67.0,"security_score":80.0,"reliability_score":null,"what_it_does":"ClickHouse is a blazing-fast open-source columnar OLAP database designed for real-time analytics over massive datasets. It stores data in column-oriented format with aggressive compression, enabling queries that scan billions of rows per second. ClickHouse accepts SQL via an HTTP interface (port 8123/8443) and a native binary protocol (port 9440), with support for many input/output formats (JSON, CSV, Parquet, Arrow). ClickHouse Cloud is the managed offering with a REST Management API for programmatic cluster management. The HTTP interface supports streaming responses, progress headers, and session-based queries — making it well-suited for agents that need to run complex analytical queries.","best_when":"You need to run fast analytical queries over large volumes of immutable or append-only event/log data, especially when time-series patterns, aggregations over billions of rows, or real-time ingestion are requirements.","avoid_when":"You need frequent row-level updates, complex multi-table transactions, or a general-purpose OLTP database.","last_evaluated":"2026-03-01T09:50:05.388971+00:00"}