ClickHouse/mcp-clickhouse
ClickHouse database integration with schema inspection and query capabilities
Ads
Overview
ClickHouse database integration with schema inspection and query capabilities
Installation
uv run ruff check . # run linting
Configuration
{
"mcpServers": {
"mcp-clickhouse": {
"url": "http://127.0.0.1:8000",
"headers": {
"Authorization": "Bearer your-generated-token"
}
}Capabilities
- Run SQL queries
Ask your assistant to execute read-only SQL against your ClickHouse cluster via `run_query`, with optional write access when enabled.
- Explore databases and tables
Use `list_databases` and `list_tables` to browse schemas, filter table names with `LIKE` patterns, and paginate through results.
- Query data without ETL
Use `run_chdb_select_query` to run SQL directly on files, URLs, or databases using chDB's embedded engine, no data movement required.
- Check server health
Ask your assistant to verify the MCP server's `/health` endpoint returns `200 OK` when connected to ClickHouse, or `503` when unavailable.
Tags
- database
- sql
- analytics
- awesome-list
Related MCP servers
InstantDB
OfficialCreate, manage, and update applications on InstantDB, the modern Firebase.
Jitsu
OfficialManage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.
PostgreSQL MCP Server
OfficialRun read-only SQL queries and inspect PostgreSQL schemas from your MCP client.
Financial Datasets
OfficialStock market API made for AI agents