ClickHouse: MCP server, setup and security

What ClickHouse does

According to its repository: “ClickHouse database integration with schema inspection and query capabilities.”

An MCP server gives an AI agent extra tools it calls during the conversation: the agent reads their description, decides to use them and gets the result back. ClickHouse is listed under Databases, a category of 138 servers in the directory, where it ranks #21 by stars.

Installing and connecting ClickHouse

Distribution modes declared in the official MCP registry:

• PyPI package (Python, started with uvx or pip)
• Docker (OCI) image

Like any MCP server, you declare it in your client's configuration (Claude Desktop, Claude Code, Cursor, VS Code, Codex…): a name, the command that starts it or its URL, and any environment variables. The client then starts it and lists its tools. Project language: Python.

The registry lists 2 secret variables to provide (API key, access token). Keep them in the client's environment variables, never in a shared file or a repository.

Security: what to check

An MCP server runs code with the rights you give it, and the model reads its tool descriptions: a malicious or compromised server can hijack the agent. Read the code, or pick a maintained and widely used server, before connecting it.

Points found for ClickHouse:

• Secrets: the server acts with your credentials. Create a dedicated key with minimum rights and an expiry date.

Good practice: grant only the rights needed (least privilege), require human approval for irreversible actions, and run the AI agent security check.

Project activity and maintenance

Created on December 25, 2024, the ClickHouse/mcp-clickhouse repository has 892 stars and 210 forks, with 4 open issues. It has more stars than 91% of the servers in the directory. It received changes this month. Version published in the registry: 0.7.0 (September 21, 2026).

Stars measure attention, not quality: a recent, heavily promoted project can collect them fast, while a useful but niche server will have few.