> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-home-button.mintlify.site/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}) => {
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.
Install Docker
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/).
Pull AnythingLLM Docker image
Run the following command to pull the AnythingLLM Docker image to your machine:
```bash theme={null}
docker pull anythingllm/anythingllm
```
Setup storage location
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](/get-started/setup/cloud#connect-with-your-app)
of your own ClickHouse Cloud service.
Start the AnythingLLM Docker container
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.
Wait for MCP servers to start up
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`
Chat with ClickHouse MCP server with AnythingLLM
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`.