Grok Bot Bot Hubs Bots Integrations
← Back to Plugins
MCP Server MCP

ClickHouse

github By github 👁 1 views ▲ 0 votes

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

Homepage Verified source GitHub

Install

uvx mcp-clickhouse

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "pypi",
      "identifier": "mcp-clickhouse",
      "version": "0.4.1",
      "runtimeHint": "uvx",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Hostname of the ClickHouse server",
          "isRequired": true,
          "name": "CLICKHOUSE_HOST"
        },
        {
          "description": "Username for ClickHouse authentication",
          "isRequired": true,
          "name": "CLICKHOUSE_USER"
        },
        {
          "description": "Password for ClickHouse authentication",
          "isRequired": true,
          "isSecret": true,
          "name": "CLICKHOUSE_PASSWORD"
        },
        {
          "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise",
          "name": "CLICKHOUSE_PORT"
        },
        {
          "description": "Use HTTPS to connect to ClickHouse",
          "format": "boolean",
          "default": "true",
          "name": "CLICKHOUSE_SECURE"
        },
        {
          "description": "Verify SSL certificates",
          "format": "boolean",
          "default": "true",
          "name": "CLICKHOUSE_VERIFY"
        },
        {
          "description": "Default database to use",
          "name": "CLICKHOUSE_DATABASE"
        },
        {
          "description": "ClickHouse role to activate for the session",
          "name": "CLICKHOUSE_ROLE"
        },
        {
          "description": "Allow write operations (DDL and DML). Queries run read-only by default",
          "format": "boolean",
          "default": "false",
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS"
        },
        {
          "description": "Allow destructive operations (DROP, TRUNCATE) when write access is also enabled",
          "format": "boolean",
          "default": "false",
          "name": "CLICKHOUSE_ALLOW_DROP"
        },
        {
          "description": "Query tool timeout in seconds",
          "format": "number",
          "default": "30",
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT"
        }
      ]
    },
    {
      "registryType": "oci",
      "identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.4.1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Hostname of the ClickHouse server",
          "isRequired": true,
          "name": "CLICKHOUSE_HOST"
        },
        {
          "description": "Username for ClickHouse authentication",
          "isRequired": true,
          "name": "CLICKHOUSE_USER"
        },
        {
          "description": "Password for ClickHouse authentication",
          "isRequired": true,
          "isSecret": true,
          "name": "CLICKHOUSE_PASSWORD"
        },
        {
          "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise",
          "name": "CLICKHOUSE_PORT"
        },
        {
          "description": "Use HTTPS to connect to ClickHouse",
          "format": "boolean",
          "default": "true",
          "name": "CLICKHOUSE_SECURE"
        },
        {
          "description": "Verify SSL certificates",
          "format": "boolean",
          "default": "true",
          "name": "CLICKHOUSE_VERIFY"
        },
        {
          "description": "Default database to use",
          "name": "CLICKHOUSE_DATABASE"
        },
        {
          "description": "ClickHouse role to activate for the session",
          "name": "CLICKHOUSE_ROLE"
        },
        {
          "description": "Allow write operations (DDL and DML). Queries run read-only by default",
          "format": "boolean",
          "default": "false",
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS"
        },
        {
          "description": "Allow destructive operations (DROP, TRUNCATE) when write access is also enabled",
          "format": "boolean",
          "default": "false",
          "name": "CLICKHOUSE_ALLOW_DROP"
        },
        {
          "description": "Query tool timeout in seconds",
          "format": "number",
          "default": "30",
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT"
        }
      ]
    }
  ]
}
mcp model-context-protocol pypi oci

Comments

Sign in to leave a comment

Loading comments...

More by github

GetFacade

GetFacade

Designs a real house exterior on its own photo, prices it line by line and documents it.

0
Waggle

Waggle

Discover, search, invoke, and rate A2A (Agent-to-Agent) protocol agents.

0
SIMcloud

SIMcloud

South African MCP server for airtime, data, SMS, VAS, electricity, balance, and network lookup.

0
Yault AESP

Yault AESP

Crypto payments for the agent economy — policy-gated vault operations under human control

0

Similar Plugins in MCP Server

Nolizi Calendar

Nolizi Calendar

Nolizi Calendar provides a hosted, owner-authenticated MCP server for scheduling. Its five tools discover event types, c

0
Kooma — Bambara AI

Kooma — Bambara AI

Bambara AI over MCP: text-to-speech, transcription and translation (Bamanankan + more).

0
GetFacade

GetFacade

Designs a real house exterior on its own photo, prices it line by line and documents it.

0
alfred_

alfred_

Your real Gmail, Outlook and calendars, worked as you: read, draft, send, schedule, organize.

0
Gessa: game asset generation for AI agents

Gessa: game asset generation for AI agents

Generate game-ready 3D models, textures, and audio from natural language, over MCP.

0
ai.agentgates/mcp

ai.agentgates/mcp

Confidential compute and inference sold to agents over x402 USDC, plus an agent wallet over MCP.

0