QuickBooks MCP Server by CData

@CDataSoftware

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

#quickbooks #mcp-server #data-access

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\\quickbooks.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 QuickBooks MCP Server by CData?

QuickBooks MCP Server by CData is a read-only MCP server that lets large language models like Claude Desktop query live data from QuickBooks using natural language. It wraps the CData JDBC Driver for QuickBooks, which exposes QuickBooks data as relational SQL models, making it accessible through a standard MCP interface without requiring SQL knowledge.

How to use QuickBooks MCP Server by CData?

Clone the repository, build the JAR with Maven (mvn clean install), download and license the CData JDBC Driver for QuickBooks, then create a .prp file with your JDBC connection string and driver details. Configure your MCP client (e.g., Claude Desktop) to launch the JAR with the .prp file. The server runs over stdio and exposes tools for listing tables, listing columns, and executing SELECT queries. Ask natural language questions like "How many open tickets do I have?" and the LLM will use the tools automatically.

Key features of QuickBooks MCP Server by CData

Read-only access to live QuickBooks data
Natural language queries via LLM clients
Exposes QuickBooks data as relational tables
Provides get_tables, get_columns, and run_query tools
Uses CData JDBC Driver for connectivity
MIT-licensed open-source project

Use cases of QuickBooks MCP Server by CData

Allow an AI assistant to answer questions about QuickBooks financial records
Enable business users to query QuickBooks data without writing SQL
Integrate QuickBooks insights into AI-powered analytics workflows
Prototype data access before moving to a full read-write solution

FAQ from QuickBooks MCP Server by CData

Is the server read-only or can I write data?

The server is read-only. For full CRUD and actions, CData offers a separate beta MCP server for QuickBooks (free).

What dependencies are required?

You need Java, Apache Maven, and a licensed CData JDBC Driver for QuickBooks installed on the same machine as the MCP client.

How do I connect to QuickBooks?

Create a .prp file with the JDBC driver path, driver class, and connection string (obtained via the CData JDBC driver’s connection string utility). The connection string typically includes OAuth settings for QuickBooks.

What transport does the server use?

The server uses stdio transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop).

Where does the data live?

The data stays in QuickBooks; the server queries it in real time through the JDBC driver—no data is copied or stored by the server.

Frequently asked questions

Is the server read-only or can I write data?

The server is read-only. For full CRUD and actions, CData offers a separate beta MCP server for QuickBooks (free).

What dependencies are required?

You need Java, Apache Maven, and a licensed CData JDBC Driver for QuickBooks installed on the same machine as the MCP client.

How do I connect to QuickBooks?

Create a `.prp` file with the JDBC driver path, driver class, and connection string (obtained via the CData JDBC driver’s connection string utility). The connection string typically includes OAuth settings for QuickBooks.

What transport does the server use?

The server uses `stdio` transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop).

Where does the data live?

The data stays in QuickBooks; the server queries it in real time through the JDBC driver—no data is copied or stored by the server.

Comments

Basic information

More Other MCP servers

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K