ClickHouse
Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
Connector by alyiox · GitHub account verified by the MCP Registry
Chalk Labs
Need help deploying ClickHouse?
Chalk Labs sets up agents like this inside real teams: connected to your tools, tested on your data, with a human in the loop where it matters.
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.
About
Reviews
Write a reviewNo 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_querylist_profilesrun_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 (18 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
More from alyiox
- 0.550score
Sam's Club Sponsored Ads APIs (deprecated)
alyiox
Deprecated; use io.github.alyiox/mcp-walmart-ads.
ConnectorAFreshness: ALocal★ 2↓ 55/wkClaude Code +5 - 0.550score
Walmart & Sam's Club APIs
alyiox
MCP server for Walmart Connect Ads, Sam's Club Sponsored Ads, and Walmart Marketplace APIs
ConnectorAFreshness: ALocal★ 2↓ 145/wkClaude Code +5 - 0.550score
Microsoft SQL Server
alyiox
MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.
ConnectorAFreshness: ALocal★ 9Claude Code +5 - 0.548score
Walmart Marketplace APIs (deprecated)
alyiox
Deprecated; use io.github.alyiox/mcp-walmart-ads.
ConnectorAFreshness: ALocal★ 2↓ 37/wkClaude Code +5 - 0.545score
Documentation Search
alyiox
Local RAG MCP for markdown documentation.
ConnectorAFreshness: ALocal↓ 125/wkClaude Code +5 - 0.534score
OpenAPI Services
alyiox
MCP server that fronts any OpenAPI service: discover operations from its spec and call them
ConnectorAFreshness: ALocal↓ 106/wkClaude Code +5
Done for you
Rather not set it up yourself?
Chalk Labs scopes, builds and runs agents for your team: the task audit, the eval harness, the integrations and the weekly ops report. Fixed scope, priced before we start.
See how we build AI agents →Read the case studies
Chalk Labs is a two-founder AI and growth studio. We build AI agents, CRMs and MVPs for Web3 and AI companies, and have shipped 50+ product and token launches.
- launches shipped
- 50+
- launches shipped
- media placements
- 500+
- media placements
- founders on every account
- 2
- founders on every account
Press we've placed: Forbes · CoinDesk · Decrypt · Cointelegraph · The Block
Rahil Jain, Co-founder, Chalk Labs. Ex-Goldman Sachs engineer. You talk to the person who builds it.
Get ClickHouse running in your business
Tell us what you want to automate. A founder replies within one working day with a plan, not a pitch deck.
Cite this page
ClickHouse MCP server. Agent Mart. https://agentmart.dev/connectors/alyiox-mcp-clickhousex (last updated 2026-10-25)