LogoFindMcp
Logo of mcp-clickhouse

mcp-clickhouse

An MCP (Meta-Config Provider) server for ClickHouse, enabling SQL queries and database management via Claude.

Introduction

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.

Newsletter

Join the Community

Subscribe to our newsletter for the latest news and updates