Design ClickHouse MergeTree ORDER BY and partitions; batch inserts; use projections and skip indexes; tune mutations, replication lag, and backups without treating it as OLTP.
Install
npx skills add alivirgo/Major-AI-Skills --skill clickhousenpx skills add alivirgo/Major-AI-Skills --skill clickhouse -a claude-code -gnpx skills add alivirgo/Major-AI-Skills --skill clickhouse -a codex -ggemini skills install https://github.com/alivirgo/Major-AI-Skills.git --path skills/clickhousegh skill install alivirgo/Major-AI-Skills clickhousegit clone --depth 1 https://github.com/alivirgo/Major-AI-Skills /tmp/alivirgo__Major-AI-Skills
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/alivirgo__Major-AI-Skills/skills/clickhouse ~/.claude/skills/clickhouse # Claude Code
cp -R /tmp/alivirgo__Major-AI-Skills/skills/clickhouse ~/.agents/skills/clickhouse # Codex, Cursor, Gemini CLI, Copilot, OpenCode