limit
(optional): Maximum number of rows to return (default: server configured limit, max: 10,000)
How to use it
limit is exposed by the Altinity MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the limit 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