mcp-clickhousex
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_CLICKHOUSE_DSN | Yes | Connection DSN (required). Example: http://user:password@host:8123/database | |
| MCP_CLICKHOUSE_DESCRIPTION | No | Optional description for the default profile (tooling/AI discovery) | |
| MCP_CLICKHOUSE_QUERY_MAX_ROWS | No | Optional max rows per interactive query (default 500; hard ceiling 1000) | |
| MCP_CLICKHOUSE_SNAPSHOT_MAX_ROWS | No | Optional max rows for snapshot queries (default 10000; hard ceiling 50000) | |
| MCP_CLICKHOUSE_QUERY_COMMAND_TIMEOUT_SECONDS | No | Optional interactive query timeout in seconds (default 30; hard ceiling 300) | |
| MCP_CLICKHOUSE_SNAPSHOT_COMMAND_TIMEOUT_SECONDS | No | Optional snapshot query timeout in seconds (default 120; hard ceiling 300) |
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
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_profilesA | [ClickHouse] List configured profiles. Each entry includes name and optional description. |
| get_cluster_propertiesA | [ClickHouse] Get cluster properties and execution limits. Returns ClickHouse server version plus enforced limits (max rows, timeouts) for the profile. |
| run_queryA | [ClickHouse] Execute read-only SELECT or WITH … SELECT. One statement; DML, DDL, SET, SYSTEM, and similar are rejected. Max-rows cap; overflow sets truncated and row_limit. Same SQL validation as analyze_query. Returns |
| run_showA | [ClickHouse] Execute SHOW introspection statement. One statement per call; INTO OUTFILE rejected. Interactive row limits apply (default 500, hard ceiling 1 000). Same timeout as run_query. |
| analyze_queryA | [ClickHouse] Explain read-only SELECT or WITH … SELECT. Returns plan, pipeline, and/or syntax text. Default types plan and pipeline. Uses query timeout and optional database; no max-rows cap unlike run_query. |
| list_databasesB | [ClickHouse] List databases. Rows from system.databases visible to the connection. |
| list_tablesA | [ClickHouse] List tables and views in a database. Rows from system.tables: name, engine, primary_key, sorting_key, partition_key, total_rows, total_bytes for query planning. |
| list_columnsA | [ClickHouse] List columns for a table or view. Rows from system.columns for the resolved database and table. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| profiles | [ClickHouse] List configured profiles. Each entry includes name and optional description. |
TDQS
Scored across 8 tools
Each tool has a distinct purpose: listing profiles, cluster properties, running SELECT queries, running SHOW statements, analyzing queries, and listing databases, tables, and columns. No overlap in functionality.
Uses snake_case consistently, but mixes verb prefixes: 'list_', 'get_', 'run_', 'analyze_'. The pattern is somewhat predictable within categories (metadata listing uses 'list_', execution uses 'run_'), but not fully uniform.
8 tools is well-scoped for a read-only ClickHouse client. Covers metadata discovery, query execution, and analysis without unnecessary tools.
Covers essential read-only operations: metadata listing, SELECT, SHOW, and EXPLAIN. Lacks DDL/DML support, but that is intentional. Minor gap: no tool to retrieve table DDL or status.