home / mcp / intacct mcp server

Intacct MCP Server

This read-only MCP Server allows you to connect to Intacct data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-intacct-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/intacct.prp"
      ]
    }
  }
}

You can run a local, read-only MCP server that exposes live Intacct data to large language models via a simple MCP interface. This lets you ask natural-language questions about your Intacct data and receive up-to-date results without writing SQL. It wraps the CData JDBC Driver for Intacct and serves data locally through the MCP protocol.

How to use

Once the MCP server is running, you connect an MCP client to the local stdio-based server. You can then ask questions about the Intacct data, such as counts, aggregations, or what-if questions across accounts, departments, or projects. Use the client’s built-in tools to discover which tables and columns are available, and to execute read-only queries that return results in natural language responses.

How to install

Prerequisites: you need a Java runtime and Maven installed on your machine to build and run the MCP server.

1. Clone the project and enter the directory.

2. Build the server.

3. Prepare the JDBC driver for Intacct, license it, and configure a connection. You will create a .prp file with the required properties for the MCP server to connect to Intacct.

4. Run the MCP server using the prepared .prp file.

Additional notes and steps

The server runs via standard input/output, so it can be used with MCP clients on the same machine. You will provide a Java command to start the server with your prepared .prp file. You can configure a client (for example Claude Desktop) to load your MCP server by pointing it at this local stdio server configuration. You can then use the built-in tools to retrieve table and column information and to run read-only queries against Intacct.

Example workflow you will perform in practice: prepare a .prp with your JDBC connection, start the MCP server, and then ask your AI client to fetch data, generate summaries, or compare metrics across accounts or periods.

Troubleshooting and tips

If the MCP server does not appear in your client, ensure you fully exit and restart the client so it can detect the new local MCP server. Verify your .prp contains a valid JDBC URL and that the Java command to start the server points to the correct jar and .prp file. If you encounter connection issues, ensure the Intacct connection string was generated correctly and that the required authentication (OAuth if used) completed successfully.

Available tools

intacct_get_tables

Retrieves a list of tables available in the data source. Output is CSV with headers in the first line.

intacct_get_columns

Retrieves a list of columns for a specified table. Output is CSV with headers in the first line.

intacct_run_query

Executes a SQL SELECT query against the connected data source and returns the results.