Skip to content
Agentmart
Submit a tool

ClickHouse

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

Connector by alyiox · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 1
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/alyiox-mcp-clickhousex

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list, install config and code. Checked Oct 25, 2026.

Tools
3 read · 0 write · 1 delete
Secrets
1 (API keys, tokens or passwords)
Install scripts
None found
Runs as
Python package

Tools by what they do 4

Read from the source code; the running server may list different tools.

Read 3 · Look things up without changing anything.

  • analyze_query
  • list_profiles
  • run_query

Delete 1 · Delete, drop, revoke or wipe things.

  • run_command

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

  • MCP_CLICKHOUSE_DSN

Network hosts it talks to 1

  • github.com · found in code

Files it touches

  • Your home directory (~)
  • ~/.cache/mcp-clickhousex/snapshots

Tools (4)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • analyze_query

    [ClickHouse] Explain read-only SELECT. Indexes names only the keys the plan used; confirm absent keys from system.tables (primary_key, sorting_key, partition_key).

  • list_profiles

    [ClickHouse] List configured connection profiles.

  • run_command

    [ClickHouse] Execute one write statement (DDL/DML). Needs a write-enabled profile; refused on read-only ones, the default. There is no transaction to roll back in. For reads use run_query.

  • run_query

    [ClickHouse] Execute read-only SELECT or SHOW.

Signals

Stars
1
Forks
0
Open issues
0
Weekly downloads
65
Last commit
Oct 13, 2026 (15 days ago)
Last release
Sep 20, 2026 (1 month ago)
Last package publish
Sep 22, 2026 (1 month ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.alyiox/mcp-clickhousex
Version
0.11.0
Auth
API key
Packages
pypi mcp-clickhousex
License
MIT
Repository
github.com/alyiox/mcp-clickhousex
First seen
Oct 24, 2026
Last checked
Oct 25, 2026
Source
Official MCP Registrygithub-graphql

More from alyiox

Cite this page

ClickHouse MCP server. Agent Mart. https://agentmart.dev/connectors/alyiox-mcp-clickhousex (last updated 2026-10-25)