clickhouse-mcp-server

clickhouse-mcp-server

2
databases

The Clickhouse MCP Server provides tools to connect and execute queries on a Clickhouse database using Model Context Protocol. It supports configuration via environment variables and debugging through MCP Inspector.

Clickhouse MCP Server

A Clickhouse database MCP server project.

Installation

  • Install using uv or pip.

Components

Tools

  • connect_database: Connect to a Clickhouse database.
  • execute_query: Execute Clickhouse queries and return results in JSON format.

Configuration

Environment variables: CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE, CLICKHOUSE_READONLY.

Quickstart

Instructions for Claude Desktop configuration.

Development

Building and Publishing

  • Sync dependencies using uv sync.
  • Build with uv build.
  • Publish to PyPI using uv publish.

Debugging

Use MCP Inspector for debugging via stdio.