QuickBooks MCP Server by CData

Name: QuickBooks MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 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

基本信息

分类

其他

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.