How to build an AI Agent with Agno and the ClickHouse MCP Server
In this guide you'll learn how to build an Agno 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.
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 DSPy docs
Next, define the credentials needed to connect to the ClickHouse SQL playground:
Initialize MCP Server and Agno agent
Now configure the ClickHouse MCP Server to point at the ClickHouse SQL playground and also initialize our Agno agent and ask it a question: