MCP Clickhouse

🚀 ClickHouse MCP Server

An MCP server for ClickHouse, enabling various operations on ClickHouse clusters.

✨ Features

Tools

• run_select_query

  • Execute SQL queries on your ClickHouse cluster.
  • Input: sql (string): The SQL query to be executed.
  • All ClickHouse queries will run with readonly = 1 to ensure their security.

• list_databases

  • List all databases on your ClickHouse cluster.
  • Input: None
  • Output: A list of databases.

• list_tables

  • List all tables in the specified database.
  • Input: database (string): The name of the database for which to list tables.
  • Output: A list of tables.

📦 Installation

To use this MCP server in your project, you need to add the following configuration to pyproject.toml or setup.py:

[project.urls]
Homepage = "https://glama.ai/mcp/servers/yvjy4csvo1"

🔧 Technical Details

You can configure the behavior of the MCP server through environment variables. The following are the supported environment variables and their functions:

Example Configurations

Local Development

# Required variables
CLICKHOUSE_HOST=localhost
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=clickhouse

# Optional variables: Override default values
CLICKHOUSE_SECURE=false  # Automatically use port 8123
CLICKHOUSE_VERIFY=false

ClickHouse Cloud

# Required variables
CLICKHOUSE_HOST=your-instance.clickhouse.cloud
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=your-password

# Optional variables: Use secure default values
# CLICKHOUSE_SECURE=true  # Automatically use port 8443
# CLICKHOUSE_DATABASE=your_database

ClickHouse SQL Playground

CLICKHOUSE_HOST=sql-clickhouse.clickhouse.com
CLICKHOUSE_USER=demo
CLICKHOUSE_PASSWORD=
# Use secure default values (HTTPS on port 8443)

📚 Documentation

YouTube Summary