Acumatica MCP Server by CData

Name: Acumatica MCP Server by CData
Author: CDataSoftware

@CDataSoftware

Acumatica 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 Acumatica (beta): https://www.cdata.com/download/download.aspx?sku=OIZK-V&type=beta

#acumatica #mcp-server #data-access

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

CDataSoftware

投稿者

Cameron Leblanc

設定

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

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

ツール

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

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

概要

What is Acumatica MCP Server by CData?

The Acumatica MCP Server by CData is a read-only Model Context Protocol (MCP) server that enables large language models (LLMs) such as Claude Desktop to query live Acumatica data using natural language questions. It wraps the CData JDBC Driver for Acumatica, which exposes Acumatica data as relational SQL models, and serves data through a simple MCP interface without requiring SQL expertise.

How to use Acumatica MCP Server by CData?

Clone the repository, build it with mvn clean install, download and license the CData JDBC Driver for Acumatica, and configure a .prp file with connection details (prefix, driver path, JDBC URL, etc.). Then add the server to the Claude Desktop config file (claude_desktop_config.json) with the path to the JAR and .prp file, and restart the client. The server runs locally using stdio transport.

Key features of Acumatica MCP Server by CData

Enables LLMs to query live Acumatica data with natural language.
Exposes Acumatica as relational SQL models via JDBC driver.
Provides tools: get_tables, get_columns, and run_query.
Supports all Acumatica tables and columns accessible through the driver.
Configurable with a property file for custom table access.

Use cases of Acumatica MCP Server by CData

Ask LLMs for sales trends or closed won opportunities in Acumatica.
Retrieve open support tickets from an Acumatica project.
Check calendar events or inventory levels without writing SQL.
Analyze correlations between account industries and opportunity outcomes.

FAQ from Acumatica MCP Server by CData

Is the Acumatica MCP Server by CData read-only?

Yes, this server is explicitly read-only. For full create, read, update, delete, and action capabilities, CData offers a separate beta MCP Server for Acumatica with a simplified setup.

What dependencies are required to run the server?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Acumatica (requires installation and licensing).

How does the server connect to Acumatica?

It uses a JDBC connection string configured in a .prp file. The connection string can be generated using the CData JDBC Driver’s built-in Connection String utility.

What transport protocol does the server use?

The server uses stdio transport, so it can only be used with MCP clients that run on the same machine as the server.

Where can I get help or report issues?

For connection problems, contact CData Support. For MCP server feedback, join the CData Community. Basic troubleshooting includes fully quitting and restarting the client and verifying the connection string.

「その他」の他のコンテンツ

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K