Exact Online MCP Server by CData

Name: Exact Online MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About Exact Online MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Exact Online (beta): https://www.cdata.com/download/download.aspx?sku=DYZK-V&type=beta

#exact-online #mcp-server #cdata

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\exact-online.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Exact Online MCP Server by CData?

CData's read-only MCP Server that allows LLMs like Claude Desktop to query live Exact Online data using natural language, powered by the CData JDBC Driver for Exact Online which exposes the data as relational SQL models.

How to use Exact Online MCP Server by CData?

Clone the repository, build the JAR with Maven, install and license the CData JDBC Driver for Exact Online, configure the connection string using the driver's utility, create a .prp file with connection properties, then add the server to your Claude Desktop config (claude_desktop_config.json) and restart the client.

Key features of Exact Online MCP Server by CData

Read-only access to live Exact Online data
Natural language querying through AI clients
Provides get_tables, get_columns, and run_query tools
Uses stdio transport – runs on the same machine as the client
Built on the CData JDBC Driver for Exact Online
MIT licensed

Use cases of Exact Online MCP Server by CData

Querying Exact Online data without writing SQL manually
Connecting Claude Desktop to live Exact Online data for natural language analytics
Exploring Exact Online tables and columns via MCP tools
Running custom SQL SELECT queries against Exact Online from AI assistants

FAQ from Exact Online MCP Server by CData

Is this server read-only or does it support writes?

The README states this project builds a read-only MCP server. For full CRUD capabilities, CData offers a separate beta MCP Server.

What runtime does this server require?

It requires Java to run the JAR, and the CData JDBC Driver for Exact Online must be installed and licensed.

How are connections to Exact Online configured?

You use the JDBC Driver’s connection string utility to generate a JDBC URL, then store it in a .prp file along with the driver path, table list, and server details.