Exact Online MCP Server by CData

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.

What transport does the server use?

The server uses stdio and can only be used with clients that run on the same machine.

How are the tools named in the client?

The tools are named using the Prefix from your .prp file (e.g., exact_get_tables, exact_get_columns, exact_run_query).