Install Altinity MCP

Pick your client, copy the command, done.

claude mcp add altinity-mcp -- ./altinity-mcp --clickhouse-host localhost --clickhouse-port 8123

Environment Variables

Set these before running Altinity MCP.

VariableDescriptionRequired

CLICKHOUSE_HOSTThe hostname of the ClickHouse serverNo

MCP_TRANSPORTTransport protocol to use (stdio, http, sse)No

MCP_PORTPort for HTTP or SSE transportNo

Once configured, Altinity MCP gives your AI agent access to:

list_tablesList all tables available in the ClickHouse database

describe_schemaRetrieve the schema definition for a specific table

table_name

execute_queryExecute a SQL query against the ClickHouse database

query

After setup, try these prompts with your AI agent:

→List all the tables currently available in my ClickHouse database.

→Describe the schema for the 'events' table so I can understand its columns.

→Run a query to count the number of rows in the 'logs' table for the last 24 hours.

→Find the top 10 most active users from the 'user_activity' table using a SQL query.

Prerequisites & system requirements

An MCP-compatible client (Claude Code, Cursor, Windsurf, Claude Desktop, or Codex)
Docker installed and running

Alternative installation methods

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp

go build -o altinity-mcp ./cmd/altinity-mcp

Save the docs, env vars, and workflow around Altinity MCP in Conare so Claude Code, Codex, and Cursor remember it next time.