execute_query

MCP tool from Altinity MCP by Altinity

Executes SQL queries against ClickHouse® with optional result limiting.

How to use it

execute_query is exposed by the Altinity MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the execute_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Altinity MCP

$docker run -it --rm ghcr.io/altinity/altinity-mcp:latest --clickhouse-host clickhouse

FULL ALTINITY MCP LISTING

Other tools in Altinity MCP (2)

limit

(optional): Maximum number of rows to return (default: server configured limit, max: 10,000)

query

(required): The SQL query to execute