Clickhouse Best Practices
作者 ClickHouse2f6ec4b17a81Apache-2.0544 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫9 天前更新
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.
僅公開檔案列表。將技能安裝到工作區後即可檢視檔案內容。
| 路徑 | 大小 | 類型 |
|---|---|---|
| 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 |
來源與署名
來源：ClickHouse/agent-skills位於skills/clickhouse-best-practices提交2f6ec4b
授權條款： Apache-2.0
內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。
更多來自 ClickHouse/agent-skills 的技能
Clickhouse Managed Postgres Rca
ClickHouse
針對 ClickHouse 代管 Postgres 執行個體效能問題、以證據為基礎的根因分析工作流程。
Clickhouse Js Node Troubleshooting
ClickHouse
排查並解決 ClickHouse Node.js 客戶端（@clickhouse/client）的常見錯誤與設定問題。
Clickhouse Architecture Advisor
ClickHouse
針對特定工作負載指導 ClickHouse 架構決策，並將每項建議標註為官方、推導或經驗。
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
使用 chdb DataStore 作為 pandas 的替代方案，以 ClickHouse 為底層查詢、合併與彙總表格資料。
更多Data & Analytics技能
Spanner Basics
指導 Google Cloud Spanner 的執行個體與資料庫管理、結構定義設計、查詢與效能診斷。
Gke Cost Analysis
使用 BigQuery 帳單匯出資料與即時叢集指標，回答關於 GKE 叢集與工作負載成本的自然語言問題。
Datalineage Bigquery Asset Impact Analysis
引導代理使用資料血緣對 BigQuery 資料表或檢視表進行下游影響（爆炸半徑）分析。
Bigquery Troubleshooting
透過結構化根因工作流程診斷失敗、緩慢或費用異常的 BigQuery 作業。
Bigquery Optimization
指導 BigQuery 在容量版本、儲存配置與 SQL 查詢方面的成本與效能最佳化。
Bigquery Bigframes
指導使用 BigQuery DataFrames（BigFrames）撰寫 Python 程式碼，用於資料處理、分析與機器學習。