clickhouse
CommunityOptimize ClickHouse performance and reliability.
Software Engineering#performance#schema design#data ingestion#query tuning#database optimization#clickhouse
Authorduyet
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides expert guidance to optimize ClickHouse schemas, queries, and data ingestion strategies, ensuring maximum performance and stability.
Core Features & Use Cases
- Schema Design: Best practices for table engines, data types, partitioning, and primary keys.
- Query Optimization: Techniques for efficient JOINs, aggregations, and index usage.
- Data Ingestion: Strategies for batching, mutations, and asynchronous inserts.
- Use Case: Review a complex
CREATE TABLEstatement to ensure optimalORDER BYand partitioning, or analyze a slow-running query to identify bottlenecks and suggest index improvements.
Quick Start
Use the clickhouse skill to review the provided CREATE TABLE statement for best practices.
Dependency Matrix
Required Modules
None requiredComponents
referencesscripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: clickhouse Download link: https://github.com/duyet/skills/archive/main.zip#clickhouse Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.