Data to AI™ / Claude/Odoo

Connect Odoo to Claude

Finance teams on Odoo ask Claude about the exact models and custom fields their instance uses, from daily changes to totals per company, without writing exports.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Odoo data you already sync
  • SOC 2 Type II certified
Claude
Connected to Dataddo

On which day last week did our invoice records change the most?

Claude Answer · Odoo

Monday 21 Sep was the busiest day, with 64 invoice records Created On and 118 Last Updated On. Updates outnumbered new records on each day shown.

DayRecords by Created OnRecords by Last Updated On
Mon 21 Sep Odoo Table Replication 64118
Tue 22 Sep Odoo Table Replication 4187
Wed 23 Sep Odoo Table Replication 3872

Counted on one replicated model filtered by Last Updated On, the date range field the docs recommend against Odoo pagination duplicates.

source
Odoo · as of Mon 06:40 UTC
covers
21-27 Sep 2026
Example answer · fictional account and figures
Odoo in Claude

Questions Claude can answer from your Odoo data

Odoo is an open-source ERP with modules for accounting, inventory, sales, CRM and HR. Dataddo replicates whole Odoo models: you pick a model from your instance and its columns, including custom fields, so the fields match your setup.

A data dictionary for your Odoo

Ask Claude

Use the dataddo server to describe every replicated Odoo entity, then write docs/odoo-fields.md listing each field with its type, custom fields marked.

A finance engineer runs Claude Code in the reporting repository, so custom fields are documented from the real schema of this instance instead of from memory.

Daily review of changed invoices

Ask Claude

Which records in the Odoo invoice flow have Last Updated On since yesterday, and how did their monetary totals change per customer?

Each morning the accountant asks Claude what moved overnight in the replicated invoice model, and checks the larger changes before the day's reconciliation work.

Group totals across companies

Ask Claude

Sum the monetary total field per company for September across the companies our custom filter includes, and show the swing against August.

With a custom filter that pulls several companies, the group controller gets monthly totals per company in one answer and asks about the biggest movements.

Odoo datasets and the questions they answer in Claude →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Odoo to Claude step by step

  1. 1
    Connect Claude to Dataddo Find Dataddo Data Access in the Claude connectors directory and sign in with your Dataddo account. Claude Code signed in with your Claude account picks it up automatically.
  2. 2
    Connect Odoo to Dataddo Sign in with your Odoo account in Dataddo and choose the datasets to sync, such as Odoo Table Replication (one model per source) and Date range fields.
  3. 3
    Choose what Claude can see Select the Odoo data Claude may query. Access is read-only, and data you don't select stays out of reach.
Claude setup guide →
With vs. without

Odoo in Claude, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Getting Odoo data into Claude Someone exports a list view per model from Odoo and attaches the file to a Claude chat, one model and one company at a time. Claude reads each replicated Odoo model through the Dataddo Data Access connector, with the columns you picked, custom fields included. No list view exports
Instance-specific fields Claude sees raw column names from your instance and guesses what a custom field or a many2one value means. Claude calls describe_entity first and gets every field of your model with its type, so answers use your own field names. Fields read as defined
Duplicate records Duplicates caused by Odoo pagination slip into exported files, and totals in the chat come out too high. Filter the source on Last Updated On, as the docs recommend, and add dataddo_hash as a natural key for upserts. Totals without double counts
Claude Code on the same data Developers request a fresh Odoo export whenever they need to check a field name while writing reporting code. Claude Code reaches the same replicated models through the connector you added in Claude; check it with /mcp. One source for chat and code
Token consumption Claude spends tokens exploring raw Odoo columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Odoo datasets and the questions they answer in Claude

The Odoo datasets finance and RevOps teams use most, with their real field names. Claude queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Claude
Odoo Table Replication (one model per source)
  • model
  • columns
  • language
  • date_range_field
  • custom_filter
  • + others
Which columns from our replicated sale.order model can we use to analyze orders?
Date range fields Which records in our replicated invoice model changed since yesterday according to Last Updated On?
Replicated field types What is the total of the monetary amount field per customer, using the many2one partner field?
Dataddo metadata columns
  • dataddo_extraction_timestamp
  • dataddo_hash
  • + others
When was our Odoo data last refreshed, based on the latest dataddo_extraction_timestamp?
See all Odoo datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Odoo and Claude: FAQ

How do I connect Odoo to Claude?

Authorize Odoo in Dataddo with your host, username, password and database, then create one Odoo Table Replication source per model you need, such as your invoice model. Attach the flows to a Claude destination or AI Model and connect Dataddo Data Access from the Claude connectors directory.

Which Odoo data can Claude see?

Only the models you replicate. Each Odoo source covers one model of your instance and the columns you tick, custom fields included. Claude reads them once the flow is attached to an AI destination or AI Model and has run.

Why do Odoo field names in Claude differ from another company's setup?

Fields come from your own instance, and column labels follow the language set on the source. Ask Claude to describe the entity first so it uses your real field names and types in every answer.

Does Claude Code work with the Odoo data?

Yes. Claude Code signed in with your Claude account already has the connector; with an API key, register it with claude mcp add and claude mcp login dataddo. Claude Code can then describe and query the replicated Odoo entities from your terminal.

Claude shows duplicate Odoo records. What should I do?

A bug in Odoo's pagination can cause duplicates. Set the date range field to Last Updated On, add dataddo_hash as a natural key, or ask the Dataddo Solutions Team to help load the additional values.

Can Claude answer for more than one Odoo company?

Yes, if the source extracts them. By default only the selected company is extracted. Add a custom filter on the Models and columns step to include other companies, then ask Claude per company.

What does my Odoo subscription need?

The Dataddo docs ask for a custom plan that includes access to the Odoo API. Without API access, Dataddo cannot extract the data Claude would query.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.