clickhouse-prod-checklist

name	clickhouse-prod-checklist
description	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".
allowed-tools	Read, Bash(kubectl:*), Bash(curl:*), Grep
version	1.0.0
license	MIT
author	Jeremy Longshore <[e-mail]>
tags	["saas","database","analytics","clickhouse","olap"]
compatible-with	claude-code

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)

<!-- 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>       


16
16



    system
    query_log
    7500