8000 Add chDB Support to MCP ClickHouse Server by wudidapaopao · Pull Request #51 · ClickHouse/mcp-clickhouse · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Add chDB Support to MCP ClickHouse Server #51

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 9 commits into from
Jun 25, 2025

Conversation

wudidapaopao
Copy link
Contributor

This PR introduces comprehensive support for chDB (an embedded SQL OLAP engine) alongside the existing ClickHouse functionality.

  • New run_chdb_select_query tool for executing SQL queries using chDB's embedded engine
  • Flexible configuration allowing ClickHouse-only, chDB-only, or combined usage, new environment variables: CHDB_ENABLED , CHDB_DATA_PATH , CLICKHOUSE_ENABLED
  • Added chDB prompt
  • Added chdb>=3.3.0 to project dependencies

@wudidapaopao wudidapaopao force-pushed the add-chdb-mcp branch 3 times, most recently from f60e02c to 79a6153 Compare June 10, 2025 07:05
@wudidapaopao
Copy link
Contributor Author

Hi @iskakaushik , would you mind taking a look at this PR when you have a chance? This PR adds support for chDB alongside the existing ClickHouse functionality, I'd really appreciate your feedback. Thanks!

@iskakaushik
Copy link
Collaborator

@wudidapaopao -- Yup, I will take a look in the next couple of days. @serprex could you give a first look as well please?

@wudidapaopao wudidapaopao force-pushed the add-chdb-mcp branch 2 times, most recently from 3f72965 to 8bb3049 Compare June 18, 2025 11:08
@auxten
Copy link
Member
auxten commented Jun 20, 2025

@iskakaushik @serprex Pls have a look again.

Copy link
Collaborator
@iskakaushik iskakaushik left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@wudidapaopao LGTM! Please rebase and we'll merge this!

- Add chDB embedded OLAP engine integration
- Implement run_chdb_select_query tool
- Add new configurations (CHDB_ENABLED, CHDB_DATA_PATH)
- Create comprehensive chDB prompt
- Enable hybrid deployments with independent ClickHouse/chDB operation
@@ -1,5 +1,5 @@
# Build stage - Use a Python image with uv pre-installed
FROM ghcr.io/astral-sh/uv:python3.13-alpine AS builder
FROM ghcr.io/astral-sh/uv:python3.13-bookworm AS builder
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

why is this necessary?

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@serprex This is because chDB does not currently support Alpine Linux as a runtime environment.

@iskakaushik iskakaushik merged commit c0af32c into ClickHouse:main Jun 25, 2025
2 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants
0