altinity-expert-clickhouse-schema
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
Full skill instructions
Analyze table structure, partitioning, ORDER BY, materialized views, and identify design anti-patterns.
Run all queries from the file checks.sql and analyze the results.
select
database,
table,
count() as partitions,
sum(rows) as total_rows,
formatReadableSize(sum(bytes_on_disk)) as total_size,
formatReadableSize(median(bytes_on_disk)) as median_partition_size,
min(partition) as oldest_partition,
max(partition) as newest_partition
from system.parts
where active and database = '{database}' and table = '{table}'
group by database, table, partition
order by partition desc
limit 100
select
name,
type,
formatReadableSize(data_compressed_bytes) as compressed,
formatReadableSize(data_uncompressed_bytes) as uncompressed,
round(data_uncompressed_bytes / nullIf(data_compressed_bytes, 0), 2) as ratio,
compression_codec
from system.columns
where database = '{database}' and table = '{table}'
order by data_compressed_bytes desc
limit 50
Look for:
select
database,
table,
name as index_name,
type,
expr,
granularity
from system.data_skipping_indices
where database = '{database}'
order by database, table
| Data Volume | Recommended Granularity | Example |
|---|---|---|
| < 10GB/month | No partitioning or yearly | toYear(ts) |
| 10-100GB/month | Monthly | toYYYYMM(ts) |
| 100GB-1TB/month | Weekly or daily | toMonday(ts) |
| > 1TB/month | Daily | toDate(ts) |
tenant_id, region)Anti-patterns:
| Data Type | Recommended Codec |
|---|---|
| Integers (sequential) | Delta, ZSTD |
| Integers (random) | ZSTD or LZ4HC |
| Floats | Gorilla, ZSTD |
| Timestamps | DoubleDelta, ZSTD |
| Strings (long) | ZSTD(3) |
| Strings (repetitive) | LowCardinality + ZSTD |
| Finding | Load Module | Reason |
|---|---|---|
| Many small partitions | altinity-expert-clickhouse-ingestion | Check batch sizing |
| Oversized partitions | altinity-expert-clickhouse-merges | Merge can't complete |
| High PK memory | altinity-expert-clickhouse-memory | Memory pressure |
| MV performance issues | altinity-expert-clickhouse-reporting | Query analysis |
| Too many parts per partition | altinity-expert-clickhouse-merges | Merge backlog |
| Setting | Default | Recommendation |
|---|---|---|
index_granularity | 8192 | Lower for point lookups, higher for scans |
ttl_only_drop_parts | 0 | Set to 1 if TTL deletes entire partitions |
min_bytes_for_wide_part | 10MB | Increase if many small parts |
Comprehensive DevOps and deployment workflow that orchestrates infrastructure automation, CI/CD pipelines, container orchestration, and cloud deployment. Handles everything from infrastructure as code and pipeline setup to monitoring, scaling, and disaster recovery.
Integrate avnu SDK for Starknet DeFi: token swaps with best-price routing, DCA recurring buys, native staking, gasless transactions via paymaster, and market data. Use when building Starknet trading, DEX aggregation, or DeFi automation features.
发布内容和文章到 X (Twitter)。支持带图片的普通推文和 X Articles（长文）。使用真实的 Chrome 和 CDP 来绕过自动化检测。
Master orchestrator for generating Ralph Wiggum-compatible prompts. Analyzes task requirements and routes to appropriate generator (single-task, multi-task, project, or research). Use when you need to create any Ralph loop prompt and want automatic selection of the right generator.
Use when the user asks to compare branches, analyze git diffs, review changes between branches, update specifications based on code changes, or analyze what changed. Triggers on keywords like "compare branches", "git diff", "what changed", "branch comparison", "code changes", "spec update".
Build high-performance FastAPI applications with async routes, validation, dependency injection, security, and automatic API documentation. Use when developing modern Python APIs with async support, automatic OpenAPI documentation, and high performance requirements.
Enables Claude to manage Zendesk Chat conversations, support tickets, and customer service operations
Mine transcripts for knowledge - decisions, learnings, failures, patterns. Triggers: "forge insights", "mine transcripts", "extract knowledge".
Track product analytics and user behavior with Mixpanel's event-based platform.
OCPP protocol reference for EV charging infrastructure development. Covers OCPP 2.0.1 and OCPP 1.6J. Use when working with OCPP messages, charging station code, CSMS/Central System backends, smart charging, transaction handling, or EV charging protocols. Activates on keywords: OCPP, charging stat...
Gather scattered ideas into organized GitHub issues. The bee collects pollen from every flower, checks if the hive already has it, and carefully deposits new work in the comb for later. Never edits code—only organizes the work ahead. Use when creating issues from TODOs or planning work.
Comprehensive best practices for React Native and Expo applications. Contains rules across multiple categories covering performance, animations, UI patterns, and platform-specific optimizations.
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience