Skip to main content
Glama
stiproot

mcp-clickhouse

by stiproot

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
CHDB_ENABLEDNoEnable/disable chDB functionalityfalse
CHDB_DATA_PATHNoThe path to the chDB data directory:memory:
CLICKHOUSE_HOSTNoThe hostname of your ClickHouse server
CLICKHOUSE_PORTNoThe port number of your ClickHouse server (default: 8443 if HTTPS, 8123 if not)8443
CLICKHOUSE_ROLENoThe role to use for authentication
CLICKHOUSE_USERNoThe username for authentication
CLICKHOUSE_SECURENoEnable/disable HTTPS connectiontrue
CLICKHOUSE_VERIFYNoEnable/disable SSL certificate verificationtrue
CLICKHOUSE_ENABLEDNoEnable/disable ClickHouse functionalitytrue
CLICKHOUSE_DATABASENoDefault database to use
CLICKHOUSE_PASSWORDNoThe password for authentication
CLICKHOUSE_MCP_BIND_HOSTNoHost to bind the MCP server to when using HTTP or SSE transport127.0.0.1
CLICKHOUSE_MCP_BIND_PORTNoPort to bind the MCP server to when using HTTP or SSE transport8000
CLICKHOUSE_CONNECT_TIMEOUTNoConnection timeout in seconds30
CLICKHOUSE_MCP_QUERY_TIMEOUTNoTimeout in seconds for SELECT tools30
CLICKHOUSE_MCP_SERVER_TRANSPORTNoTransport method (stdio, http, sse)stdio
CLICKHOUSE_SEND_RECEIVE_TIMEOUTNoSend/receive timeout in seconds300

Capabilities

Features and capabilities supported by this server

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

Tools

Functions exposed to the LLM to take actions

NameDescription
list_databasesA

List available ClickHouse databases

Args: like: Optional LIKE pattern(s) to filter database names. Can be a single string or list of strings. Multiple patterns are combined with OR logic. not_like: Optional NOT LIKE pattern(s) to exclude database names. Can be a single string or list of strings. Multiple patterns are combined with OR logic.

Returns: JSON array of database names

list_tablesA

List available ClickHouse tables in a database, including schema, comment, row count, and column count.

Args: database: The database to list tables from like: Optional LIKE pattern(s) to filter table names. Can be a single string or list of strings. Multiple patterns are combined with OR logic. not_like: Optional NOT LIKE pattern(s) to exclude table names. Can be a single string or list of strings. Multiple patterns are combined with OR logic. page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas.

Returns: A dictionary containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters

run_select_queryB

Run a SELECT query in a ClickHouse database

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/stiproot/mcp-clickhouse'

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