{"id":"yandex-clickhouse-server","name":"clickhouse-server","af_score":33.8,"security_score":56.0,"reliability_score":31.2,"what_it_does":"ClickHouse Server is a high-performance columnar database server for analytical workloads, providing SQL query processing, distributed storage/replication features, and support for streaming/ingesting data at scale.","best_when":"You need fast analytical SQL over large datasets (often time-series/event data), and you can operate and secure database infrastructure.","avoid_when":"You need a simple plug-and-play HTTP API service with minimal operational overhead, or you require strict transactional consistency typical of OLTP systems.","last_evaluated":"2026-03-30T13:28:33.150757+00:00","has_mcp":false,"has_api":false,"auth_methods":["User accounts and credentials configured on the server (e.g., via ClickHouse user configuration)","Network-level controls (firewall/VPC) as part of access control"],"has_free_tier":false,"known_gotchas":["Agents must construct safe SQL; query correctness and performance tuning (indexes/partitions) are critical.","Operational prerequisites (users/roles, network exposure, and secure configuration) are required before an agent can reliably query.","Long-running queries and resource limits can cause timeouts; agents need to handle query failures and cancellations appropriately."],"error_quality":0.0}