New to CloverDX? This is the best place to start! This fly by walk-through will guide you through fundamentals of CloverDX and teach you the basics along the way.
CloverDX Server diagnostics with ChatGPT or Claude via MCP
Administrating a healthy CloverDX Server usually means correlating information scattered across performance logs, job tracking tables, execution logs, configuration files, and deployment metadata. When performance degrades or jobs behave anomalously, the hardest part is often not fixing the problem but finding it.
Starting with CloverDX 7.3, CloverDX ships an MCP (Model Context Protocol) server that lets MCP-capable desktop clients (Claude Desktop and ChatGPT Desktop) connect to your CloverDX Server, and instead of manually digging through logs and metrics, you can use a conversational interface backed by live Server data to analyze performance, detect risky jobs, and identify configuration issues before they reach production.
If you’re on CloverDX 6.0–7.2, you can still use the same capability without upgrading your production installation by using a lightweight proxy architecture with just an “MCP Bridge” library installed on the legacy Server.
Why LLM-powered diagnostics matters for administrators and support engineers
As an administrator, you are responsible for reliability, performance, and predictability of your CloverDX Server. However, lots of incidents are not caused by a single obvious error, but rather by combinations of factors:
Gradually increasing memory pressure or Java garbage collector issues
Configuration mismatches
Jobs whose runtime characteristics change over time
Execution patterns that only look suspicious when compared with their “bigger picture history”
Log signals spread across multiple different log files and subsystems
MCP-enabled can change your triage workflow to a conversational investigation:
You can ask high-level questions (“What changed?”, “Where is the bottleneck?”, “Is this failure new?”) and let the AI pull the right diagnostics data in the background.
You can easily spot patterns and identify “slow creep” (memory pressure increasing run over run) or step-changes after a deployment.
You can proactively identify risks (memory, performance, configuration) before outages occur.
You can produce a summary you can hand to your team with the evidence attached or even ask AI to use of built-in MCP tools that sends the summary to CloverDX’s product support team.
What you can ask
Below are example questions you can ask in your ChatGPT/Claude client once MCP is configured. They’re phrased like an operator would phrase them during an incident, and they’re designed to trigger the MCP tools that retrieve the necessary evidence.
1) “Show me potential configuration issues with my CloverDX Server”
Use this when you suspect misconfiguration, drift between environments, or an unexpected deployment setup. The AI can combine deployment description + log sampling to flag:
suspicious JVM/memory/GC symptoms in performance logs,
misaligned settings between nodes (in clustered setups),
“works in test, fails in prod” differences that are visible in deployment/config metadata.
2) “Analyze this specific job execution (Run ID …)”
Use this for targeted failures or slow runs. The LLM can pull the execution log + tracking history and highlight:
the first meaningful error (vs. cascading noise),
where time was spent relative to baseline,
whether the failure mode is new or recurring.
3) “Compare the last 5 executions of Job X and detect anomalies”
This is the most time-saving pattern for regression diagnosis:
Compare run durations, resource signals (from performance logs), and error patterns.
Identify “slow creep” (memory pressure increasing run over run) or step-changes after a deployment.
Produce a short summary you can hand to your team (or support) with the evidence attached.
4) “Analyze Server performance bottlenecks around 02:00–03:00”
Use this for capacity and stability work:
Sample performance logs for CPU/memory/GC pressure signatures,
correlate with job tracking in the same time window,
suggest which jobs are high-risk (e.g., memory-heavy patterns that predict future OOMs).
How it works: MCP tools exposed by CloverDX
CloverDX MCP exposes a set of structured tools that LLMs can call through the MCP protocol. Instead of scraping logs or guessing, the LLM queries the CloverDX Server directly using well-defined interfaces.
The currently available tools (as of CloverDX 7.3) include:
Describe Current Deployment – Describes your current Server environment and configuration
List Server Logs – Lists and filters available Server log files
Retrieve Job Log – Retrieves job execution logs
List Performance Logs – Samples performance metrics and resource usage
Retrieve Job Tracking – Fetches job run history and tracking data
Execute Database Query – Executes SQL queries against the CloverDX database
Retrieve Database Schema – Fetches the CloverDX database schema
Send Support Email – Sends reports directly to CloverDX support
Report Support Issue – Reports issues to the CloverDX customer portal
From your perspective, you simply ask questions. The LLM decides which tools to call, retrieves the relevant data, and presents a synthesized analysis.
On CloverDX 7.3+, MCP support is available out of the box, controlled by configuration properties in clover.properties (Configuration > Setup in Server Console).
On CloverDX 6.0–7.2, MCP is enabled via:
An auxiliary instance of CloverDX 7.3+ acting as a “proxy server” (you can install it on your laptop for example) that accepts MCP client connections, and
the CloverDX MCP Bridge library installed on the legacy CloverDX Server to expose compatible APIs via Data Services.
In other words: the AI client always talks to a 7.3+ MCP endpoint (native or proxy), while your legacy server stays on your preferred proven version.
Install a supported desktop client (Claude Desktop or ChatGPT Desktop).
Enable MCP on your CloverDX Server (in clover.properties or Configuration > Setup):
clover.mcp.enabled=true
By default, MCP uses OAuth2 (recommended for production). Anonymous access exists for testing/dev convenience or when acting as a proxy for older versions.
Install the CloverDX MCP extension file (CloverDX-MCP.mcpb from Customer Portal Downloads) into your desktop client and point it to your MCP endpoint (e.g. https://your-server:port/clover/mcp/mcp).
Configure authentication:
If OAuth2 is enabled, provide a bearer token (Claude flow supports this).
For ChatGPT Desktop, a premium ChatGPT plan is required and “OAuth2 [is] not currently supported” in that setup flow as of CloverDX 7.3
CloverDX 6.0 to 7.2 (no upgrade required)
This is the “retrofit” path: keep production on its current version, add an MCP façade.
Here's a short video that shows you how to enable MCP for versions of CloverDX older than 7.3.
Install CloverDX MCP Bridge library on the legacy server (compatible “From CloverDX 6.0 to CloverDX 7.2”) from CloverDX Marketplace.
Initialize the CloverDX MCP Bridge library
Install and run a separate CloverDX Server 7.3+ instance (e.g. on your laptop) as an MCP proxy and configure it to connect remotely to the legacy server:
# Enable MCP functionality
clover.mcp.enabled=true
# Proxy scenario: anonymous access is commonly used on the proxy,
# but treat this like any other security decision in your environment.
clover.mcp.anonymous.access.enabled=true
# Remote connection to the legacy server
clover.mcp.remote.enabled=true
clover.mcp.remote.url=https://your-target-server.example.com/clover
clover.mcp.remote.user=mcp-bridge-user
clover.mcp.remote.password=your-secure-password
This proxy/legacy architecture and the exact property names are documented in the MCP setup guide.
Activate this proxy server with a free “MCP-only” license is available from the Customer Portal.
Point your desktop client extension at the proxy Server (clients connect to proxy, not directly to the legacy server).
Summary
CloverDX MCP gives you a practical way to apply LLM reasoning to real operational data. Instead of manually correlating logs, metrics, and job history, you can ask focused questions and receive actionable insights backed by structured server queries.
For administrators and support engineers, this means:
Faster root-cause analysis
Earlier detection of performance and stability risks
Less time spent on repetitive diagnostics
A conversational interface over complex server internals
If maintaining a reliable CloverDX installation is part of your responsibility, MCP-enabled LLM access turns server diagnostics from a manual task into a guided, efficient workflow.
As our first set of examples, we published a project called DataQualityExamples which demonstrates how users can address their data quality issues with... CloverDX How-To
We’re excited to introduce the CloverDX Examples repository on GitHub. The repository is a growing collection of helpful and practical examples designed to... CloverDX How-To
There are many situations where it is helpful to get a message from your active pipelines. These may include logs, summaries of successful completion, or... Cloud
Connecting to REST APIs is a crucial aspect of modern data integration, and the REST Connector in CloverDX provides a streamlined approach. The video below... RESTConnector
Performance is undoubtedly one of the key factors when running data transformations. In this article, we will look at how to troubleshoot database-related... Performance
We frequently get a question what a CloverDX Cluster is, how it works and advise around configuration. So let me shed some light on it as I’ll try to explain some core principles. Before we start it may be useful to introduce some basic CloverDX Cluster...
As more and more companies move towards cloud or container deployments, CloverDX has introduced a number of features, supporting both an infrastructure as code approach or templating. As some of these features may not be obvious, I’d like to summarize...