clickhouse-mcp-server (sepfazeli/clickhouse-mcp-server) is an MCP server listed on the M8ven Trust Index. It scores 74 out of 100, grade C. It declares 6 tools. No publisher has claimed this listing.

Back to MCP Trust IndexM8ven
C
Emerging
74/100

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

Emerging. No concerning findings. Grades remain capped until the project builds reputation through adoption. Grades reflect the full trust pyramid: code, verification depth, and reputation. New projects cap at C until adoption is earned.

How we verified

Code Verified⚡ Live Monitored: not connected

Verified is a snapshot. Live keeps it current, and builds your track record.

⚡ Connect GitHub → continuous verification on every pushwhy connect →

Who stands behind it

sepfazeli

Source: 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. Or connect your repo for our deepest verification, Live Monitored: read-only, revoke anytime. What we access →

⚡ Connect GitHub for Live Monitored

Install from

Glamanot scored here

The grade above is for the source repository. Registries can serve a different version, so we mark the ones we were not able to read.

// 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.
// tools this server exposes6 tools

These names and descriptions are the publisher's own, read from the source code. We print them as written. Our assessment is the findings above, not this list.

list_tables

List all tables in the connected ClickHouse database with their engine type and row count.

run_query

Execute a read-only SQL query against ClickHouse. Only SELECT, WITH (CTE), SHOW, DESCRIBE, EXISTS, and EXPLAIN statements are allowed. Results are cached for 60s. A maximum row limit of 1000 is enforced (or lower if scoped).

describe_table

Get the schema of a specific ClickHouse table: column names, types, default expressions, and a sample of up to 3 rows.

aggregate

Build and run a time-windowed aggregation query without writing raw SQL. Specify a table, metric column, aggregation function, and optional time column with interval for grouping.

cache_stats

Show query cache statistics: entry count, max entries, and TTL.

clear_cache

Clear all cached query results.

// environment variables
To run this server yourself, you supply these values. They go in your own MCP client configuration and stay on your machine. The secret label means the value is sensitive, not that the server mishandles it.
configCACHE_TTL_MS
configCLICKHOUSE_DATABASE"": "default"
🔐 secretCLICKHOUSE_PASSWORD
configCLICKHOUSE_URL"": "http://localhost:8123",
configCLICKHOUSE_USER"": "default",
configLOG_LEVELSet to debug, info, warn, or error (default: info).
🔐 secretMCP_API_KEYThe 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_SCOPESThe 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
// quality suggestions

All four hints declared on every tool

6/6 tools missing one or more hints — list_tables (missing: idempotentHint, openWorldHint); run_query (missing: idempotentHint, openWorldHint); describe_table (missing: idempotentHint, openWorldHint), +3 more. OpenAI's directory rejects tools where any of the four hints are missing or non-boolean.

For every tool, set all four hints (readOnlyHint, destructiveHint, idempotentHint, openWorldHint) to explicit true/false values that match the handler’s actual behaviour.

Tool inputs are validated

3/6 tool handlers declare input schemas (50%)

Declare an inputSchema with zod/joi/yup on every tool definition.

Tool handlers catch errors

4/6 tool handlers wrap calls in try/catch (67%)

Wrap each tool handler body in try/catch and return a structured error response.

License file

No license file

Add a LICENSE file (MIT, Apache-2.0, etc.).

Tool test coverage

Only 0/6 tools referenced in tests (0%)

Write tests that reference each tool by name so every tool has at least one test.

Claim the listing to review these findings one by one and send us a correction where you disagree, straight to the team. Claiming also means we tell you when the grade moves, and reach you first if we find anything urgent.

// full audit trail
The findings above are the summary. The full trail, every check we ran, each deduction, the network hosts observed and the dependency advisories, goes to verified publishers, along with an alert whenever a new one lands. Verified publishers can also review each finding and dispute it in one click. Publisher corrections have sharpened several of our checks this month, because the maintainer knows the codebase better than any scanner.
// 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)](https://m8ven.ai/mcp/sepfazeli/clickhouse-mcp-server)
Shows your grade and updates automatically. Prefer no grade? Append ?variant=verified to the badge URL.
commit: 1d7410492000a516abd1907d319cafbf27c0388e
code hash: 55073a82bf7ec415221076fd5edce693be110c33f959dd1ee3a5d5cbf9fae395
view raw JSON →
Check MCPs from inside your assistant
Tool Check · MCP

Vetting this one by hand? Tool Check is an MCP that scores other MCPs. Add it once and ask Claude, ChatGPT, or any MCP client to grade a server, surface CVEs, check the publisher, and suggest safer alternatives — before you install.

https://m8ven.ai/api/mcp/tool-check
check_toolsearch_toolscompare_toolsrecommend_alternativescheck_publisherreport_concern
How to add it →Free · no account needed · works in any MCP client