ClickHouse Connector for AI agents.
4 live capabilities
Run analytical SQL queries and manage big data schemas through natural language.
Waiting for input…
Why people use ClickHouse
ClickHouse for Big Data Analytics
This Connector removes that middleman. You just tell your agent what you're looking for. It handles the SQL generation and fetches the data, presenting it to you in a clean format. You get your answers in seconds without ever leaving your workspace.
What Vinkius changes
It turns your big data warehouse into a conversational interface for your agent.
Use it from Claude, ChatGPT, Cursor or another AI client you already have.
One account · 5,900+ Connectors
- Real-world use case 01
Quick Revenue Summary
An analyst asks for the top 10 products by revenue.
- Real-world use case 02
Schema Verification
A developer needs to see if a new table is ready.
- Real-world use case 03
Cluster Health Check
A DevOps lead notices a slow dashboard and asks the agent to check for replication lag to see if a node is falling behind.
Complete set · 4capabilities
The complete ClickHouse capability set.
These are the exact actions your AI can choose when you ask it to work with ClickHouse.
01—04
4 capabilities in this set.
Part of 4 available through ClickHouse.
- 01 Capability
Execute query
Perform mutating operations like creating or altering tables and databases.
- 02 Capability
Ping
Quickly check if your ClickHouse instance is online and responding to requests.
- 03 Capability
Replicas status
Check the delay across your ClickHouse replicas to ensure data consistency.
- 04 Capability
Select query
Run read-only SELECT queries with automatic safety limits to protect your data.
Set up in minutes
One URL. Then ask ClickHouse to work.
Claude and ChatGPT only need the Connector URL. Copy it once, add it in settings, and use ClickHouse from the conversation.
Choose your client
Live previewAdvanced clients IDE · CLI
Claude · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp - Step 01
Open Connectors
In Claude Web or Claude Desktop, open Settings and choose Connectors.
- Step 02
Add the URL
Choose Add custom connector, name it ClickHouse, and paste the URL above.
- Step 03
Turn it on in chat
Select +, open Connectors, and enable ClickHouse for the conversation.
ChatGPT · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp - Step 01
Open MCP settings
On desktop, open Settings and MCP servers. On web, open your workspace app or connector settings.
- Step 02
Add the URL
Choose Add server with Streamable HTTP, or create a custom MCP app, then paste the ClickHouse URL.
- Step 03
Save and start
Save the connection and enable ClickHouse in your conversation. Desktop may ask you to restart once.
Cursor · IDE configuration
Advanced setup
{
"mcpServers": {
"clickhouse": {
"url": "https://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp"
}
}
}- Step 01
Open MCP Settings
Press Cmd+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux) → search "MCP Settings"
- Step 02
Add the server config
Paste the JSON configuration above into the mcp.json file that opens
- Step 03
Save the file
Cursor will automatically detect the new Connector
- Step 04
Start using ClickHouse
Open Agent mode in chat and ask: "Using ClickHouse, help me...". 4 tools available
VS Code Copilot · IDE configuration
Advanced setup
{
"mcpServers": {
"clickhouse": {
"url": "https://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp"
}
}
}- Step 01
Create MCP config
Create a .vscode/mcp.json file in your project root
- Step 02
Add the server config
Paste the JSON configuration above
- Step 03
Enable Agent mode
Open GitHub Copilot Chat and switch to Agent mode using the dropdown
- Step 04
Start using ClickHouse
Ask Copilot: "Using ClickHouse, help me...". 4 tools available
Windsurf · IDE configuration
Advanced setup
{
"mcpServers": {
"clickhouse": {
"url": "https://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp"
}
}
}- Step 01
Open MCP Settings
Go to Settings → MCP Configuration or press Cmd+Shift+P and search "MCP"
- Step 02
Add the server
Paste the JSON configuration above into mcp_config.json
- Step 03
Save and reload
Windsurf will detect the new server automatically
- Step 04
Start using ClickHouse
Open Cascade and ask: "Using ClickHouse, help me...". 4 tools available
Cline · IDE configuration
Advanced setup
{
"mcpServers": {
"clickhouse": {
"url": "https://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp"
}
}
}- Step 01
Open Cline MCP Settings
Click the Connectors icon in the Cline sidebar panel
- Step 02
Add remote server
Click "Add Connector" and paste the configuration above
- Step 03
Enable the server
Toggle the server switch to ON
- Step 04
Start using ClickHouse
Ask Cline: "Using ClickHouse, help me...". 4 tools available
Claude Code · Terminal command
Advanced setup
claude mcp add clickhouse --transport http "https://edge.vinkius.com/vk_preview_vh45Xvmk8E2B7cahxxnRmSHdcoQUTkiyCXVcszPX/mcp"- Step 01
Install Claude Code
Run npm install -g @anthropic-ai/claude-code if not already installed
- Step 02
Add the Connector
Run the command above in your terminal
- Step 03
Verify the connection
Run claude mcp to list connected servers, or type /mcp inside a session
- Step 04
Start using ClickHouse
Ask Claude: "Using ClickHouse, show me...". 4 tools are ready
Where the request belongs
Work ClickHouse can move forward.
The data engineer who's tired of context-switching between SQL IDEs and Slack, or the analyst who wants to query millions of rows without learning complex syntax.
Data Engineer
Inspecting table schemas and row counts during a migration without leaving the chat.
Data Analyst
Running complex aggregations on massive datasets to get instant summaries for a report.
DevOps Engineer
Verifying cluster health and replication status during a production incident at 2am.
Build the capability set
Add more capabilities.
Each Connector adds new actions and data without changing how you work.
Browse ConnectorsStarRocks
High-performance analytical database. manage clusters, tables, and query data via AI.
ClickHouse (Vector Search)
Manage vector embeddings and SQL via ClickHouse. list databases, execute SQL, and perform high-speed vector searches directly from any AI agent.
Materialize (Streaming SQL DB)
Execute streaming SQL, manage compute clusters, and monitor real-time data pipelines directly from your AI agent.
Snowflake
Execute SQL queries, manage databases, and analyze data on Snowflake with AI agents.
QuestDB (Time-Series)
High-performance time-series database for fast SQL queries, data ingestion, and real-time analytics directly from your AI agent.
Amazon Redshift
Equip your AI to directly query, analyze, and manage your petabyte-scale data warehouse via the serverless AWS Redshift Data API.
Bring your own AI
Change the model, client or framework. Keep ClickHouse connected.
-
Claude -
ChatGPT -
Gemini -
Cursor -
VS Code -
Windsurf -
ZCode -
Cline -
Zed -
Continue -
Kiro -
Roo Code -
Zencoder -
Goose -
Void -
Augment Code -
Amp -
Qodo -
Tabnine -
Pieces -
Sourcegraph Cody -
JetBrains -
Warp -
Amazon Q -
Antigravity -
BoltAI -
Raycast -
Jan -
LM Studio -
AnythingLLM -
Open WebUI -
Msty -
Cherry Studio -
LibreChat -
TypingMind -
Chorus -
5ire -
n8n -
LangChain -
LlamaIndex -
CrewAI -
Vercel AI SDK
Before you connect
Questions about ClickHouse.
The practical details behind the request, access and result.
What does the ClickHouse MCP do for my data?
It lets you talk to your ClickHouse database using plain English. Your agent can run queries, manage your tables, and check the health of your cluster automatically.
Can I use the ClickHouse MCP to change my database schema?
Yes. You can ask your agent to create, alter, or drop tables and databases using the execute_query capability.
Is it safe to run queries through this Connector?
Yes, it's designed with safety in mind. The select_query capability automatically enforces a read-only mode to prevent accidental changes during your analysis.
How does the ClickHouse MCP help with monitoring?
It allows your agent to check if the instance is online with ping and monitor replication lag across your cluster with replicas_status.
Can I use this with my existing ClickHouse setup?
Yes. You just need to provide your ClickHouse URL, username, and password in the configuration to connect your agent.
Does the ClickHouse MCP work for big data analytics?
That's exactly what it's built for. It's optimized to help you run complex aggregations and get summaries from large OLAP datasets quickly.
Can I safely run analytical queries without accidentally modifying data?
Yes. The select_query capability is strictly read-only and automatically enforces the readonly=1 setting, ensuring that only SELECT, SHOW, and DESCRIBE operations are permitted.
How do I check if my ClickHouse cluster is healthy and synchronized?
You can use the ping capability to check server reachability and the replicas_status capability to inspect replication delays and the status of your replicas.
Is it possible to create new tables or insert data using this server?
Yes. For mutating operations like INSERT, CREATE, or ALTER, use the execute_query action. This capability allows you to modify the database schema and manage data records.
One connection away
Give your agent a direct line to ClickHouse.
Connect ClickHouse once. Keep it beside 5,900+ managed Connectors when the next task needs more.
Explore every Connector No credit card required · Free tier available