ClickHouse Readonly MCP Server

@the-nine-nation

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

the-nine-nation

ClickHouse Readonly MCP Server について

a readonly clickhouse mcp server and ensure your ai use clickhouse safely

ClickHouse Readonly MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ClickHouse Readonly MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is ClickHouse Readonly MCP?

A FastMCP server for executing read-only ClickHouse queries. It supports local Python API integration and can run as a standalone service, making it suitable for AI assistants and workflow automation that need safe database access.

How to use ClickHouse Readonly MCP?

Install via pip install clickhouse-readonly-mcp or from source. Configure it in your MCP client (e.g., Cursor's config.json) by setting environment variables such as CLICKHOUSE_HOST, CLICKHOUSE_PORT, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, and optionally CLICKHOUSE_RESOURCE_DESC_FILE. The server then exposes tools that accept read-only SQL queries.

Key features of ClickHouse Readonly MCP

Enforces read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
Supports both HTTP and native ClickHouse protocols with auto-fallback
Outputs results in a clean table format
Supports parameterized queries for safe execution
High‑performance query execution and result handling

Use cases of ClickHouse Readonly MCP

Allow AI assistants to safely query ClickHouse without risk of data modification
Provide database context to large language models via a resource description file
Expose ClickHouse as a read-only API within a Model Context Protocol workflow
Integrate into automated data retrieval pipelines that require strict read‑only access

よくある質問

What SQL operations are allowed?

Only read‑only SQL statements are permitted: SELECT, SHOW, DESCRIBE, EXPLAIN, and similar commands. Any attempt to run INSERT, UPDATE, DELETE, etc. is rejected.

Which ClickHouse connection protocols are supported?

Both the native ClickHouse port and the HTTP port are supported. The server automatically switches between them if one fails.

What environment variables are required?

You must set `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, and authentication credentials (`CLICKHOUSE_USER` / `CLICKHOUSE_USERNAME` and `CLICKHOUSE_PASSWORD`). Optionally, set `CLICKHOUSE_HTTP_PORT` and `CLICKHOUSE_RESOURCE_DESC_FILE` to improve model understanding.

Does the server support parameterized queries?

Yes. It accepts query parameters, enabling safe, reusable query execution.

What runtime dependencies does it need?

Python 3 and the `clickhouse-readonly-mcp` package (which pulls in the necessary ClickHouse driver and FastMCP library). No additional system services are required.

「データベース」の他のコンテンツ

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes