dataSights
The dataSights MCP · included with every plan

AI that talks to all your business data, and acts on it

Put Claude, ChatGPT, Microsoft Copilot or any MCP-compatible AI to work over your dataSights database: the trusted, consolidated layer under every Xero and 160+ connectors. Develop reports instantly in a chat, run month-end workflows, post back to multiple Xeros, create and update mapping tables, and build SQL views for any reporting tool to use. All in plain English.

Works with Claude, ChatGPT, Copilot and any MCP-compatible AI Queries consolidated, transaction-level data across every Xero entity Consolidates multiple Xeros, plus Cin7 Core, Shopify, Salesforce and 160+ other systems, so one question spans them all Develops reports in a chat: from data tables to AI reports, Excel, Power BI or Looker Posts journals, invoices, contacts, accounts and more back to multiple Xeros, then syncs and verifies they landed Your dedicated Azure SQL database underneath, and you decide what the AI can see and do

14-day free trial, no credit card required

dataSights Inventory Ops Command Centre showing reconciliation exceptions between Cin7 Core, Shopify and Xero across three entities, with post-to-Xero actions on each item.
Loading the live demo

Three entities, three systems, one database

A web app built with Lovable over the dataSights database. Fully interactive. Demo data. Open it full screen

160+

Business systems supported

4,500+

Xero entities synced daily

Any

MCP-compatible AI

What is AI Connect

AI Connect is the dataSights MCP: a secure bridge between your database and the AI tools you already use, built on the open Model Context Protocol standard. MCP lets large language models read from and write to live business systems.

In practical terms, once you connect Claude, ChatGPT, or Microsoft Copilot to your dataSights account, they can query your synced data, generate reports, post back to multiple Xeros and even save data back to your database. Every interaction runs against your dedicated Microsoft Azure SQL database. No data is shared with anyone you have not authorised.

AI tool (Claude / ChatGPT / Copilot / any MCP AI)
AI Connect
dataSights database
160+ source systems

How AI Connect works in 3 steps

1

Sync your data

Your business data already syncs into your dedicated Microsoft SQL database. Xero, Cin7 Core, Salesforce, HubSpot, Shopify, and 160+ other sources, consolidated and ready to use.

2

Connect your AI tool

Add dataSights as a connector in Claude, ChatGPT, or Microsoft Copilot. One-time setup, secure authentication, you control access.

3

Ask. Build. Post back. Automate.

Ask questions in plain English. Generate reports. Save reusable SQL views back to your database. Post journals and updates back to multiple Xero entities. Trigger workflows your team relies on.

"I can't believe how easy this was. The connection to Claude took 30 seconds and I was creating reports in minutes."
Erica Warren
CFO, Direct Pool Supplies · Review from Xero App Store
Workflow automation

Full workflows, not just answers

AI Connect runs the whole loop, not just the question. Query the data, act on it, trigger a sync, and verify the result landed, all in one conversation with a full audit trail. Here are two workflows customers run today.

Finance

Month-end across every Xero

  1. 1Query consolidated transactions across every entity, right down to the invoice
  2. 2Run your existing Excel-based month-end tasks, or point Anthropic's finance plugins at your data
  3. 3Have the journals prepared for you to review, then posted to multiple Xeros at once
  4. 4Trigger a resync, verify every posting landed, and refresh your reports and checks
Claude running Anthropic's finance variance analysis plugin against the dataSights MCP, producing a consolidated P&L variance workpaper with driver commentary and an operating result bridge across multiple Xero entities.

One way to run it: Anthropic's finance plugins pointed at your consolidated data.

Operations

Ops across Cin7 Core, Shopify and Xero

  1. 1Reconcile all three systems in one pass
  2. 2Surface the exceptions across six types: missing invoices, value mismatches, transactions never posted to Xero, tax mismatches, refunds without credit notes, stock differences
  3. 3Post the corrections back to Xero
  4. 4Track it all in a live command centre
dataSights Inventory Ops Command Centre showing reconciliation exceptions between Cin7 Core, Shopify and Xero across three entities, with post-to-Xero actions on each item.
Loading the live demo

Cin7 Core, Shopify and Xero, reconciled

Cin7 Core, Shopify and Xero, reconciled. 18 exceptions, $3,017 at risk. Demo data. Not a dataSights screen: a web app built with Lovable over the dataSights database.

