Provides ClickHouse schema, query, and ingestion optimization guidance.
npx skills add https://github.com/duyet/skills --skill clickhouse
Please help me install this Agent Skill. Skill: clickhouse Source: https://github.com/duyet/skills/tree/main/clickhouse Command: npx skills add https://github.com/duyet/skills --skill clickhouse
This Skill provides expert guidance to optimize ClickHouse schemas, queries, and data ingestion strategies, ensuring maximum performance and stability.
CREATE TABLE statement to ensure optimal ORDER BY and partitioning, or analyze a slow-running query to identify bottlenecks and suggest index improvements.Use the clickhouse skill to review the provided CREATE TABLE statement for best practices.
High-intent search queries and answers about installing and using this skill.
Optimize ClickHouse schema design by selecting appropriate table engines, data types, partitioning, and primary keys. This ensures maximum query performance and storage efficiency by aligning data layout with access patterns.
Tune slow ClickHouse queries by optimizing JOINs, aggregations, and index usage. Analyzing the query execution plan helps identify bottlenecks and suggests targeted index improvements for faster data retrieval.
Improve ClickHouse data ingestion performance through batching, mutations, and asynchronous inserts. These strategies optimize insert pipelines and maintain database stability during high-volume data writes.
Partitioning affects ClickHouse query optimization by limiting the data scanned during execution. Effective partitioning combined with an optimal ORDER BY key accelerates aggregations and improves overall query speed.
Use materialized views in ClickHouse to pre-compute and store aggregated query results. This technique significantly speeds up read performance for frequent, complex queries by processing data at insertion time.
ClickHouse JOIN operations cause performance bottlenecks when joining large, unoptimized tables. Applying JOIN optimization techniques and ensuring proper primary key alignment resolves memory overhead and execution delays.
GDSDNValidate DDL statement execution order in SQL migration files.
snoodleboot-ioDiagnose slow SQL queries with EXPLAIN ANALYZE and apply indexing optimizations.
gugug168Optimize ClickHouse schemas, queries, and ingestion for analytical workloads.
KimjimanGuide ClickHouse schema design, query optimization, and data ingestion patterns.