Xero Connector
Xero is designed as a cloud-based accounting software platform tailored for small to medium-sized businesses.
XeroYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Xero
Data source
Xero in your warehouse.
Ready for your agents.
Xero is designed as a cloud-based accounting software platform tailored for small to medium-sized businesses. Weld's Xero connector is fully managed: it extracts data from Xero, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
Xero data schema.
The map your agents read.
Every table, field and relationship Weld syncs from Xero is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 31
- fields
- 426
- relationships
- 11
Xero models.
What the numbers mean.
Open-source SQL that turns the raw Xero tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Journal Entries ReportThis template generates a report on journal entries from Xero, breaking down the data by year and month. It gives you a count of all journal entries and a count of individual journal lines for each journal entry within the specified periods.
- Monthly Invoice Summary ReportThis template generates a monthly invoice summary report from Xero, organizing the data by year and month. It details various invoice metrics such as the total number and amount of invoices, total tax, total amount due and paid, amount credited, and the number of unique contacts involved.
- Invoice Entries ReportThis template generates a report on invoice entries from Xero, breaking down the data by year and month. It gives detailed information on each invoice entry including various attributes such as invoice ID, description, quantity, and so on.
- Tracking Details ReportThis template generates a report that brings together tracking details from journal and invoice records, outlining essential details including source type, source ID, and financial particulars such as net and gross amounts, tax details, and tracking categories.
- Monthly Sales ReportThis template creates a monthly sales report by analyzing invoice data. It breaks down sales numbers and revenue per product/service and item code on a monthly basis, offering a clear view of how different offerings perform over time.grain: year x month x currency x item
Ask your agent.
It already knows Xero.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Xero context, finds the tables it needs and queries your warehouse.
- Agent contextXero tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many account rows do we have per account? Use our Xero data.
Reading the Xero context first, so the query uses the right tables and keys.
Load Xero into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
Xero setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Xero connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Xero data to work.
Connect Xero, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
