Global AI chat room · 17 online now Join now
M
MCP SERVER Listed

mcp-clickhouse

mcp-clickhouse is a Model Context Protocol server that connects ClickHouse to your MCP-compatible tools and agents. It lets you explore schemas, run SQL queries, and manage tables directly from an MCP client while enforcing safety controls: read/write/destructive classification, database allowlists, row caps, dry-run, and audit logging. Ideal for data analysts, ML engineers, and backend devs who want to query ClickHouse through AI assistants without exposing raw credentials or running risky statements. Integrates easily with any MCP host (Claude Desktop, custom agents) via standard MCP transport. Compared to ad-hoc DB clients, it adds structured governance for LLM-driven workflows—preventing accidental deletes, capping result sizes, and logging every action. Setup is straightforward: configure the server with your ClickHouse connection, define allowlists and limits, and start querying securely through your AI toolchain.

Open ecosystemDatabaseDatabase
View GitHub
01 / SERVER DETAIL

Server detail

mcp-clickhouse is a Model Context Protocol server that connects ClickHouse to your MCP-compatible tools and agents. It lets you explore schemas, run SQL queries, and manage tables directly from an MCP client while enforcing safety controls: read/write/destructive classification, database allowlists, row caps, dry-run, and audit logging. Ideal for data analysts, ML engineers, and backend devs who want to query ClickHouse through AI assistants without exposing raw credentials or running risky statements. Integrates easily with any MCP host (Claude Desktop, custom agents) via standard MCP transport. Compared to ad-hoc DB clients, it adds structured governance for LLM-driven workflows—preventing accidental deletes, capping result sizes, and logging every action. Setup is straightforward: configure the server with your ClickHouse connection, define allowlists and limits, and start querying securely through your AI toolchain.

An MCP server that exposes mcp-clickhouse capabilities to MCP-compatible AI clients.

CapabilitiesDatabaseMCPOpen source
ProtocolModel Context Protocol
Developer ecosystemOpen ecosystem
LicenseMIT / check source
SourceGitHub
COLLECTIONS

Collections featuring this MCP

Popular MCP2026.03.30Listed
My MCP2026.03.31Listed
Genie2026.03.30Listed
02 / TOOL TESTING

Tool testing

AVAILABLE TOOL

mcp-clickhouse

Callable

Call the MCP capabilities provided by mcp-clickhouse and return a structured result.

PARAMETERS
inputPass arguments according to the server tool schema.
Tip: the tool may truncate responses. Use pagination parameters such as start_index to read long content in chunks.
03 / SERVICE CONFIGURATION

Connection modes

Remote
{
  "mcpServers": {
    "mcp-clickhouse": {
      "url": "Generated by the provider after deployment"
    }
  }
}

The Remote endpoint is generated by the provider after deployment; this page does not fabricate an unusable endpoint.

03 / WORKFLOW

How to use

  1. 01
    Step 1

    Review server capabilities and permission scope.

  2. 02
    Step 2

    Copy the install command or JSON configuration.

  3. 03
    Step 3

    Run a small connection test in your client.

  4. 04
    Step 4

    Adopt it long term only after reviewing access and maintenance.

04 / DISCUSSIONS

Discussions

Use this space to keep checking source information, usage experience and maintenance status.

Open source page
Email