odoo-multitenant

List Models

List the Odoo models available on a tenant (technical name + label). `filter` is an optional case-insensitive substring, e.g. 'sale' or 'partner'. Use this first to discover what data exists before querying it.

Get Model Fields

Describe the fields of an Odoo model: name, type, label, whether required, and the related model for relational fields. Use this to build correct domains and value dicts before searching or writing.

Search Records

Search records and return their values (Odoo search_read). `domain` is an Odoo domain, a list of conditions, e.g. [["state", "=", "sale"], ["amount_total", ">", 1000]] Leave it empty ([]) to match all records. `fields` limits the columns returned (recommended, for speed). `order` is e.g. "date_order desc".

Count Records

Count records matching a domain without fetching them (Odoo search_count).

Aggregate Records

Aggregate/analyse records server-side (Odoo read_group) — the tool to use for any totals, counts, averages, KPIs, trends or breakdowns. Far faster and cheaper than fetching rows with search_records and adding them up yourself. `measures`: numeric fields to aggregate, each "field:agg" where agg is sum, avg, min, max — e.g. ["amount_total:sum", "margin:avg"]. Omit to get record counts only. `group_by`: dimensions to break down by — e.g. ["partner_id"], ["state", "user_id"], or a date granul

Get Record

Read a single record by its numeric id. `fields` optionally limits columns.

Create Record

Create a new record. `values` maps field name -> value. Returns the new id. Only works on tenants that are NOT read-only.

Update Record

Update fields on an existing record. `values` maps field name -> new value. Only works on tenants that are NOT read-only.

Delete Record

Delete a record by id. Only works on tenants that are NOT read-only. Use with care; this is a hard delete in Odoo.

Run Method

Call an arbitrary Odoo model method via execute_kw (advanced). Disabled unless the tenant sets allow_raw_calls=true. When the tenant is read-only, only non-mutating read methods are permitted; create/update/ delete and side-effectful business methods are refused.

Search

Search across the tenant's key models by name and return matches. Designed for ChatGPT deep research. Returns {"results": [{id, title, url}]} where each id is "model:record_id" (pass it to `fetch`).

Fetch

Fetch a full record for a composite id "model:record_id" (from `search`). Designed for ChatGPT deep research. Returns {id, title, text, url, metadata}.