mcp-clickhouse

ClickHouse MCP Server

An MCP server for ClickHouse, designed to facilitate interaction with ClickHouse databases through the Claude interface.

Features

• Tools:
  • run_select_query: Executes SQL SELECT queries on a ClickHouse cluster with readonly mode enabled for safety.
    • Input: sql (string) - The SQL query to execute.
  • list_databases: Lists all databases on the ClickHouse cluster.
  • list_tables: Lists all tables within a specified database.
    • Input: database (string) - The name of the database.

Configuration

Configuration involves modifying the Claude Desktop configuration file to include the MCP server details and ClickHouse connection parameters.

Key parameters include:

• ClickHouse host, port, user, and password.
• SSL settings (secure and verify).
• Connection and send/receive timeouts.

Development

Local development setup involves using Docker Compose to run a ClickHouse cluster and setting up environment variables for connection details. The server can be easily tested using the mcp dev command.