Quickbooks Online By Cdata MCP Server

CData JDBC Driver connects to QuickBooks Online by exposing them as relational SQL models.

Remote serverstreamable-http

What is the Quickbooks Online By Cdata MCP server?

Most database access work still happens through a UI a human drives. Quickbooks Online By Cdata MCP server moves it into the conversation instead. CData JDBC Driver connects to QuickBooks Online by exposing them as relational SQL models.

Getting it running

Because this one is hosted, setup is mostly authentication — you point your client at the endpoint and approve access. Nothing runs on your machine, so there is no runtime to keep patched.

The tools it exposes

The server publishes 3 tools. What each one is for:

  • quickbooks_online_get_tables — The quickbooks_online_get_tables tool exposed by this server
  • quickbooks_online_get_columns — The quickbooks_online_get_columns tool exposed by this server
  • quickbooks_online_run_query — The quickbooks_online_run_query tool exposed by this server

Things to watch

  • Your data travels to the provider's service, so the usual questions apply about what you send and what they retain.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

How it compares

Plenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Quickbooks Online By Cdata's toolset — quickbooks_online_get_tables, quickbooks_online_get_columns, quickbooks_online_run_query — is a fair guide to whether it matches your workflow. It is maintained by CDataSoftware; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Available tools

ToolWhat it does
quickbooks_online_get_tablesThe quickbooks_online_get_tables tool exposed by this server.
quickbooks_online_get_columnsThe quickbooks_online_get_columns tool exposed by this server.
quickbooks_online_run_queryThe quickbooks_online_run_query tool exposed by this server.

How to install the Quickbooks Online By Cdata MCP server

**Linux/Mac**
      ```json
      {
        "mcpServers": {
          "{classname_dash}": {
            "command": "/PATH/TO/java",
            "args": [
              "-jar",
              "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
              "/PATH/TO/quickbooks-online.prp"
            ]
          },
          ...
        }
      }

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • Use Quickbooks Online By Cdata to quickbooks online get tables.
  • Use Quickbooks Online By Cdata to quickbooks online get columns.
  • Use Quickbooks Online By Cdata to quickbooks online run query.

Frequently asked questions

It connects Quickbooks Online By Cdata to MCP-compatible AI assistants such as Claude and Cursor, exposing 3 tools (quickbooks_online_get_tables, quickbooks_online_get_columns, quickbooks_online_run_query) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Quickbooks Online By Cdata directly.