{"id":"antrea-clickhouse-server","name":"clickhouse-server","homepage":"https://hub.docker.com/r/antrea/clickhouse-server","repo_url":"https://hub.docker.com/r/antrea/clickhouse-server","category":"databases","subcategories":[],"tags":["databases","olap","sql","analytics","columnar","database-server"],"what_it_does":"clickhouse-server is the server component of ClickHouse, a column-oriented DBMS that provides SQL query processing over large analytical datasets. It supports running as a standalone service with HTTP and native TCP interfaces for clients.","use_cases":["Real-time analytics and event/query workloads","Building analytical data warehouses and OLAP systems","Log and metric analytics at scale","High-performance aggregations and complex analytical queries","Data ingestion from multiple sources followed by fast querying"],"not_for":["Low-latency OLTP transactional workloads requiring heavy per-row updates","Use cases needing a single simple REST CRUD API (ClickHouse is primarily SQL/analytical)","Environments that cannot manage operational/configuration complexity"],"best_when":"You need fast OLAP queries and scalable analytical processing with SQL over columnar storage, and you can operate and secure a database server.","avoid_when":"You require strict transactional semantics and frequent point updates as the primary workload, or you need a fully managed service with minimal operational responsibility.","alternatives":["PostgreSQL (for OLTP/transactional workloads)","MySQL (for OLTP/transactional workloads)","Apache Druid","Apache Pinot","Amazon Redshift","Google BigQuery","Snowflake"],"af_score":40.0,"security_score":51.8,"reliability_score":47.5,"package_type":"mcp_server","discovery_source":["docker_mcp"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:44:18.883093+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":false,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["HTTP basic auth / user-password (server configuration dependent)","Client authentication via configured users/credentials (server configuration dependent)","IP/network-based access control (server configuration dependent)"],"oauth":false,"scopes":false,"notes":"ClickHouse auth is configured on the server (e.g., users/credentials, access controls). There is no standardized OAuth/scope model described in the provided content."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Open-source component; cost depends on your infrastructure and any managed/support offerings."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":40.0,"security_score":51.8,"reliability_score":47.5,"mcp_server_quality":0.0,"documentation_accuracy":35.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":45.0,"rate_limit_clarity":20.0,"tls_enforcement":60.0,"auth_strength":55.0,"scope_granularity":35.0,"dependency_hygiene":60.0,"secret_handling":50.0,"security_notes":"Security posture depends heavily on server configuration (TLS, authentication, authorization, network exposure). As a database server, it is sensitive to misconfiguration (open ports, weak credentials, overly permissive users). Provided information does not include concrete details on dependency scanning, secret handling guidance, or specific TLS/auth enforcement defaults.","uptime_documented":20.0,"version_stability":65.0,"breaking_changes_history":55.0,"error_recovery":50.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["SQL is powerful but can be expensive; agents may produce inefficient queries without guardrails (timeouts, limits, query budgeting).","Authentication and permissions are server-configured; agents may fail unexpectedly if users/roles/quotas aren’t provisioned.","Operational settings (resource limits, query limits, replication/sharding configuration) can affect behavior and stability of automated workloads."]}}