| name | clickhouse-prod-checklist |
| description | Production readiness checklist for ClickHouse — server tuning, backup,
monitoring, and deployment verification.
Use when launching a ClickHouse deployment, doing a go-live review,
or auditing production readiness before flipping traffic.
Trigger with "clickhouse production", "clickhouse go-live",
"clickhouse launch checklist", "production clickhouse",
"clickhouse prod ready".
|
| allowed-tools | Read, Bash(clickhouse-client:*), Bash(curl:*) |
| version | 1.7.0 |
| license | MIT |
| author | Jeremy Longshore <jeremy@intentsolutions.io> |
| tags | ["saas","database","analytics","clickhouse","olap"] |
| compatibility | Designed for Claude Code |
ClickHouse Production Checklist
Overview
Comprehensive go-live checklist for ClickHouse covering schema and engine design,
server tuning, backup configuration, monitoring, security, application
integration, and operational readiness. Walk the eight sections top to bottom;
each is a gate that must be green before production traffic is allowed. Deep
configuration — server XML, backup SQL, and verification queries — lives in
references/ so this file stays a fast operational scan.
Prerequisites
Before starting the checklist, confirm the following are in place:
- A ClickHouse instance is provisioned (ClickHouse Cloud or self-hosted) and
reachable from the environment you will run traffic from.
- Application integration code has been exercised end-to-end in a staging
environment against a ClickHouse of the same major version.
- You have admin credentials able to read
system.* tables and, for
self-hosted, edit config.xml / users.xml.
Instructions
Work each section in order. Every box must be checked (or explicitly waived with
a reason) before go-live.
1. Schema & Engine Design
2. Server Configuration (Self-Hosted)
Set memory to ~80% of RAM, cap per-query memory and execution time, and size the
merge pools to the core count. ClickHouse Cloud manages these for you.
<max_server_memory_usage_to_ram_ratio>0.8
150
300
