Skip to main content
Skip to main content
Edit this page

How to build a LlamaIndex AI agent using ClickHouse MCP Server

In this guide, you'll learn how to build a LlamaIndex AI agent that can interact with ClickHouse's SQL playground using ClickHouse's MCP Server.

Example notebook

This example can be found as a notebook in the examples repository.

Prerequisites​

  • You'll need to have Python installed on your system.
  • You'll need to have pip installed on your system.
  • You'll need an Anthropic API key, or API key from another LLM provider

You can run the following steps either from your Python REPL or via script.

Install libraries​

Install the required libraries by running the following commands:

Setup credentials​

Next, you'll need to provide your Anthropic API key:

Using another LLM provider

If you don't have an Anthropic API key, and want to use another LLM provider, you can find the instructions for setting up your credentials in the LlamaIndex "LLMs" docs

Initialize MCP Server​

Now configure the ClickHouse MCP Server to point at the ClickHouse SQL playground. You'll need to convert those from Python functions into Llama Index tools:

Create an agent​

You're now ready to create an agent that has access to those tools. Set the maximum number of tool calls in one run to 10. You can modify this parameter if you want:

Initialize the LLM​

Initialize the Claude Sonnet 4.0 model with the following code:

Run the agent​

Finally, you can ask the agent a question:

The response back is long, so it has been truncated in the example response below: