---
title: "ClickHouse MCP Server for ToolPiper · ModelPiper"
description: "Run analytical SQL against ClickHouse from the assistant. 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 databa"
canonical: "https://modelpiper.com/mcp-tools/clickhouse"
---

# ClickHouse MCP Server for ToolPiper · ModelPiper

> Run analytical SQL against ClickHouse from the assistant. 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 databa

C

# ClickHouse MCP Server

✓ verified

Run analytical SQL against ClickHouse from the assistant.

Install ClickHouse in ToolPiper

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

[Open repository →](https://github.com/ClickHouse/mcp-clickhouse)

Publisher

[ClickHouse](https://github.com/ClickHouse/mcp-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.

Install ClickHouse in ToolPiper

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)

Claude Desktop Cursor Continue Cline

Add this to ~/Library/Application Support/Claude/claude\_desktop\_config.json.

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

Copy

## Example prompts

-   "List the tables in the events database and show me the schema of page\_views."
    
    Copy
-   "What were the top 10 referrers by traffic last week?"
    
    Copy
-   "Compute daily active users for the last 30 days."
    
    Copy

## 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

-   [
    
    P
    
    ### Postgres
    
    ✓ verified
    
    Query Postgres databases with read-only SQL.
    
    DataLocal subprocess1 tool
    
    
    
    
    
    ](/mcp-tools/postgres)
-   [
    
    S
    
    ### SQLite
    
    ✓ verified
    
    Query SQLite databases and run business-intelligence prompts.
    
    DataLocal subprocess4 tools
    
    
    
    
    
    ](/mcp-tools/sqlite)
-   [
    
    R
    
    ### Redis
    
    ✓ verified
    
    Interact with Redis key-value stores from the assistant.
    
    DataLocal subprocess4 tools
    
    
    
    
    
    ](/mcp-tools/redis)
-   [
    
    A
    
    ### AWS Knowledge Base
    
    ✓ verified
    
    Retrieve answers from an AWS Bedrock Knowledge Base.
    
    DataLocal subprocess1 tool
    
    
    
    
    
    ](/mcp-tools/aws-kb-retrieval)

[← Back to all MCP tools](/mcp-tools)