Acumatica MCP Server by CData

Name: Acumatica MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About 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

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.