ClickHouse MCP Server

Execute SELECT queries and inspect database schemas directly from Claude Desktop.

Data last scanned yesterday · Reviewed last month

253 tools★ 0TypeScript

Overview

This MCP server allows users to interface with local or remote ClickHouse databases by providing specific tools for SQL interaction. It supports listing all available tables, describing specific table schemas, and executing raw SELECT statements to fetch data directly within the AI assistant environment. Installation requires a Node.js environment, where users must configure their specific ClickHouse connection details such as host, port, and credentials within their Claude Desktop configuration file. The implementation restricts database activity to SELECT operations to ensure read-only access to your cluster.

Our verdict

This server carries a high-risk score of 10/100 and is not recommended for production environments. The project lacks a software license, hasn't been updated in over a year, and is maintained by a single contributor with zero GitHub stars. Because the security implications of its authentication methods and read-only implementation have not been editorially reviewed, users should exercise extreme caution when connecting it to sensitive databases.

Strictly limits database access to SELECT queries only
Contains only three direct project dependencies

No license detected, creating legal ambiguity for users
Zero GitHub stars and last commit over a year ago
Authentication methods have not been independently reviewed

Setup

Claude Desktop

{
  "mcpServers": {
    "clickhouse-mcp-server": {
      "args": [
        "-y",
        "clickhouse-mcp-server"
      ],
      "command": "npx"
    }
  }
}

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows), then restart Claude Desktop. Some servers require API keys or tokens as environment variables — check the project's README and add an "env" object if needed.

No read-only mode — running this grants full read/write access.
No built-in authentication — anyone with access to this config can invoke every tool it exposes.

Tools

Tool	Description	Risk
clickhouse_query	Execute SELECT queries on your ClickHouse cluster	low
clickhouse_show_tables	List all tables in the ClickHouse database	low
clickhouse_describe_table	Describe the schema of a specific table	low

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›Can I perform data modifications like INSERT or DELETE using this server?

No, for security reasons, the server exclusively allows the execution of SELECT queries.

›What are the environment requirements for running this server?

You need Node.js version 18 or higher, a ClickHouse database that is reachable locally or remotely, and the Claude Desktop application.

›How do I secure my database credentials when configuring the server?

You should use environment variables within your Claude Desktop configuration file to manage sensitive credentials like your ClickHouse user and password.

›Does this server support secure connections to ClickHouse?

Yes, you can enable secure connections by setting the CLICKHOUSE_SECURE and CLICKHOUSE_VERIFY environment variables to true in your configuration.

›What steps are required after editing the Claude Desktop configuration file?

You must restart the Claude Desktop application for the changes to take effect.