read_group
Count and aggregate Odoo records by grouped fields, with domain filters and date granularity. Returns per-group counts and aggregate values for reporting or list-view-style summaries.
Instructions
Count and aggregate records per group — as the list view grouped by a field shows them. groupby: field names, dates with a granularity ("create_date:month"; day|week|month|quarter|year); empty for one total. aggregates: "field:agg" specs (sum, avg, min, max, count_distinct, …). domain filters the records first. Returns [{: value, __count, : value}] — many2one values as [id, name], date groups as [range start, label].
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| model | Yes | ||
| domain | No | ||
| context | No | ||
| groupby | Yes | ||
| aggregates | No | ||
| output_path | No | Absolute path on the MCP server host. When given, the full JSON result is written there and the tool returns only {output_path, total, count} — for results too large for context or meant for scripts. |