MCP.so
登录
E

Exact Online MCP Server by CData

@CDataSoftware

基本信息

分类

其他

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 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 by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

Exact Online MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

1

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.

2

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.

3

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.

4

What transport does the server use?

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

5

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`).

评论

其他 分类下的更多 MCP 服务器