Skip to main content
This guide explains how to use the ClickHouse MCP server with Jan.ai.
1

​
Install Jan.ai

Jan.ai is an open source ChatGPT-alternative that runs 100% offline. You can download Jan.ai for Mac, Windows, or Linux.It’s a native app, so once it’s downloaded, you can launch it.
2

​
Add LLM to Jan.ai

We can enabled models via the settings menu.To enable OpenAI, we need to provide an API key, as shown below:
3

​
Enable MCP servers

At the time of writing, MCP servers are an experimental feature in Jan.ai. We can enable them by toggling experimental features:Once that toggle is pressed, we’ll see MCP servers on the left menu.
4

​
Configure ClickHouse MCP server

If we click on the MCP servers menu, we’ll see a list of MCP servers that we can connect to:There servers are all disabled by default, but we can able them by clicking the toggle.To install the ClickHouse MCP server, we need to click on the + icon and then populate the form with the following:Once we’ve done that, we’ll need to toggle the ClickHouse Server if it’s not already toggled:The ClickHouse MCP server’s tools will now be visible on the chat dialog:
5

​
Chat to ClickHouse MCP server with Jan.ai

It’s time to have a conversation about some data stored in ClickHouse! Let’s ask a question:Jan.ai will ask confirmation before calling a tool:It will then show us the list of tool calls that were made:If we click on the tool call, we can see the details of the call:And then underneath, we have our result:
Last modified on June 23, 2026