Schema | MCP ClickHouse

MCP ClickHouse

Describes the environment variables required to run the server.

Name	Required	Description	Default
`CLICKHOUSE_HOST`	No	ClickHouse server hostname (e.g., localhost, your-instance.clickhouse.cloud)
`CLICKHOUSE_PORT`	No	8443 for HTTPS, 8123 for HTTP	8443
`CLICKHOUSE_USER`	No	Username for authentication
`CLICKHOUSE_SECURE`	No	Enable HTTPS connection	true
`CLICKHOUSE_VERIFY`	No	Verify SSL certificates	true
`CLICKHOUSE_DATABASE`	No	Default database to use	default
`CLICKHOUSE_PASSWORD`	No	Password for authentication
`CLICKHOUSE_READONLY`	No	Enable read-only mode (true: Only SELECT/SHOW/DESCRIBE queries allowed, false: All SQL operations permitted)	true
`CLICKHOUSE_CLOUD_KEY_ID`	No	ClickHouse Cloud API key ID (from ClickHouse Cloud Console)
`CLICKHOUSE_CLOUD_API_URL`	No	API endpoint	https://api.clickhouse.cloud
`CLICKHOUSE_CLOUD_TIMEOUT`	No	Request timeout	30
`CLICKHOUSE_CLOUD_READONLY`	No	Cloud operation mode (true: Only read operations like list, get, metrics; false: All cloud operations permitted including create, update, delete)	false
`CLICKHOUSE_CONNECT_TIMEOUT`	No	Connection timeout in seconds	30
`CLICKHOUSE_CLOUD_KEY_SECRET`	No	ClickHouse Cloud API key secret (from ClickHouse Cloud Console)
`CLICKHOUSE_CLOUD_SSL_VERIFY`	No	SSL verification	true
`CLICKHOUSE_SEND_RECEIVE_TIMEOUT`	No	Query timeout in seconds	300

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.

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
No tools

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

This server cannot be deployed

ActivityInactive

ResponsivenessNo issues