clickhouse-mcp-server

Provides AI agents safe, read-only access to a ClickHouse database, enabling table listing, query execution, schema inspection, and caching.

→ sepfazeli/clickhouse-mcp-server · listed on glama

Is this your MCP?

Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

✅

6 tools verified — handlers match their declared behaviour

5 read-only tools verified — handlers contain no write/delete/exec

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

🔐

You'll be asked for 2 credentials: CLICKHOUSE_PASSWORD, MCP_API_KEY

These are read from process.env at runtime. Make sure you trust where they’ll be sent.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

configCACHE_TTL_MS

configCLICKHOUSE_DATABASE— "": "default"

🔐 secretCLICKHOUSE_PASSWORD

configCLICKHOUSE_URL— "": "http://localhost:8123",

configCLICKHOUSE_USER— "": "default",

configLOG_LEVEL— Set to debug, info, warn, or error (default: info).

🔐 secretMCP_API_KEY— The server supports per-API-key permission scopes via the MCP_AUTH_SCOPES and environment variables. This lets you restrict which tables, columns, and row limits are available per caller.

configMCP_AUTH_SCOPES— The server supports per-API-key permission scopes via the and MCP_API_KEY environment variables. This lets you restrict which tables, columns, and row limits are available per caller.

configMCP_HTTP_PORT

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 5 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/sepfazeli-clickhouse-mcp-server-duhiwa)](https://m8ven.ai/mcp/sepfazeli-clickhouse-mcp-server-duhiwa)

commit: 1d7410492000a516abd1907d319cafbf27c0388e

code hash: 55073a82bf7ec415221076fd5edce693be110c33f959dd1ee3a5d5cbf9fae395

verified: 6/23/2026, 10:39:29 AM

view raw JSON →