In-memory analytics with the chDB MCP Server

Mark Needham

In this video, we explore the exciting new chDB feature of the ClickHouse MCP server. CHDB is a fast, in-process SQL OLAP engine powered by ClickHouse, allowing you to harness ClickHouse's capabilities without running a separate server. We'll demonstrate how to use the ClickHouse MCP server in CHDB mode with Claude Desktop, showcasing its power and flexibility.

Key points covered:

• Setting up and configuring the ClickHouse MCP server with CHDB
• Using Jeff Sackman's tennis dataset to run queries and analyze data
• Demonstrating CHDB's ability to fetch and process CSV files on the fly
• Exploring Novak Djokovic's performance across multiple years (2015, 2021, 2023)
• Creating charts and visualizations based on query results

This tutorial offers a practical look at how chDB can enhance your data analysis workflow, making it easier than ever to run ClickHouse queries directly in conversations with LLMs.

• chDB - https://clickhouse.com/docs/chdb
• Integrating MCP - https://clickhouse.com/blog/integrating-clickhouse-mcp