clickhouse-mcp

clickhouse-mcp

0
databases

ClickHouse Readonly MCP is a server for executing read-only queries on the ClickHouse database. It supports both HTTP and native connections, ensuring high performance and input validation for safe query operations.

ClickHouse Readonly MCP

  • A FastMCP server for executing read-only ClickHouse queries.
  • Features include input validation for read-only SQL operations like SELECT, SHOW, DESCRIBE, and EXPLAIN.
  • Supports both HTTP and native ClickHouse connections with automatic failover.
  • Provides simplified table format query results and supports parameterized queries.

Installation

  • Install via pip: pip install clickhouse-readonly-mcp
  • Install from source by cloning the repository and using pip.

Usage

  • Configure with a config.json to execute using specific Python environments and scripts.
  • Includes optimized version of the official implementation.

License

MIT