clickhouse
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| CLICKHOUSE_HOST | Yes | ClickHouse 服务器地址，如 http://your-clickhouse-host:8123 | |
| CLICKHOUSE_USER | Yes | ClickHouse 用户名 | |
| CLICKHOUSE_DATABASE | Yes | ClickHouse 数据库名，默认为 default | default |
| CLICKHOUSE_PASSWORD | Yes | ClickHouse 密码 |
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
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesA | List all databases in ClickHouse. |
| list_tablesA | List all tables in a database. |
| describe_tableA | Show column names, types, and default expressions for a table. Also returns the CREATE TABLE statement for full schema details. |
| queryA | Execute a SELECT query and return results as JSON rows. Use for read-only operations only. For DDL or DML use execute instead. |
| executeA | Execute a DDL or DML statement: CREATE TABLE, ALTER TABLE, DROP TABLE, INSERT, UPDATE, DELETE. Returns success/error only — no row results. Use query for SELECT. |
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 5 tools
Each tool serves a distinct purpose: list_databases and list_tables handle exploration, describe_table provides schema details, query is for read-only SELECTs, and execute handles DDL/DML. There is no overlap or ambiguity between them.
All tool names use consistent snake_case with a clear verb-noun pattern (list_*, describe_*, query, execute). The naming is uniform and predictable.
Five tools is well-scoped for a database server covering exploration, schema inspection, and data manipulation. Each tool is necessary and there is no bloat.
The tool surface covers the essential lifecycle of a ClickHouse database: listing databases and tables, inspecting schema, running SELECT queries, and executing all DDL/DML statements. No critical operations appear missing.