ClickHouse MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
CLICKHOUSE_HOSTYesThe host address of the ClickHouse server.
CLICKHOUSE_PORTYesThe port number of the ClickHouse server.
CLICKHOUSE_USERYesThe username for accessing the ClickHouse server.
CLICKHOUSE_PASSWORDYesThe password for accessing the ClickHouse server.

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
list_databases
list_tables
run_select_query