quickbooks-online-mcp-server-by-cdata

What is quickbooks-online-mcp-server-by-cdata?

quickbooks-online-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server built by CData that allows LLMs like Claude Desktop to query live QuickBooks Online data using natural language. It wraps the CData JDBC Driver for QuickBooks Online, which exposes QuickBooks Online data as relational SQL models, so no SQL is required from the user.

How to use quickbooks-online-mcp-server-by-cdata?

Clone the repository, build the JAR with Maven (mvn clean install), download and license the CData JDBC Driver for QuickBooks Online, create a .prp file with your connection details, and configure your MCP client (e.g., Claude Desktop) using the claude_desktop_config.json file. The server runs via java -jar CDataMCP-jar-with-dependencies.jar <path-to-.prp> and communicates over stdio.

Key features of quickbooks-online-mcp-server-by-cdata

• Read-only access to live QuickBooks Online data
• Natural language querying – no SQL required
• Exposes data as relational SQL models
• Provides MCP tools: get_tables, get_columns, run_query
• Local MCP server – runs on the same machine as the client

Use cases of quickbooks-online-mcp-server-by-cdata

• Ask your AI assistant about QuickBooks Online invoices, customers, or accounts
• Generate real-time business reports without manual SQL queries
• Integrate QuickBooks Online data into conversational AI workflows (e.g., Claude Desktop)

FAQ from quickbooks-online-mcp-server-by-cdata

Is this server read-only?

Yes, this MCP server is read-only. For full read, write, update, delete, and action capabilities, see the CData MCP Server for QuickBooks Online or the managed CData Connect AI platform.

How do I set up the server?

Clone the repo, build with Maven, install and license the CData JDBC Driver for QuickBooks Online, create a .prp file with your connection string, and configure your MCP client (e.g., Claude Desktop) to use the JAR with that properties file.

What transport does it use?

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

What tools are available?

Three tools: {prefix}_get_tables (list tables), {prefix}_get_columns (list columns for a table), and {prefix}_run_query (execute a SQL SELECT query).

What license does the server use?

This MCP server is licensed under the MIT License.