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.