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.
- Input:
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.
- Input:
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.
