Exact Online MCP Server by CData

Name: Exact Online MCP Server by CData
Author: CDataSoftware

@CDataSoftware

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

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

CDataSoftware

投稿者

Cameron Leblanc

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.