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.

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

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

Inbox Zero AI

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K