• STATS
  • CONFIG
  • LISTS
  • HUMAN

How to monitor ClickHouse cluster health with your AI

Connect your AI to your ClickHouse instance to pull real-time performance data. Once linked, your agent handles the queries while you look over the results.

Ask AI about this page

Short answer

How can I check my ClickHouse cluster health using AI?

Your AI client pulls table statistics, database lists, and version info directly from your cluster. You get row counts and compression ratios without writing manual SQL. This gives you a clear view of your storage and configuration.

Where your data lands.

The outcomes of your queries.

Your agent processes your requests and organizes the findings into these categories.

STATS

Storage metrics

The AI pulls row counts and compression ratios. You see exactly how much space your data occupies.

CONFIG

Version details

The agent checks your current version and limits. You can confirm your cluster is running the right setup.

LISTS

Database inventory

The AI scans your environment to list all databases. You get a quick map of what's hosted.

HUMAN

Manual changes

The AI cannot modify your schema or settings. You must perform any writes or configuration updates yourself.

The workflow

What your AI does when the request arrives.

The AI acts as a bridge between your questions and the ClickHouse system tables.

  1. Map the environment

    The agent identifies all available databases to understand your cluster's scope.

    list_databases

  2. Verify versioning

    The AI checks the current ClickHouse version to ensure it matches your requirements.

    get_version

  3. Pull table metrics

    The agent retrieves row counts and compression ratios for specific tables.

    get_table_stats

  4. Compare data

    The AI uses the gathered stats and version info to highlight potential issues.

    get_table_statsget_version

Try it

Copy these to start.

Use these prompts to begin monitoring your cluster.

Starting points

Swap the names in quotes for your actual database or table names.

ClickHouse Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_567ij3B5hJvT6KRM8Z5LcFbGNttrwDvwD2OPp6c2/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — ClickHouse capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "clickhouse-vector-search-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_567ij3B5hJvT6KRM8Z5LcFbGNttrwDvwD2OPp6c2/mcp"
    }
  }
}
Copy into chat04

  • List all the databases in my ClickHouse cluster.

  • What is the current version of my ClickHouse instance?

  • Get the row counts and compression ratios for the 'events' table.

  • Check the stats for all tables in the 'analytics' database.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect ClickHouse once, then ask.

Link your instance once and your credentials stay encrypted. You can then start asking questions in any compatible client.

Connect ClickHouse to your AI

FAQ

How this task behaves.

  • 01

    Can the AI change my database settings?

    No. The AI only reads data and statistics. It cannot execute write commands or change configurations.

  • 02

    Can I use this to run custom SQL queries?

    No. The AI is limited to the specific tools provided for stats, versioning, and listing databases.

  • 03

    Does the AI have permission to delete tables?

    No. There are no tools available for deleting or dropping any database objects.

  • 04

    Can the AI see my actual row data?

    No. The AI only accesses metadata and statistics like row counts and compression ratios.

  • 05

    How do I specify a certain table?

    You just name the table in your prompt, and the AI uses the stats tool to find it.

  • More questions about ClickHouse? The Connector page answers them. See everything the ClickHouse Connector can do

Connect ClickHouse to Claude, Cursor, ChatGPT & more