Can my agent perform high-speed vector similarity searches?

Yes. Provide the database, table, and the vector embedding array in JSON format. The agent uses ClickHouse's native distance functions (cosine or L2) to return the closest matches, leveraging ClickHouse's industry-leading OLAP performance.

Can I execute arbitrary SQL commands directly through the agent?

Absolutely. The 'execute_sql' tool allows you to push any valid ClickHouse SQL (DML, DDL, or SELECT) to your cluster. This is perfect for managing tables, updating records, or generating custom analytical reports on the fly.

How do I check if my ClickHouse instance supports HNSW indices?

Ask your agent to get the version details. The agent checks your ClickHouse build and identifies exactly which capability branches are active, confirming if advanced vector features like HNSW support are available in your runtime environment.

ClickHouse (Vector Search) MCP Server

Name: ClickHouse (Vector Search)
Availability: InStock
Author: Vinkius

clickhouse.com

Built by Vinkius GDPR ToolsGrátis

Manage vector embeddings and SQL via ClickHouse — list databases, execute SQL, and perform high-speed vector searches directly from any AI agent.

Vinkius AI Gateway suporta streamable HTTP e SSE.

Funciona com todos os agentes de IA que você já usa

…e qualquer cliente compatível com MCP

ClickHouse MCP Server: veja o seu AI Agent em ação

AI Agent→Vinkius→ClickHouse (Vector Search)

You

Vinkius AI Gateway

GDPR·High Security·Kill Switch·Ultra-Low Latency·Plug and Play

Capacidades integradas (7)

describe_table

Perform structural extraction of properties driving active column schemas

execute_sql

Provision a highly-available SQL execution pushing arbitrary arbitrary DML/DDL or SELECTs

get_table_stats

Extracts explicitly attached internal structural states pulling cluster health

get_version

g. HNSW support). Identify precise active cluster limits spanning the execution runtime

list_databases

Identify bounded logical arrays managing top-level ClickHouse schemas

list_tables

Retrieve the exact structural matching verifying table limits inside a database

vector_search

Identify explicit mathematical distance traces routing Vector Embeddings

O que esse conector desbloqueia

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

Perguntas frequentes

Dê aos seus agentes de IA o poder do ClickHouse

Acesse o ClickHouse e mais de 2.000 servidores MCP — prontos para seus agentes usarem, agora mesmo. Sem código cola. Sem integrações customizadas. Apenas plugue o Vinkius AI Gateway e deixe seus agentes trabalharem.

DETALHES

CategoriaAi Frontier

Luma AI (Generative Video & Creative)

10 ferramentas

Generate cinematic AI videos and images via Luma — use Dream Machine for text-to-video, image-to-video, and professional camera control.

Typesense Vector Search

6 ferramentas

Automate vector similarity searches via Typesense — index documents, manage collections, and execute semantic queries directly from your AI agent.

CrewAI Platform

10 ferramentas

Orchestrate multi-agent workflows via CrewAI — list crews and agents, kickoff autonomous runs, and monitor task execution directly from any AI agent.

Prismic

10 ferramentas

Query and manage your Prismic headless CMS content — search documents, list custom types, and retrieve specific content directly from any AI agent.

Ometria Email Events

10 ferramentas

Track and analyze email engagement events via Ometria — monitor opens, clicks, and bounces directly from your AI agent.

freee

9 ferramentas

Manage Japanese accounting and business via freee — track deals and invoices, handle partners and expenses, and audit tax codes directly from any AI agent.