ClickHouse MCP Server

✓ verified

Run analytical SQL against ClickHouse from the assistant.

Don't have ToolPiper? We'll take you to the download.

Open repository →

Publisher

ClickHouse

License

Apache-2.0

Transport

Local subprocess

Tools

3

What this server does

ClickHouse is a columnar database built for fast analytics over large datasets; its official MCP server lets the assistant query it in read-only mode. List databases and tables, inspect schemas, and run SELECTs that return in milliseconds even over billions of rows. The server is read-only by construction, so the model cannot mutate data, which makes it a safe analytics surface to point at a production replica. Ask business questions in plain language and let the model write the columnar SQL.

Tools included

  • run_select_query

    Run a read-only SELECT query.

  • list_databases

    List databases on the server.

  • list_tables

    List tables in a database with their schemas.

The authoritative list comes from the server's tools/list at runtime. This catalog entry may lag the upstream until the next ToolPiper release.

Install in ToolPiper

ToolPiper handles the JSON configuration. Click Install, fill in any required tokens, and the server is ready in your chat.

Don't have ToolPiper? We'll take you to the download.

Install in another client

Install in another MCP client (Claude Desktop, Cursor, Continue, Cline)

Add this to ~/Library/Application Support/Claude/claude_desktop_config.json.

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ]
    }
  }
}

Example prompts

  • "List the tables in the events database and show me the schema of page_views."

  • "What were the top 10 referrers by traffic last week?"

  • "Compute daily active users for the last 30 days."

Security notes

Connect with a read-only user so the assistant cannot modify data even by accident; the server is designed for read-only access but the database user is the real boundary. The password is a credential, so keep it out of committed config. Pointing at a replica rather than the primary protects your write path from heavy analytical queries.

Related tools