ClickHouse MCP Server

@dubin555

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0

トランスポート

stdio

作者

dubin555

ClickHouse MCP Server について

概要はまだありません

ClickHouse MCP Server の設定

標準の設定はありません

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

リポジトリ

ClickHouse MCP Server のツール

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

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

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

概要

What is ClickHouse MCP Server?

A Model Context Protocol (MCP) server implementation for ClickHouse. It provides AI assistants with a secure and structured way to explore and analyze databases, allowing them to list tables, read data, and execute SQL queries through a controlled interface.

How to use ClickHouse MCP Server?

Configure via environment variables (CLICKHOUSE_HOST, CLICKHOUSE_PORT, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE) or equivalent command-line arguments. Add the server to an MCP client (e.g., Cline extension in VS Code) using uv with the path to the server directory.

Key features of ClickHouse MCP Server?

List tables and read data from ClickHouse.
Execute SQL queries through a controlled interface.
Secure database access with user/password authentication.
Configurable via environment variables or command-line args.
Uses ClickHouse HTTP API on port 8123.

Use cases of ClickHouse MCP Server?

AI assistants answering business questions by querying ClickHouse.
Natural language exploration of database schemas and data.
Automated data analysis and reporting via conversational AI.
Safe read-only (or controlled write) database access for LLMs.

よくある質問

What are the prerequisites?

Python with the `uv` package manager, a running ClickHouse instance, and MCP server dependencies.

How do I configure the connection to ClickHouse?

Set the environment variables `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_USER`, `CLICKHOUSE_PASSWORD`, and `CLICKHOUSE_DATABASE`, or pass them as command-line arguments (`--host`, `--port`, etc.).

How do I integrate this server with an AI assistant?

Add the server configuration to your MCP client (e.g., the Cline extension in VS Code) using the provided JSON example with the `uv` command.

What transport protocol does the server use to connect to ClickHouse?

It connects to ClickHouse via HTTP on the default port 8123.

Is authentication supported?

Yes, the server supports ClickHouse user/password authentication via the `CLICKHOUSE_USER` and `CLICKHOUSE_PASSWORD` settings.

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s