MCP.so
Sign In
A

Acumatica MCP Server by CData

@CDataSoftware

Repository

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

Category

Other

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

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.

Comments

More Other MCP servers

Awesome Mcp Servers

punkpeye

A collection of MCP servers.

90.5K

Nginx UI

0xJacky

Yet another WebUI for Nginx

11.3K

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

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

Awesome-MCP-ZH

yzfly

MCP 资源精选， MCP指南，Claude MCP，MCP Servers, MCP Clients

7.4K