hardware-tuning

What problem does it solve?

Manually tuning ClickHouse server settings without accounting for underlying hardware leads to suboptimal query performance, out-of-memory errors, or wasted system resources from overprovisioned configurations.

Core Features & Use Cases

• Hardware Detection: Automatically identifies server CPU core count, total/available RAM, and disk layout directly from ClickHouse system tables, with fallbacks for version differences in metric names.
• Ratio-Based Recommendations: Provides tailored guidance for CPU, memory, cache, and background pool settings scaled to the detected hardware, with clear explanations for each recommendation.
• Safety & Verification: Includes guardrails to avoid overallocating resources, step-by-step verification queries to confirm changes take effect, and rollback guidance for issues like OOM errors.
• Use Case: For a 16-core, 64GB RAM ClickHouse deployment on NVMe drives, this skill will recommend appropriate values for max_threads, max_memory_usage, and background pool sizes instead of relying on generic one-size-fits-all defaults.

Quick Start

Use the hardware-tuning skill to analyze my self-hosted ClickHouse server's hardware and get a list of recommended configuration settings tailored to my system.