Dory ClickHouse Database Support
ClickHouse is one of Dory's deepest database integrations. In addition to SQL Console, Explorer, AI Chat, and charts, Dory provides ClickHouse-specific monitoring and privilege management.
Best-Fit Use Cases
- Product event analytics.
- Log, tracing, and observability data exploration.
- Large-scale detail-table analysis.
- Slow query and error query investigation.
- ClickHouse user, role, and grant management.
Supported Capabilities
| Capability | ClickHouse support |
|---|---|
| SQL Console | Write, run, and iterate ClickHouse SQL. |
| Explorer | Browse databases, tables, views, columns, DDL, partition keys, and sorting keys. |
| AI Chat | Generate, explain, fix, and optimize SQL with ClickHouse schema context. |
| Charts & Results | Turn query results into trends, comparisons, and detail views. |
| Monitoring | Inspect total queries, slow queries, errors, P50 / P95 latency, and QPM. |
| Privileges | Manage users, roles, global privileges, and scoped grants. |
Connection Requirements
Prepare the ClickHouse host, port, database, username, password, TLS setting, and any required SSH tunnel details. ClickHouse Cloud connections commonly require SSL.
Recommended Flow
- Open Connections.
- Choose ClickHouse.
- Enter host, port, HTTP port, database, username, and password.
- Enable SSL if your deployment requires TLS.
- Test and save the connection.
- Open SQL Console or Explorer.
AI Query Tips
When asking AI to generate ClickHouse SQL, include the time range, metrics, target table, grouping dimensions, and any function preferences such as toStartOfHour, quantile, or uniq.
ClickHouse Monitoring
Dory can show ClickHouse monitoring views when the connected user can read the required system tables. Use these views to inspect recent queries, slow queries, errors, latency, and QPM.
ClickHouse Privilege Management
When permissions are available, Dory can help review users, roles, global privileges, and scoped grants for ClickHouse environments.
FAQ
Why does my ClickHouse connection fail?
Check the host, port, username, password, TLS setting, and network allowlist. For ClickHouse Cloud, SSL is usually required.
Why is Monitoring empty?
The current user may not have permission to read ClickHouse system tables, or the selected time range may not contain query records.
Why does AI-generated ClickHouse SQL need edits?
ClickHouse functions and syntax can vary by version and deployment. Verify generated SQL against your schema and run a small preview before using it for production analysis.