Xero MCP Server by CData

What is Xero MCP Server by CData?

Xero MCP Server by CData is a read-only Model Context Protocol server that allows LLMs (like Claude Desktop) to query live Xero data using natural language questions. It wraps the CData JDBC Driver for Xero, which exposes Xero accounting data as relational SQL models, and makes that data available through a simple MCP interface.

How to use Xero MCP Server by CData?

1. Clone the repository and build with Maven (mvn clean install).
2. Download and install the CData JDBC Driver for Xero, then license it by running java -jar cdata.jdbc.xero.jar --license.
3. Use the driver’s Connection String utility to configure OAuth and test connectivity.
4. Create a .prp file with JDBC connection properties (prefix, driver path, JDBC URL, etc.).
5. Add the server to your Claude Desktop config (claude_desktop_config.json) using the java -jar command with the .prp file.
6. Run or restart Claude Desktop. Ask natural language questions about Xero data (e.g., “How many open tickets do I have?”).

Key features of Xero MCP Server by CData

• Read-only access to live Xero data via MCP
• Natural language queries – no SQL required
• Built on the CData JDBC Driver for Xero
• Supports standard MCP tools: get_tables, get_columns, run_query
• Runs locally via stdio transport
• Configured through a simple .prp file

Use cases of Xero MCP Server by CData

• Ask about account balances, invoices, or contacts in Xero
• Analyze sales trends or expense categories using natural language
• Retrieve customer payment history without writing SQL
• Integrate Xero data into AI assistants for financial reporting

FAQ from Xero MCP Server by CData

Is this server read-only?

Yes. This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, check out the free CData MCP Server for Xero (beta).

What are the dependencies and runtime requirements?

Java and Maven are required to build and run the server. You also need the CData JDBC Driver for Xero, which must be licensed (trial or full key).

Where does the data live?

Data remains in Xero. The server queries live data through the JDBC driver and does not store it locally.

What transport does the server use?

The server uses stdio transport and can only be used with clients running on the same machine.

How is authentication handled?

OAuth authentication is configured via the CData JDBC Driver’s Connection String utility. You will need to authenticate in your browser during setup.