After spending the past 3 days trying to connect to clickhouse via this server from Claude Desktop, there are some things that tripped me up that were not obvious from the documentation but did not present with very helpful errors. Only 1 of these (apart from the other issue I raised) are related to ClickHouse MCP as opposed to FastMCP!
The Environment variables like CLICKHOUSE_SECURE are not clearly described to relate to the database connection. I thought these were for the MCP connection and disabled it since I am running in Kubernetes behind an ingress. You then get an error in the server logs which is not easy to decipher when it attempts to connect to the database over http to an https port.
This with many other issues I mostly had to debug via the code. I would happy to raise a PR if you accept them from strangers, otherwise should be simple enough fix.
Thanks
After spending the past 3 days trying to connect to clickhouse via this server from Claude Desktop, there are some things that tripped me up that were not obvious from the documentation but did not present with very helpful errors. Only 1 of these (apart from the other issue I raised) are related to ClickHouse MCP as opposed to FastMCP!
The Environment variables like
CLICKHOUSE_SECUREare not clearly described to relate to the database connection. I thought these were for the MCP connection and disabled it since I am running in Kubernetes behind an ingress. You then get an error in the server logs which is not easy to decipher when it attempts to connect to the database over http to an https port.This with many other issues I mostly had to debug via the code. I would happy to raise a PR if you accept them from strangers, otherwise should be simple enough fix.
Thanks