Clickhouse Best Practices
by ClickHouse2f6ec4b17a81Apache-2.0544 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 9 days ago
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| AGENTS.md | 62.1 KB | text/markdown |
| metadata.json | 643 B | application/json |
| README.md | 1.8 KB | text/markdown |
| rules/agent-connect-mcp.md | 4.4 KB | text/markdown |
| rules/agent-discovery-schema.md | 5.7 KB | text/markdown |
| rules/agent-query-safety.md | 5.2 KB | text/markdown |
| rules/insert-async-small-batches.md | 1.8 KB | text/markdown |
| rules/insert-batch-size.md | 1.5 KB | text/markdown |
| rules/insert-format-native.md | 933 B | text/markdown |
| rules/insert-mutation-avoid-delete.md | 2 KB | text/markdown |
| rules/insert-mutation-avoid-update.md | 2.1 KB | text/markdown |
| rules/insert-optimize-avoid-final.md | 1.9 KB | text/markdown |
| rules/query-index-skipping-indices.md | 2.4 KB | text/markdown |
| rules/query-join-choose-algorithm.md | 1.8 KB | text/markdown |
| rules/query-join-consider-alternatives.md | 2.1 KB | text/markdown |
| rules/query-join-filter-before.md | 1.3 KB | text/markdown |
| rules/query-join-null-handling.md | 1 KB | text/markdown |
| rules/query-join-use-any.md | 1.1 KB | text/markdown |
| rules/query-mv-incremental.md | 2 KB | text/markdown |
| rules/query-mv-refreshable.md | 2 KB | text/markdown |
| rules/schema-json-when-to-use.md | 2 KB | text/markdown |
| rules/schema-partition-lifecycle.md | 1.5 KB | text/markdown |
| rules/schema-partition-low-cardinality.md | 1.6 KB | text/markdown |
| rules/schema-partition-query-tradeoffs.md | 1.1 KB | text/markdown |
| rules/schema-partition-start-without.md | 1.2 KB | text/markdown |
| rules/schema-pk-cardinality-order.md | 1.6 KB | text/markdown |
| rules/schema-pk-filter-on-orderby.md | 1.5 KB | text/markdown |
| rules/schema-pk-plan-before-creation.md | 2 KB | text/markdown |
| rules/schema-pk-prioritize-filters.md | 1.2 KB | text/markdown |
| rules/schema-types-avoid-nullable.md | 1.8 KB | text/markdown |
| rules/schema-types-enum.md | 1.7 KB | text/markdown |
| rules/schema-types-lowcardinality.md | 1.7 KB | text/markdown |
| rules/schema-types-minimize-bitwidth.md | 1.4 KB | text/markdown |
| rules/schema-types-native-types.md | 1.8 KB | text/markdown |
| rules/_sections.md | 1.8 KB | text/markdown |
| rules/_template.md | 624 B | text/markdown |
| SKILL.md | 10.1 KB | text/markdown |
Source and attribution
Source:ClickHouse/agent-skillsinskills/clickhouse-best-practicesat commit2f6ec4b
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from ClickHouse/agent-skills
Clickhouse Managed Postgres Rca
ClickHouse
Evidence-based root cause analysis workflow for performance issues on ClickHouse-managed Postgres instances.
Clickhouse Js Node Troubleshooting
ClickHouse
Troubleshoots common errors and configuration issues with the ClickHouse Node.js client (@clickhouse/client).
Clickhouse Architecture Advisor
ClickHouse
Guides ClickHouse architecture decisions for specific workloads, labeling each recommendation as official, derived, or field.
Chdb Sql
ClickHouse
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ functions, Session for stateful multi-step pipelines, parametrized queries, and cross-source joins via `s3()`, `mysql()`, `postgresql()`, `iceberg()`, `deltaLake()`, `remoteSecure()` table functions. TRIGGER when: user wants SQL on parquet/csv/files or across remote analytical sources; uses ClickHouse SQL features (window functions, windowFunnel, geoToH3, JSON path ops, Session, parametrized queries); imports `chdb` or calls `chdb.query()`. SKIP this skill for pandas-style DataFrame method-chaining (use chdb-datastore instead) or ClickHouse server administration.
Chdb Datastore
ClickHouse
Use chdb DataStore as a drop-in, ClickHouse-backed replacement for pandas to query, join and aggregate tabular data.
More in Data & Analytics
Spanner Basics
Guides Google Cloud Spanner administration, schema design, querying and performance diagnosis.
Gke Cost Analysis
Answers natural-language questions about GKE cluster and workload costs using BigQuery billing exports and live cluster metrics.
Datalineage Bigquery Asset Impact Analysis
Guides an agent through downstream impact (blast radius) analysis for a BigQuery table or view using Data Lineage.
Bigquery Troubleshooting
Diagnoses failing, slow, or unexpectedly expensive BigQuery jobs through structured root-cause workflows.
Bigquery Optimization
Guides BigQuery cost and performance optimization across capacity editions, storage layout, and SQL queries.
Bigquery Bigframes
Guides writing Python code with BigQuery DataFrames (BigFrames) for data processing, analysis, and machine learning.