Advertise
MCP.so
Sign In
Q

QuickBooks MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

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

QuickBooks MCP Server by CData 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"
      ]
    }
  }
}

QuickBooks MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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).

2

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.

3

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.

4

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).

5

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

More Other MCP servers

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K
Advertise