ClickHouse (Vector Search) MCP Connector for Claude

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