Best ClickHouse MCP Servers
ClickHouse is an open-source, high performance columnar OLAP (online analytical processing) database management system for real-time analytics using SQL.
Why this server?
Runs read-only ClickHouse SELECT queries over Ironflow's Hyperliquid tables, enabling SQL-based analysis of fills, wallets, funding, prices, open interest, liquidations, transfers, and vault operations.
AlicenseAqualityBmaintenanceRead-only Hyperliquid market data for AI agents: trades, liquidations, funding, open interest, candles, wallet analytics and SQL over every fill since May 2025. 36 tools, hosted, no install, no key needed.4462,595 npm1MITWhy this server?
Allows querying local and remote ClickHouse databases with full ClickHouse SQL syntax and functions, including federation via remoteSecure().
Why this server?
Allows executing SQL queries on a ClickHouse cluster and retrieving information about databases and tables. It provides tools to run SELECT queries, list databases, and list tables in a database.

mcp-clickhouseofficial
AlicenseAqualityAmaintenanceClickHouse database integration with schema inspection and query capabilities3911Apache 2.0Why this server?
Plans to support ClickHouse as an additional analytical database engine.
Why this server?
Provides agent access to saved ClickHouse connections for running SQL queries, browsing data, and inspecting schemas, subject to the connection's configured read-only or read/write permissions.

platypus-dbofficial
AlicenseAqualityBmaintenanceThe MCP server of PlatypusDB, an open source desktop SQL client: agents use the database connections saved in the app (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, DuckDB, Snowflake and more) with the access set for each one, read-only by default, and every change waits for approval in the app.249AGPL 3.0Why this server?
Enables dbprint to connect to and profile ClickHouse databases, capturing table DDL, joins, and per-column statistics for offline agent context.
AlicenseAqualityBmaintenanceGives an AI agent a database's tables, columns, value lists, null shares and joins from a dbprint snapshot committed to your repo, with no database connection or credentials. Tools list and search tables and columns, render prompt-ready context for a table, resolve a filter value to its stored spelling, and report what changed since the last snapshot.47195 PyPI4Apache 2.0Why this server?
Provides architecture-aware visual styling for ClickHouse database components within Excalidraw diagrams.
AlicenseBqualityCmaintenanceAn MCP server that generates beautiful Excalidraw architecture diagrams with perfect auto-layout, stateful editing, and architecture-aware component styling.226219 PyPI164MITWhy this server?
Geocode address columns in ClickHouse workflows, enriching analytical tables with coordinates from a local country sheet.

gridpin-mcpofficial
AlicenseAqualityBmaintenanceOffline geocoding and reverse geocoding for AI agents, with no API key: list countries, download a country file once (checked against a signed release), then geocode addresses and coordinates on the machine. Covers the United States, Canada, Germany (without Bavaria), France, Italy, Spain, Australia, Mexico, the Netherlands, Brazil and Serbia; run with uvx gridpin-mcp.54Apache 2.0Why this server?
Provides on-chain SQL queries across 13 blockchains using ClickHouse tables via the blockrun_surf tool.

BlockRun MCPofficial
AlicenseAqualityAmaintenanceProvides Claude with real-time access to markets, research, X/Twitter, and crypto data via a unified pay-per-call system with no API keys.191,379 npm390MIT