mcp-clickhouse
SQLクエリ用のClickHouse MCPサーバー. mcp-clickhouse is a Model Context Protocol (MCP) server maintained by iskakaushik. It connects to MCP-compatible clients such as Claude Desktop, Cursor, Cline, and other agents that speak the protocol. It exposes 3 tools, including run_select_query, list_databases and list_tables, that an agent can call directly. It is categorized under Database/ClickHouse and Tool/Server.
このMCPについて
このMCPは、ClickHouseクラスター上でSQLクエリを実行するためのサーバーで、データベースとテーブルへの読み取り専用アクセスを提供します。
使用方法
.env.productionファイルにClickHouseの認証情報を設定し、uv syncで依存関係をインストールした後、fastmcp installでサーバーを起動します。
用途
ClickHouseデータベースへの安全なクエリ実行、利用可能なデータベースの一覧表示、テーブル構造の読み取り専用での調査などに使用できます。
AIMCP authority
DR and traffic signal for the AIMCP public domain.
Frequently asked questions
What is the mcp-clickhouse MCP server?
mcp-clickhouse is a Model Context Protocol server from iskakaushik. It lets MCP-compatible AI clients call its tools over a standard interface, so agents like Claude, Cursor, and Cline can use it without custom integration.
How do I connect mcp-clickhouse to my AI client?
Add mcp-clickhouse to your client's MCP configuration using the stdio or SSE connection shown in the usage examples on this page, then restart the client to load the server.
What tools does mcp-clickhouse provide?
mcp-clickhouse provides 3 tools: run_select_query, list_databases and list_tables.
Is mcp-clickhouse free to use?
mcp-clickhouse is listed on AIMCP for free. Any API keys or accounts required by the underlying service are set by its provider.
Vernclaw Plugins for OpenClaw
Ready-to-use connectors for SEO data, social reading & content generation. Pay-as-you-go credits with audit logs.