How does it handle compression selection?

It provides a decision matrix for codecs, recommending Gorilla for floats, DoubleDelta for timestamps, and T64 for counters to balance compression ratios with read speed.

Does it support ClickHouse Cloud?

Yes, it includes specific architectural patterns for ClickHouse Cloud, including SharedMergeTree configurations and cloud-native scaling practices.

What version of ClickHouse does this skill support?

The skill is optimized for ClickHouse v24.4 and newer, covering modern features like SharedMergeTree and improved lightweight updates.

Can it help with DBeaver or User Management?

While this skill focuses on architecture, it acts as a hub that delegates user creation to clickhouse-cloud-management and client configuration to clickhouse-pydantic-config.

ClickHouse Architect

Name: ClickHouse Architect
Author: terrylica

byterrylica

•

数据库管理

Designs high-performance schemas and optimizes query structures for ClickHouse v24.4+ environments.

ClickHouse Architect is a specialized authority for data modeling and performance tuning within the ClickHouse ecosystem. It provides prescriptive guidance for both self-hosted (ReplicatedMergeTree) and Cloud (SharedMergeTree) deployments, focusing on critical optimizations like ORDER BY key selection, column-specific compression codecs, and efficient partitioning strategies. By enforcing modern best practices and avoiding common anti-patterns like part fragmentation, this skill ensures your analytical databases are built for ultra-low latency and maximum storage efficiency.

主要功能

01Prescriptive ORDER BY key selection based on column cardinality

022 GitHub stars

03Automated anti-pattern detection for modern ClickHouse versions

04Lifecycle-aware PARTITION BY strategy design

05Performance acceleration via Projections and Materialized Views

06Smart compression codec mapping (Gorilla, DoubleDelta, ZSTD, LZ4)

使用场景

01Designing real-time analytical schemas for high-volume telemetry data

02Architecting migrations from self-hosted clusters to ClickHouse Cloud

03Optimizing existing table structures to reduce memory usage and query time

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add terrylica/cc-skills clickhouse-architect

For use in Claude.ai and ChatGPT

Download Skill