Skip to main content
Glama
kevinkda

clickhouse-mcp

by kevinkda
OverviewSchemaRelated ServersScoreDiscussions
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

Capabilities

Features and capabilities supported by this server

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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/kevinkda/clickhouse-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server