mcpserver.so LogoMCPFly
Submit
Clickhouse MCP Server logo

Clickhouse MCP Server

by burakdirin

Data/IntegrationClickhouseDatabaseServerIntegration

A Clickhouse database MCP server project. It allows connecting to and querying Clickhouse databases.

View on GitHub

Last updated: N/A

What is Clickhouse MCP Server?

The Clickhouse MCP Server is a tool that enables interaction with Clickhouse databases. It provides functionalities to connect to a database and execute SQL queries, returning results in JSON format.

How to use Clickhouse MCP Server?

  1. Install the package using uv pip install clickhouse-mcp-server or pip install clickhouse-mcp-server. 2. Configure environment variables for Clickhouse connection: CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE, and CLICKHOUSE_READONLY. 3. Use the provided tools (connect_database, execute_query) to interact with the database. Refer to the Quickstart section for Claude Desktop integration or Smithery installation.

Key features of Clickhouse MCP Server

  • Connects to Clickhouse databases

  • Executes SQL queries

  • Returns query results in JSON format

  • Supports multiple queries

  • Configurable via environment variables

Use cases of Clickhouse MCP Server

  • Integrating Clickhouse with Claude Desktop

  • Querying Clickhouse databases from applications

  • Automating database tasks

  • Building data pipelines

  • Data analysis and reporting

FAQ from Clickhouse MCP Server

What is the default Clickhouse host?

The default Clickhouse host is 'localhost'.

What is the default Clickhouse user?

The default Clickhouse user is 'root'.

What is the default Clickhouse password?

The default Clickhouse password is an empty string ('').

How do I enable read-only mode?

Set the CLICKHOUSE_READONLY environment variable to '1' or 'true'.

How do I debug the MCP server?

Use the MCP Inspector for the best debugging experience. Refer to the Development section for instructions.