> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Using ClickHouse MCP server with AnythingLLM
> This guide explains how to set up AnythingLLM with a ClickHouse MCP server using Docker.
export const Image = ({img, alt, size = "lg"}) => {
const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
return
;
};
> This guide explains how to set up [AnythingLLM](https://anythingllm.com/) with a ClickHouse MCP server using Docker
> and connect it to the ClickHouse example datasets.
You will need Docker to run LibreChat and the MCP server. To get Docker:
1. Visit [docker.com](https://www.docker.com/products/docker-desktop)
2. Download Docker desktop for your operating system
3. Install Docker by following the instructions for your operating system
4. Open Docker Desktop and ensure it is running
For more information, see the [Docker documentation](https://docs.docker.com/get-docker/).
Run the following command to pull the AnythingLLM Docker image to your machine:
```bash theme={null}
docker pull anythingllm/anythingllm
```
Create a directory for storage and initialize the environment file:
```bash theme={null}
export STORAGE_LOCATION=$PWD/anythingllm && \
mkdir -p $STORAGE_LOCATION && \
touch "$STORAGE_LOCATION/.env"
```
Create the `plugins` directory:
```bash theme={null}
mkdir -p "$STORAGE_LOCATION/plugins"
```
Create a file called `anythingllm_mcp_servers.json` in the `plugins` directory and add the following contents:
```json theme={null}
{
"mcpServers": {
"mcp-clickhouse": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-clickhouse",
"--python",
"3.10",
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "sql-clickhouse.clickhouse.com",
"CLICKHOUSE_USER": "demo",
"CLICKHOUSE_PASSWORD": ""
}
}
}
}
```
If you want to explore your own data, you can do so by
using the [host, username and password](/docs/get-started/setup/cloud#connect-with-your-app)
of your own ClickHouse Cloud service.
Run the following command to start the AnythingLLM Docker container:
```bash theme={null}
docker run -p 3001:3001 \
--cap-add SYS_ADMIN \
-v ${STORAGE_LOCATION}:/app/server/storage \
-v ${STORAGE_LOCATION}/.env:/app/server/.env \
-e STORAGE_DIR="/app/server/storage" \
mintplexlabs/anythingllm
```
Once that's started, navigate to `http://localhost:3001` in your browser.
Select the model that you want to use and provide your API key.
Click on the tool icon in the bottom left-hand side of the UI:
Click on `Agent Skills` and look under the `MCP servers` section.
Wait until you see `Mcp ClickHouse` set to `On`
We're now ready to start a chat.
To make MCP servers available to a chat, you'll need to prefix the first message in the conversation with `@agent`.