Open the full demo
"We run 50+ Xero files and dataSights keeps them manageable... The Claude integration is incredible: it analyses your data, creates reports, even posts back to Xero in bulk."
Alasdair Forrest
CFO, El Jannah · Xero App Store review
Consolidated profit and loss by Xero tracking category across two entities with eliminations and FX applied, showing division by report group in a single matrix.
Division-level profit and loss built from Xero account transactions, showing revenue divisions, cost centres and net contribution with month-by-month drill-down.
Ten-page monthly board pack generated by Claude from consolidated multi-entity Xero data, cover slide showing consolidation group, reporting currency and entities in scope.
Financial Controller Query Centre built on the dataSights MCP, answering working capital and invoice due date questions across a two-entity Xero consolidation, with mapping issues identified and reclassified in the answer.
dataSights Inventory Ops Command Centre showing reconciliation exceptions between Cin7 Core, Shopify and Xero across three entities, with post-to-Xero actions on each item.

Tracking categories, consolidated across entities

Division detail, straight from transactions

Board pack, auto-drafted. Demo data.

FC Query Centre. Ask a question, get the answer, and get told what the data did.

Ops command centre, live demo. Demo data.

In the wild

What customers run on AI Connect today

Finance and reporting want different things from the same data. AI Connect serves both, without either waiting on the other.

For finance teams

A month-end, minus the manual work

Everything your controller asks in a month, answered from one place: consolidated Xeros, 160+ connectors, down to the invoice. No exports, no waiting on a report to be built. And when the answer needs an action, the action happens in the same conversation.

Financial Controller Query Centre built on the dataSights MCP, answering working capital and invoice due date questions across a two-entity Xero consolidation, with mapping issues identified and reclassified in the answer.

FC Query Centre. Ask a question, get the answer, and get told what the data did.

"The AI-driven capabilities are clearly built with finance teams in mind."

Alan Rust, CFO, MCL Capital · Xero App Store review

For report builders

From raw data to a live report, faster

Claude, ChatGPT or Copilot works down the whole development path with you: query the data tables, create and save SQL views, then create and edit mapping tables, so the hard modelling is done once and done right. From there the report builds easily in any tool, Excel, Power BI, Looker or a custom app. The modelling that used to take a BI developer days happens in a chat.

Consolidated three-way cash flow forecast in Excel, built with Claude over dataSights Xero consolidation views, refreshed through Power Query with no AI in the refresh path.

Three-way consolidated forecast. Built once with Claude, refreshed with no AI at all.

"I've tried SyncHub, Flex Financial, Syft, Coupler and others. dataSights is the go-to for Power BI and Excel integration across multiple Xero entities."

James Kemp, BI Developer, Centenary Childcare · Xero App Store review

The dataSights difference

A Xero MCP that answers at the consolidated layer

Other platforms expose raw single-entity Xero data through MCP. dataSights exposes the consolidated layer with eliminations, FX and account mappings applied, so AI tools answer group-level questions correctly the first time.

There is a second difference under the hood. AI connectors that hit app APIs directly burn tokens and are unreliable for bulk reads and consolidations. The dataSights MCP exposes your database, so the AI writes SQL against curated, well-described views, and it also carries the API operations that matter: saving views and mappings, posting to Xero, triggering syncs. MCP-to-SQL and MCP-to-API, in one connector.

"Claude has become a genuine real-time collaborator in our work to solve complex problems that would otherwise not be solvable. In short, it's a game changer."
Stuart Rae
360 Early Education

Use the AI you already trust

Claude by Anthropic

Claude (Anthropic)

Available on Claude Pro, Team, Enterprise. Strong at long-context reasoning and code generation. Our recommended pairing.

ChatGPT by OpenAI

ChatGPT (OpenAI)

Available on ChatGPT Plus, Team, Enterprise. Familiar interface with broad ecosystem support.

Microsoft Copilot

Microsoft Copilot

Available on Microsoft 365 Copilot. Native integration with Excel, Outlook and Teams.

Also works with

Claude CodeClaude Code
LovableLovable
GammaGamma
CursorCursor
n8nn8n
ZapierZapier

Any tool that speaks MCP works with dataSights. More are added every month.

Security and control

Your data stays yours

These are settings you control, not promises we make.

  • Every connection runs against your dedicated Microsoft Azure SQL database
  • Per-user permissions by Xero entity, by individual table and view, and by operation, enforced on every query
  • Multi-factor authentication standard
  • You can revoke AI Connect access at any time
  • Bring your own Azure subscription option, you own everything
"dataSights gives us the raw data in a database we actually own, which means I can audit it, version it, and query it however I need, and when connected with Claude, data becomes intelligence. That's the difference between a reporting tool and infrastructure: I'm not limited to what someone else decided to expose."
Chris Buchanan
Co-founder and CEO, ALEMAIS
Verified Xero App Store reviews

What our customers say

We focus on the reporting, you focus on what matters

Frequently asked questions

AI Connect is the dataSights MCP, a secure bridge that lets AI assistants like Claude, ChatGPT, and Microsoft Copilot read from and write to your dataSights database. It runs on the open Model Context Protocol (MCP) standard, so any AI tool that supports MCP can connect.

