Most teams use external BI tools like Grafana or Metabase to visualize ClickHouse® data. That means another tool to deploy, configure, and maintain. CHOps includes a dashboard builder that works directly on your ClickHouse® database.
Your first dashboard in 5 minutes
Every CHOps dashboard starts with a SQL query. Write the query, pick a chart type, and the visualization appears. Drag it to position, resize it, and add more charts. No configuration files, no data source setup, no plugins.
Choosing the right chart type
CHOps supports 12+ chart types. Matching the right chart to your data matters:
Time series data (query latency over time, requests per second): use line charts. Add multiple series to compare nodes or time periods.
Categorical comparisons (queries by user, tables by size): use bar charts. Horizontal bars work better when category names are long.
Proportions (disk usage by table, queries by type): use pie or donut charts. Keep segments to 5-7 maximum for readability.
Distributions (query duration percentiles, memory usage patterns): use box plots or histograms.
Relationships (two correlated metrics): use scatter plots.
Hierarchies (data flow through pipeline stages): use sankey or treemap charts.
SQL patterns for dashboards
A few SQL patterns make dashboards more useful:
Rolling averages smooth out noise. Use avgIf with a time window to show trends instead of spiky raw data.
Comparison periods show change over time. Query the current period and the same period last week side by side.
Top N with "other" prevents charts from becoming unreadable. Group everything outside the top 10 into an "Other" category.
Auto-refresh for monitoring
Set dashboards to auto-refresh at intervals: every 10 seconds for real-time monitoring, every 5 minutes for operational views, every hour for business dashboards. CHOps manages the query scheduling without external cron jobs.
AI-assisted chart building
Not sure which query to write? Describe what you want to see in plain English. CHOps generates the SQL, picks an appropriate chart type, and maps the columns. For example, "show me query latency by hour for the last 7 days" produces a time series chart from system.query_log.
Scheduled reports with CHOps Pro
CHOps Pro adds scheduled email reports. Define a SQL query and a cron schedule, and the results are emailed as a formatted HTML table. Perfect for daily operations summaries, weekly performance digests, or monthly capacity reports that stakeholders want in their inbox without logging into a dashboard.
