mcp-clickhouse

gemiit/mcp-clickhouse

3.1

If you are the rightful owner of mcp-clickhouse and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

MCP-ClickHouse Server is a minimal yet powerful Model Context Protocol server that provides a structured interface to interact with a single-instance ClickHouse database.

Tools

Functions exposed to the LLM to take actions

query

Execute arbitrary SQL and stream results.

insert

Bulk-insert rows in structured format.

create_database

Create a new database.

create_table

Create a table with specified engine, columns, etc.

server_info

Return ClickHouse version, uptime, databases, etc.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources