Set up ClickHouse MCP server with Jan.ai

This guide explains how to set up Jan.ai with a ClickHouse MCP server.

Using ClickHouse MCP server with Jan.ai

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: