Skip to main content
Glama
enesjakozh

clickhouse-mcp-server

by burakdirin
GitHub
Python
MIT License
2
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Clickhouse MCP server

A Clickhouse database MCP server project.

Installation

You can install the package using uv:

uv pip install clickhouse-mcp-server

Or using pip:

pip install clickhouse-mcp-server

Components

Tools

The server provides two tools:

  • connect_database: Connects to a specific Clickhouse database
    • database parameter: Name of the database to connect to (string)
    • Returns a confirmation message when connection is successful
  • execute_query: Executes Clickhouse queries
    • query parameter: SQL query/queries to execute (string)
    • Returns query results in JSON format
    • Multiple queries can be sent separated by semicolons

Configuration

The server uses the following environment variables:

  • CLICKHOUSE_HOST: Clickhouse server address (default: "localhost")
  • CLICKHOUSE_USER: Clickhouse username (default: "root")
  • CLICKHOUSE_PASSWORD: Clickhouse password (default: "")
  • CLICKHOUSE_DATABASE: Initial database (optional)
  • CLICKHOUSE_READONLY: Read-only mode (set to 1/true to enable, default: false)

Quickstart

Installation

Claude Desktop

MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json

Windows: %APPDATA%/Claude/claude_desktop_config.json

{ "mcpServers": { "clickhouse-mcp-server": { "command": "uv", "args": [ "--directory", "/Users/burakdirin/Projects/clickhouse-mcp-server", "run", "clickhouse-mcp-server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_USER": "root", "CLICKHOUSE_PASSWORD": "password", "CLICKHOUSE_DATABASE": "[optional]", "CLICKHOUSE_READONLY": "true" } } } }
{ "mcpServers": { "clickhouse-mcp-server": { "command": "uvx", "args": [ "clickhouse-mcp-server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_USER": "root", "CLICKHOUSE_PASSWORD": "password", "CLICKHOUSE_DATABASE": "[optional]", "CLICKHOUSE_READONLY": "true" } } } }

Installing via Smithery

To install Clickhouse Database Integration Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @burakdirin/clickhouse-mcp-server --client claude

Development

Building and Publishing

To prepare the package for distribution:

  1. Sync dependencies and update lockfile:
uv sync
  1. Build package distributions:
uv build

This will create source and wheel distributions in the dist/ directory.

  1. Publish to PyPI:
uv publish

Note: You'll need to set PyPI credentials via environment variables or command flags:

  • Token: --token or UV_PUBLISH_TOKEN
  • Or username/password: --username/UV_PUBLISH_USERNAME and --password/UV_PUBLISH_PASSWORD

Debugging

Since MCP servers run over stdio, debugging can be challenging. For the best debugging experience, we strongly recommend using the MCP Inspector.

You can launch the MCP Inspector via npm with this command:

npx @modelcontextprotocol/inspector uv --directory /Users/burakdirin/Projects/clickhouse-mcp-server run clickhouse-mcp-server

Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.

Install Server
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

An MCP server implementation that enables Claude AI to interact with Clickhouse databases. Features include secure database connections, query execution, read-only mode support, and multi-query capabilities.

  1. Installation
    1. Components
      1. Tools
    2. Configuration
      1. Quickstart
        1. Installation
        2. Installing via Smithery
      2. Development
        1. Building and Publishing
        2. Debugging

      Related Resources

      Related MCP Servers

      • Filesystem MCP Server

        ai-yliu
        A
        security
        F
        license
        A
        quality
        An MCP server that allows Claude AI to perform filesystem operations including reading, writing, listing, moving files, and searching directories within specified allowed paths.
        Last updated -
        9
        10
        1
        JavaScript

      • ClickUp MCP Sedrver

        nsxdavid
        A
        security
        A
        license
        A
        quality
        ClickUp MCP Server enables AI assistants to seamlessly interact with your ClickUp workspace. This powerful integration allows Claude to create and manage tasks, access documents, organize folders and lists, add comments, and handle checklists—all through natural conversation.
        Last updated -
        42
        613
        18
        TypeScript
        MIT License
        • Apple

      • MCP Claude Code

        SDGLBL
        -
        security
        A
        license
        -
        quality
        An MCP server that implements Claude Code-like functionality, allowing the AI to analyze codebases, modify files, execute commands, and manage projects through direct file system interactions.
        Last updated -
        224
        Python
        MIT License
        • Apple
        • Linux

      • Claude AI Documentation Assistant

        XPE-7
        -
        security
        F
        license
        -
        quality
        An MCP server that integrates with Claude to provide smart documentation search capabilities across multiple AI/ML libraries, allowing users to retrieve and process technical information through natural language queries.
        Last updated -
        Python

      View all related MCP servers

      Appeared in Searches

      New MCP Servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/burakdirin/clickhouse-mcp-server'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server