v0.5.0
mcp-clickhouse v0.5.0
This release improves HTTP transport security, query execution reliability, multi-user request isolation, and result handling. It includes breaking HTTP/SSE configuration changes.
Before upgrading
- HTTP/SSE now validates
HostandOriginby default. Wildcard binds requireCLICKHOUSE_MCP_ALLOWED_HOSTS. - Reverse proxies should preserve
Host. Otherwise configureCLICKHOUSE_MCP_TRUSTED_PROXIES. /healthremains unauthenticated and exempt from Host and Origin validation.CLICKHOUSE_ALLOW_DROPnow also gates destructiveDELETE,UPDATE, partition, column, clear, replace, and permanent detach operations.CLICKHOUSE_SEND_RECEIVE_TIMEOUTis capped relative to the MCP query timeout unless explicitly configured.
Highlights
- Reuse ClickHouse clients across tool calls and attempt server-side cancellation after query timeouts. (#152)
- Add DNS rebinding protection across HTTP, SSE,
fastmcp run, andfastmcp.json. (#226) - Safely support trusted reverse proxies and
X-Forwarded-Host. (#230) - Preserve request-scoped ClickHouse configuration overrides across executor threads. (#221)
- Expand destructive query protection and avoid false positives inside strings, identifiers, and comments. (#220)
- Return integers outside JavaScript's safe range as decimal strings. (#210)
- Reject invalid
list_tablespage sizes. (#229) - Add clearer diagnostics for ClickHouse port and TLS configuration errors. (#212)
This release remains on FastMCP 2 and the MCP 2025-11-25 protocol. FastMCP 4 and MCP 2026-07-28 support are tracked in #218.
docker pull ghcr.io/clickhouse/mcp-clickhouse:0.5.0Full Changelog: v0.4.1...v0.5.0