Yes. If you consolidate Xero organisations through dataSights, AI Connect is your Xero MCP, with one difference from every other one: it exposes the consolidated layer with eliminations, FX and account mappings already applied, across every entity, at full transaction depth, and it can post back. MCPs wired straight to the Xero API expose one raw organisation at a time and are read-heavy by design.

Yes, and honestly framed: your AI tool does the reasoning, and AI Connect provides everything that makes the workflow safe to run, the consolidated data layer, the write operations (post to multiple Xeros, save views and mappings, trigger syncs) and a full audit trail on every action. Customers run month-end variance, journal preparation and posting, and cross-system reconciliations this way today.

Yes. Anthropic's finance plugins can be pointed at the dataSights MCP with a single line, and they run against your consolidated transactions rather than a single entity. The set includes variance analysis, journal entry preparation, reconciliation, close management, audit support and financial statements. Because the views are described in multi-entity financial controller language, the plugins get it right the first time.

Yes. Tracking categories sync with your Xero data into your own database, including renames, with no limit on the number of options. Because the consolidation, eliminations and FX are applied in the database, you can slice a consolidated P&L by tracking category across every entity in one query, and drill from any division straight into the underlying account transactions. Entities that use different tracking categories are handled without double-counting.

Yes. The Inventory Ops Command Centre is a working demo built with Lovable on the dataSights MCP, showing reconciliation between Cin7 Core, Shopify and Xero across three entities. It runs on fictional demo data and is open to explore, no signup. Explore

Yes. If you are syncing Xero through dataSights, Claude can query that data once you have set up AI Connect on your Claude Pro, Team, or Enterprise account. The same applies to ChatGPT and Microsoft Copilot.

Yes. AI Connect supports any AI assistant that implements MCP, including ChatGPT (Plus, Team, Enterprise) and Microsoft Copilot. Setup is one-time per AI tool.

Xero's built-in AI works on a single Xero organisation, on summary data, and is read-only. AI Connect works across all of your data, every Xero organisation you consolidate, plus any of your 160+ other connected systems, at full transaction-level depth, and it's bidirectional. AI can drill from a board-level variance straight to the underlying Account Transactions, save reusable SQL views and mapping tables back to your database, and post journals or invoices to multiple Xero files in one chat. Xero's AI cannot do any of that.

No. You ask questions in plain English. The AI writes the SQL behind the scenes. If you do know SQL, you can ask the AI to generate views you then refine yourself.

Your data lives in your dedicated Azure SQL database. When you ask a question, your AI tool queries that database through the dataSights MCP and processes the results under your own AI subscription's terms, the same as connecting any Microsoft tool to your data. You control exactly which views the AI can see, every action is logged in a full audit trail, and you can revoke access at any time. Multi-factor authentication is standard, your database sits in your chosen global region, and you can optionally host it in your own Microsoft account so you own everything.

Yes, at three levels. Xero entity permissions scope each user to the entities they are allowed to see, and that scope follows them everywhere: management reports, SQL views, the Excel add-in and AI Connect. Data permissions control which views and tables the AI can query. Operation permissions control what it can do: query, save SQL views, edit user data, or post to Xero by document type. Every user authenticates individually over OAuth2, and dataSights enforces the permissions when the query runs, not the AI.

Yes. AI Connect can save SQL views and mapping tables to your dataSights database, and post journals, invoices, bills, credit notes and tracking categories back to multiple Xero organisations from a single chat. Every write goes through your existing dataSights workflows with full audit trails. Other source-system write-backs are supported where the connector supports it. Ask us what's available for your stack.

Any AI tool that supports the Model Context Protocol (MCP). Today that includes Claude (Anthropic), ChatGPT (OpenAI), Microsoft Copilot, Claude Code, Cursor, Lovable, Gamma, n8n MCP, Zapier MCP and a growing list of others. MCP is an open standard, so any tool that adopts it works with dataSights automatically. Customers are also building their own custom agents.

AI Connect is included with all dataSights plans at no additional charge. You will need an active subscription with the AI tool of your choice (Claude, ChatGPT, or Microsoft Copilot).

MCP is an open standard for connecting AI assistants to live data sources and tools. It was introduced by Anthropic and is now adopted by OpenAI, Microsoft, and others. Because dataSights speaks MCP, your data works with whichever AI tool you prefer.

Most customers are up and running in under 15 minutes. You authenticate dataSights as a connector inside your AI tool, and you are ready to ask questions.

Support

Still have questions? Contact our support team

dataSights

Ready to put your data to work

Start your 14-day free trial of dataSights with AI Connect included. No credit card required.