Skip to main content
Glama
kevinkda

clickhouse-mcp

by kevinkda
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
CLICKHOUSE_MCP_HOSTYesClickHouse host
CLICKHOUSE_MCP_USERYesClickHouse read-only user
CLICKHOUSE_MCP_DATABASENoClickHouse database (default: usa)usa
CLICKHOUSE_MCP_PASSWORDYesClickHouse password
CLICKHOUSE_MCP_HTTP_PORTNoClickHouse HTTP port (default 8123)8123
CLICKHOUSE_MCP_ALLOW_RAW_SQLNoSet to 'true' to enable raw SQL tool (disabled by default)false

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
get_ohlcvA

Return OHLCV bars for one symbol over [start, end] at frequency.

frequency is one of 1m/5m/15m/1h/1d/1w. start / end are ISO dates (YYYY-MM-DD), inclusive.

get_indicatorsC

Return one technical-indicator series (e.g. ma20, rsi14, macd_hist).

screen_stocksA

Full-market technical-indicator scan.

filters is a list of {indicator, operator, value} where operator is one of gt/gte/lt/lte/eq (e.g. [{"indicator": "rsi14", "operator": "lt", "value": 30}] for an oversold screen). as_of is an ISO date or omitted for latest.

get_correlation_matrixB

Return the pairwise return-correlation matrix for 2-50 symbols.

run_safe_sqlA

Run a single read-only SELECT (DISABLED by default).

Off unless CLICKHOUSE_MCP_ALLOW_RAW_SQL=true. Even when enabled only single read-only SELECT statements are allowed (readonly=1, forced LIMIT, execution-time + result-row guardrails). Prefer the structured tools.

health_checkA

Local health probe + optional ClickHouse reachability check.

get_server_infoA

Local server metadata. Never calls ClickHouse.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A3.6/5.0

Scored across 7 tools

Disambiguation5/5

Each tool has a clear unique purpose: get_correlation_matrix for correlations, get_indicators for single indicator series, get_ohlcv for price data, screen_stocks for market scans, plus server info, health, and raw SQL. No two tools overlap in functionality.

Naming Consistency3/5

Naming uses snake_case but mixes verbs: most start with 'get_' (4 tools), but health_check, run_safe_sql, and screen_stocks use different verb patterns. While readable, the inconsistency could cause minor confusion.

Tool Count5/5

With 7 tools, the set is well-scoped for a financial data server. It covers core operations without being bloated or sparse.

Completeness4/5

The server covers essential read-only financial data operations (OHLCV, indicators, correlations, scanning). A minor gap is the lack of a tool to list available symbols, but the screen_stocks tool can partially compensate. Raw SQL access is available as a fallback.

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources