cfm-dwh-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| host | No | ClickHouse host | |
| port | No | HTTP port (usually 8123) | |
| user | No | ClickHouse user | |
| database | No | Default database (default analytics) | analytics |
| password | No | ClickHouse password | |
| CLICKHOUSE_HOST | No | ClickHouse host (alias for host) | |
| CLICKHOUSE_PORT | No | HTTP port (alias for port) | |
| CLICKHOUSE_USER | No | ClickHouse user (alias for user) | |
| CLICKHOUSE_DATABASE | No | Default database (alias for database, default analytics) | analytics |
| CLICKHOUSE_PASSWORD | No | ClickHouse password (alias for password) |
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": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| pingA | Health check: MCP alive; optionally verifies ClickHouse connectivity. |
| list_allowed_tablesA | List ClickHouse tables this MCP server is allowed to query (read-only). |
| query_clickhouseC | TODO NIK-17: run a read-only parameterized query against allowlisted analytics tables. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 3 tools
ping, list_allowed_tables, and query_clickhouse have clearly distinct purposes: health check, table discovery, and query execution. There is no overlap that would cause an agent to misselect.
All names are lowercase snake_case and verb-led, giving a consistent style. ping is a standalone verb rather than a verb_noun pair, but this is a minor and conventional deviation for a health check.
Three tools is small but well-scoped for a read-only ClickHouse gateway: connectivity check, allowlist discovery, and query execution. Each tool has a necessary and distinct role.
The core read-only workflow is covered: verify connectivity, list allowed tables, and run parameterized queries. The main gap is schema or column introspection, since list_allowed_tables exposes table names but not their structure.