mcp-clickhouse

Official

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 to connect to the ClickHouse server
CLICKHOUSE_PASSWORDYesThe password to connect to 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