chouse-ui

Rules and strategies for exploring databases, tables, schemas, and searching metadata.

Complex rules for calling render_chart, inferring axes, and choosing chart types based on user intent.

Diagnose a ClickHouse server error (code/name/exception) and give a concrete, actionable fix.

Diagnose part/partition health of a MergeTree table — too many parts, slow/stuck merges, bad partition key.

Rules for using explain/analyze/optimize tools to help the user tune their queries.

Diagnose a column/table schema issue — Nullable overhead, oversized integer, or weak compression — and propose an ALTER.

Strict rules on outputting ClickHouse syntax, limiting rows, and rendering SQL in markdown.

Diagnose server-state issues using running queries, slow-query history, and server info.

Detailed instructions and rules for debugging and fixing failed ClickHouse SQL queries. Focuses on diagnosing syntax errors, type mismatches, and ClickHouse-specific issues using all available schema and query tools.

Lightweight rules for determining if a ClickHouse SQL query has obvious inefficiencies or if it is already optimal and should be skipped for optimization.

Detailed instructions and rules for optimizing ClickHouse SQL queries. Focuses on performance tuning, data pruning, and ClickHouse-specific strategies using all available schema and query tools.

ClickHouse optimization and operational playbook with concrete patterns for query rewrites, MergeTree design, joins, PREWHERE, argMax, mutations, merges, and memory pressure.

Exact ClickHouse system table and column reference for safe system.* diagnostics.

ClickHouse type sizing, Nullable, LowCardinality, codec, compression, and column storage guidance.