intacct-mcp-server-by-cdata

What is intacct-mcp-server-by-cdata?

intacct-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server from CData that lets large language models (LLMs) like Claude Desktop query live data from Sage Intacct using natural language. It wraps the CData JDBC Driver for Intacct, which exposes Intacct data as relational SQL tables, so no SQL knowledge is required.

How to use intacct-mcp-server-by-cdata?

Clone the repository, build with Maven (mvn clean install), install and license the CData JDBC Driver for Intacct, then create a .prp configuration file with properties such as Prefix, ServerName, DriverPath, DriverClass, and JdbcUrl. Finally, add the server to your LLM client’s config file (e.g., Claude Desktop's claude_desktop_config.json) and restart the client. The server exposes tools like {servername}_get_tables, {servername}_get_columns, and {servername}_run_query.

Key features of intacct-mcp-server-by-cdata

• Read-only MCP server for live Sage Intacct data
• Powered by the CData JDBC Driver for Intacct
• Exposes Intacct tables and columns as LLM-friendly tools
• Supports natural-language querying via any MCP-compatible client
• Uses stdio transport, so client and server must run on the same machine
• Licensed under MIT; free to use, modify, and distribute

Use cases of intacct-mcp-server-by-cdata

• Query live Intacct data through Claude Desktop without writing SQL
• Ask natural-language questions about financial records, projects, or tickets
• Integrate Intacct reporting into AI-driven analytics workflows

FAQ from intacct-mcp-server-by-cdata

What does this server do vs the full CData MCP Server for Intacct?

This server is read-only. The separate, free beta CData MCP Server for Intacct supports full read, write, update, delete, and action capabilities with a simplified setup.

What dependencies are required to run the server?

You need Java, Apache Maven (to build), and the CData JDBC Driver for Intacct installed and licensed on the same machine.

Where does the data live? Does the server store my data?

No, the server does not store any data. It queries live Intacct data on each request via the JDBC driver.

What transport protocol does the server use?

The server uses stdio, so it only works with LLM clients running on the same machine as the server process.

How do I authenticate to Intacct?

Authentication is configured in the JDBC connection string (e.g., with OAuth) using the CData JDBC Driver’s Connection String utility. You copy the resulting string into the .prp file’s JdbcUrl property.