altinity-expert-clickhouse-connection
Installation
SKILL.md
Connection, cluster and time window
Run this before any other altinity-expert-clickhouse-* skill. It produces the facts every later skill reuses: connection mode, cluster name (or single node), ClickHouse version, Keeper presence, time window.
Step 1: choose the connection mode
Check your available tools in this order and stop at the first match:
- MCP mode: a tool whose name contains
clickhouseand one ofquery,execute,sql(for exampleclickhouse_execute_query,mcp__clickhouse__execute_query). Send exactly one SQL statement per call. If several ClickHouse MCP servers exist, ask the user which one to use. - Exec mode: a shell tool plus
clickhouse-client(orclickhouse client). Use only the connection flags the user provided (--host,--port,--user,--password,--secure); do not guess credentials from environment variables. Run one statement per invocation with--query "<statement>". Never use--queries-fileor--multiquery. - Neither: stop and ask the user how to reach ClickHouse. Do not install software and do not write helper scripts.
Step 2: verify connectivity and collect header facts
Run this one statement. It works on a standalone server (no macro, no Keeper) and on a cluster: