ClickHouse (Vector Search) MCP Server

Connect your ClickHouse cluster to any AI agent and take full control of your analytical and vector data through natural conversation.

What you can do

• Schema Management — List databases and tables, and inspect deep column schemas including specialized Array(Float32) vector types
• SQL Execution — Push arbitrary DML, DDL, or SELECT queries to your cluster to manage data and generate real-time reports
• Vector Search — Identify mathematical distance traces using cosineDistance or L2Distance metrics for high-dimensional semantic search
• Cluster Monitoring — Extract internal structural states, row counts, and compression ratios to audit cluster health
• Capability Auditing — Check instance versions and binary limits to identify exact capability branches like HNSW support

How it works

1. Subscribe to this server
2. Enter your ClickHouse URL (Cloud or self-hosted), Username, and Password
3. Start querying your analytical data from Claude, Cursor, or any MCP-compatible client

Who is this for?

• Data Analysts — generate complex analytical reports and execute SQL queries using natural language
• AI Developers — test and debug vector similarity searches and semantic matching without writing boilerplate code
• Database Administrators — monitor table statistics, compression ratios, and cluster versions across environments
• Product Teams — quickly verify analytical data and vector distributions during the prototyping phase