--- title: Monitor SLAs and scale ClickHouse Cloud with... description: A practical guide to monitoring per-workload SLAs in ClickHouse Cloud by tagging queries with log_comment, then using clickhousectl to query system.query_log... canonical: https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents | daily.dev og:description: A practical guide to monitoring per-workload SLAs in ClickHouse Cloud by tagging queries with log_comment, then using clickhousectl to query system.query_log... og:url: https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9 og:image: https://api.daily.dev/og/posts/xQwvt9vt9.png og:image:alt: Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents **[ClickHouse](https://daily.dev/sources/clickhouse)** · 8 min read · 1 upvotes · 0 comments ## Summary A practical guide to monitoring per-workload SLAs in ClickHouse Cloud by tagging queries with log_comment, then using clickhousectl to query system.query_log and Prometheus metrics to investigate latency breaches. Covers horizontal and vertical scaling via clickhousectl, a simple bash cron for automated SLA checks, and an advanced pattern where an LLM agent (Claude) is given context about the breach and uses clickhousectl tools to diagnose root cause and apply the appropriate scaling action. Includes guidance on reading CPU, memory, and concurrency metrics to decide between adding replicas vs. upsizing them. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [More Visibility, Less Guesswork: ClickHouse Cloud's New Monitoring Capabilities](https://daily.dev/posts/more-visibility-less-guesswork-clickhouse-cloud-s-new-monitoring-capabilities-6cq1aydzj) · ClickHouse · 0 upvotes · 0 comments - [ClickHouse: Production Monitoring & Optimization Tips](https://daily.dev/posts/clickhouse-production-monitoring-optimization-tips-b06lppnki) · BigData Boutique blog · 5 upvotes · 0 comments - [How Langfuse is scaling LLM observability for the agentic era with ClickHouse Cloud](https://daily.dev/posts/how-langfuse-is-scaling-llm-observability-for-the-agentic-era-with-clickhouse-cloud-dejd2mins) · ClickHouse · 3 upvotes · 0 comments - [Fixed cadence to seconds: making ClickHouse Cloud autoscaling more reactive](https://daily.dev/posts/fixed-cadence-to-seconds-making-clickhouse-cloud-autoscaling-more-reactive-mrdritdf5) · ClickHouse · 2 upvotes · 0 comments - [ClickHouse Monitoring: Best Tools Compared for Production \(2026\)](https://daily.dev/posts/clickhouse-monitoring-best-tools-compared-for-production-2026--0ujixmgt1) · BigData Boutique blog · 2 upvotes · 0 comments --- Tags: [#ai-agents](https://daily.dev/tags/ai-agents), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents","url":"https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9"},"datePublished":"2026-06-08T16:30:53.798Z","dateModified":"2026-06-08T16:31:26.849Z","description":"A practical guide to monitoring per-workload SLAs in ClickHouse Cloud by tagging queries with log_comment, then using clickhousectl to query system.query_log...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/46e1f60c4adf5abf2c36a081e447184b?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/46e1f60c4adf5abf2c36a081e447184b?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/monitor-slas-and-scale-clickhouse-cloud-with-clickhousectl-and-agents-xqwvt9vt9","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"ai-agents,clickhouse","timeRequired":"PT8M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents"}]} ```