clickhouse-prod-checklist

Featured

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification. Use when launching a ClickHouse deployment, doing go-live reviews, or auditing production readiness. Trigger: "clickhouse production", "clickhouse go-live", "clickhouse launch checklist", "production clickhouse", "clickhouse prod ready".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# ClickHouse Production Checklist ## Overview Comprehensive go-live checklist for ClickHouse covering server tuning, schema design, backup configuration, monitoring, and operational readiness. ## Prerequisites - ClickHouse instance provisioned (Cloud or self-hosted) - Application integration code tested in staging ## Checklist ### 1. Schema & Engine Design - [ ] Tables use `MergeTree` family engines (not `Memory`, `Log`, or `TinyLog`) - [ ] `ORDER BY` columns match primary filter/group patterns - [ ] `PARTITION BY` is coarse (monthly or weekly, never by ID) - [ ] `TTL` configured for data retention policy - [ ] `LowCardinality(String)` used for low-cardinality columns - [ ] `CODEC(ZSTD)` applied to large String/JSON columns - [ ] ReplacingMergeTree used with `FINAL` or dedup logic if upserts needed ### 2. Server Configuration (Self-Hosted) ```xml <!-- Key production settings in config.xml / users.xml --> <!-- Memory: set to ~80% of available RAM --> <max_server_memory_usage_to_ram_ratio>0.8</max_server_memory_usage_to_ram_ratio> <!-- Query limits --> <max_concurrent_queries>150</max_concurrent_queries> <max_memory_usage>10000000000</max_memory_usage> <!-- 10GB per query --> <max_execution_time>300</max_execution_time> <!-- 5 min timeout --> <!-- Merge settings --> <background_pool_size>16</background_pool_size> <background_schedule_pool_size>16</background_schedule_pool_size> <!-- Logging --> <query_log> <database>system</database> <table>query_log...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category