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
ClickHouse at DoorDash
How DoorDash monitors TCP and DNS traffic helping their observability team take care of their kubernetes infrastructure.
Open House NYC: Keynote
Keynote from Open House Roadshow NYC 2025.
Open House NYC: ClickHouse for AI/ML
Zach Naimon, Principal Product Manager at ClickHouse
