Xero Connector

Xero is designed as a cloud-based accounting software platform tailored for small to medium-sized businesses.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Xero

XeroYour warehouseLive

payment28 columnsSynced

invoice_payment5 columnsSynced

contact36 columnsSynced

invoice28 columnsSyncing

organisation28 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Xero

Xero

Data source

Authenticating...

Ready to connect

Overview

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.

Agent context

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: 13
fields: 229
relationships: 1

Loading diagram…

bank_account_details

accounts_receivable_tax_type

phone_area_code

phone_country_code

contact_address

contact_contact_id

contact_contact_status

contact_addresses

contact_updated_date_utc

contact_is_supplier

invoice_payment

invoice_line_item

created_date_utc

journal_line_id

tracking_categories

contact_contact_id

contact_email_address

contact_first_name

contact_last_name

quote_line_item

organisation_id

organisation_type

batch_payment_id

batch_payment_account_account_id

batch_payment_date

batch_payment_type

batch_payment_status

batch_payment_total_amount

batch_payment_updated_date_utc

batch_payment_is_reconciled

profit_and_loss_report

Open the schema explorer Open the full schema explorer

Weld MCP server

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextXerotables13fields229joins1

>

How many invoice_payment rows do we have per invoice? Use our Xero data.

Reading the Xero context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.xero.invoice_payment

raw.xero.invoice

+ 11 more Xero tables

●weld·get_reference_schema

⎿invoice_payment · 5 columns

joins invoice on invoice_id

●weld·run_query

⎿select j.id, count(*) from {{raw.xero.invoice_payment}} i

join {{raw.xero.invoice}} j on i.invoice_id = j.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Xero data in your warehouse

>Ask about your Xero dataMCP

Destinations

Load Xero into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Xero setup guide

Step-by-step instructions to configure and start syncing.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

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.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Xero ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "xero",
    "destination_schema_name": "xero_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

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.

Xero

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors