QuickBooks Time MCP Server by CData
@CDataSoftware
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 Time (beta): https://www.cdata.com/download/download.aspx?sku=HCZK-V&type=beta
Overview
What is QuickBooks Time MCP Server by CData?
A read-only MCP (Model Context Protocol) server that enables LLMs like Claude Desktop to query live QuickBooks Time data using natural language, powered by the CData JDBC Driver for QuickBooks Time.
How to use QuickBooks Time MCP Server by CData?
Clone the repository, build the server with Maven, install and license the CData JDBC Driver for QuickBooks Time, configure a connection string using the driver’s utility, create a .prp property file with JDBC details, then add the server to Claude Desktop’s claude_desktop_config.json. Run or refresh the client to start querying.
Key features of QuickBooks Time MCP Server by CData
- Read-only access to QuickBooks Time data
- Natural language querying through LLM clients
- Tools:
get_tables,get_columns,run_query - Uses CData JDBC Driver for QuickBooks Time
- Supports stdio transport (local client required)
Use cases of QuickBooks Time MCP Server by CData
- Ask Claude Desktop about timesheet entries or projects
- Retrieve employee time data without writing SQL
- Explore QuickBooks Time schema and columns interactively
- Integrate QuickBooks Time into AI-driven workflows
FAQ from QuickBooks Time MCP Server by CData
Is this server read-only?
Yes, this MCP server is read-only. For full CRUD capabilities, use the free CData MCP Server for QuickBooks Time (beta).
What are the runtime requirements?
Java Runtime Environment (JRE) is required. The server runs locally and communicates via stdio.
How do I configure the connection?
Use the CData JDBC Driver’s connection string utility to generate a JDBC URL with OAuth or other credentials, then store it in a .prp file.
Where does the data live?
Data remains in QuickBooks Time; the server queries it live via the JDBC driver. No local data is stored.
What transport does the server use?
The server uses stdio transport and can only be used with clients running on the same machine.