ClickHouse MCP Server

Data teams that want to ask questions of a ClickHouse database through an AI assistant.

Use it now Want it running at your company?

Recommendedour rating
883gitHub stars
Apache-2.0licence
4 days agolast update

Use it now

claude mcp add --transport http mcp-clickhouse http://127.0.0.1:8000

Install in Cursor Install in VS Code Open the original ↗

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

README.md

Loading the file...

What it does

The ClickHouse MCP server lets an AI assistant connect to a ClickHouse database. It can inspect the schema and run SQL queries, and returns the results as JSON text.

Use cases

01Explore which tables and columns a database contains
02Run a SQL query and read the results in chat
03Check a metric without opening a separate SQL client

Questions about
ClickHouse MCP Server.

What is ClickHouse MCP Server used for?

Data teams that want to ask questions of a ClickHouse database through an AI assistant. The ClickHouse MCP server lets an AI assistant connect to a ClickHouse database. It can inspect the schema and run SQL queries, and returns the results as JSON text.

How do I install ClickHouse MCP Server?

Run this in your terminal: claude mcp add --transport http mcp-clickhouse http://127.0.0.1:8000

Is ClickHouse MCP Server open source?

Yes. The code is on GitHub (ClickHouse/mcp-clickhouse) under the Apache-2.0 licence.

Is ClickHouse MCP Server safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.

Related resources

Read the guide: AI data analysts: ask your data ↗