MCP guides

This page provides an intro to Model Context Protocol (MCP) and has a table of contents for MCP guides.

Model Context Protocol (MCP) is a standard developed by Anthropic that enables AI assistants to seamlessly integrate with external systems. This protocol allows AI assistants to connect to data sources, APIs, databases, and more in a secure and standardized way.

MCP creates a universal interface between AI models and various services, eliminating the need for custom tool implementations for each integration. You can think of it as a universal API standard designed specifically for AI systems.

The key advantage of MCP is that AI libraries only need to implement support for the protocol once. After that, all MCP-compatible services become immediately accessible, saving AI library maintainers a lot of time.

What is MCP’s architecture?

MCP follows a client-server architecture:

• Clients (like Claude Desktop, Cursor, or VS Code) establish connections with MCP servers. You can see a collection of clients in the awesome-mcp-clients GitHub repository.
• Servers expose tools and capabilities through standardized interfaces. You can see a collection of servers in the awesome-mcp-servers GitHub repository.
• AI models can then use these tools to access external data and functionality when needed

A diagram showing the architecture is below:

Does ClickHouse have an MCP server?

It does! The ClickHouse MCP server offers the following tools:

• run_select_query - Execute SQL queries on your ClickHouse cluster.
• list_databases - List all databases on your ClickHouse cluster.
• list_tables - List all tables in a database.

If you’re looking for a remote MCP server in ClickHouse Cloud, see page “Remote MCP server in Cloud”

Agent Skills

The ClickHouse Agent Skills repo provides packaged instructions that extend AI coding agents (Claude Code, Cursor, Copilot, etc.) with domain-specific expertise. This repository provides skills for ClickHouse databases—covering schema design, query optimization, and data ingestion patterns.

Guides for using the ClickHouse MCP server

Below are some guides showing how to use the ClickHouse MCP server.

Page	Description
How to build a ClickHouse-backed AI Agent with Streamlit	Learn how to build a web-based AI Agent with Streamlit and the ClickHouse MCP server
How to build a LangChain/LangGraph AI agent using ClickHouse MCP server.	Learn how to build a LangChain/LangGraph AI agent that can interact with ClickHouse’s SQL playground using ClickHouse’s MCP server.
How to build a LlamaIndex AI agent using ClickHouse MCP server.	Learn how to build a LlamaIndex AI agent that can interact with ClickHouse MCP server.
How to build a PydanticAI agent using ClickHouse MCP server.	Learn how to build a PydanticAI agent that can interact with ClickHouse MCP server.
How to build a SlackBot agent using ClickHouse MCP server.	Learn how to build a SlackBot agent that can interact with ClickHouse MCP server.
How to build an AI Agent with Agno and the ClickHouse MCP server	Learn how build an AI Agent with Agno and the ClickHouse MCP server
How to build an AI Agent with Chainlit and the ClickHouse MCP server	Learn how to use Chainlit to build LLM-based chat apps together with the ClickHouse MCP server
How to build an AI Agent with Claude Agent SDK and the ClickHouse MCP server	Learn how build an AI Agent with Claude Agent SDK and the ClickHouse MCP server
How to build an AI Agent with CopilotKit and the ClickHouse MCP server	Learn how to build an agentic application using data stored in ClickHouse with ClickHouse MCP and CopilotKit
How to build an AI Agent with CrewAI and the ClickHouse MCP server	Learn how build an AI Agent with CrewAI and the ClickHouse MCP server
How to build an AI Agent with DSPy and the ClickHouse MCP server	Learn how to build an AI agent with DSPy and the ClickHouse MCP server
How to build an AI Agent with mcp-agent and the ClickHouse MCP server	Learn how build an AI Agent with mcp-agent and the ClickHouse MCP server
How to build an AI Agent with Microsoft Agent framework and the ClickHouse MCP server	Learn how build an AI Agent with Microsoft Agent framework and the ClickHouse MCP server
How to build an AI Agent with Upsonic and the ClickHouse MCP server	Learn how build an AI Agent with Upsonic and the ClickHouse MCP server
How to build an OpenAI agent using ClickHouse MCP server.	Learn how to build an OpenAI agent that can interact with ClickHouse MCP server.
Set up ClickHouse MCP server with Ollama	This guide explains how to set up Ollama with a ClickHouse MCP server.
Using ClickHouse MCP server with AnythingLLM	This guide explains how to set up AnythingLLM with a ClickHouse MCP server using Docker.
Using ClickHouse MCP server with Claude Desktop	This guide explains how to set up Claude Desktop with a ClickHouse MCP server.
Using 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 LibreChat	This guide explains how to set up LibreChat with a ClickHouse MCP server using Docker.
Using ClickHouse MCP server with Open WebUI	This guide explains how to set up Open WebUI with a ClickHouse MCP server using Docker.