aggregate_records

MCP tool from MCP Server Odoo by ivnvxd

Server-side aggregation. Use this whenever the question is "totals/counts/groupings" rather than "list of records" — it pushes the work down to PostgreSQL instead of pulling raw rows. Dispatches to formattedreadgroup on Odoo 19+ (the new dedicated method) and falls back to readgroup with response no

How to use it

aggregate_records is exposed by the MCP Server Odoo MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the aggregate_records tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install MCP Server Odoo

$uvx mcp-server-odoo

FULL MCP SERVER ODOO LISTING

Other tools in MCP Server Odoo (9)

call_model_method

Generic XML-RPC executekw escape hatch — invokes any public method on any model, for workflow actions not covered by CRUD (post invoice, confirm sale order, validate picking, etc.). Available only when both ODOOYOLO=true (full YOLO) and ODOOMCPENABLEMETHODCALLS=true are set; otherwise the tool is no

create_record

Create a new record in Odoo.

delete_record

Delete a record from Odoo.

get_record

Retrieve a specific record by ID.

list_models

List all models enabled for MCP access.

list_resource_templates

List available resource URI templates and their patterns.

post_message

Post a message to a record's chatter (mail.thread). subtype="note" (default) is an internal log; subtype="comment" notifies followers. Set bodyishtml=true for HTML markup. Optional partnerids and attachmentids reference existing partners and attachments.

search_records

Search for records in any Odoo model with filters.

update_record

Update an existing record.