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
Scaling ClickHouse to petabytes of logs at OpenAI
How ClickHouse helps Anthropic scale observability
How Capital One Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
