`odoo_query_model`

Pack: odoo · Endpoint: https://gateway.pipeworx.io/odoo/mcp

Power-user generic query: run search_read on ANY Odoo model. Provide model (e.g. “product.template”), domain (Odoo list-of-triples, e.g. [[“list_price”,”>“,100]]), fields, and limit. Use when no specific tool above fits.

Parameters

Name	Type	Required	Description
`model`	string	yes	Odoo model name, e.g. “product.template”, “stock.picking”, “hr.employee”.
`domain`	array	no	Odoo search domain — a list of triples [field, operator, value], e.g. [[“active”,”=“,true],[“name”,“ilike”,“acme”]]. Empty array [] matches all.
`items`	unknown	no
`fields`	array	no	Field names to return, e.g. [“name”,“create_date”]. Omit to let Odoo return its default field set.
`items`	string	no
`limit`	number	no	Max records (default 20).
`offset`	number	no	Number of records to skip (pagination).
`order`	string	no	Sort spec, e.g. “create_date desc”.

Example call

Arguments

{
  "model": "product.template",
  "domain": [
    [
      "list_price",
      ">",
      100
    ]
  ],
  "fields": [
    "name",
    "list_price"
  ],
  "limit": 25,
  "_odooUrl": "https://your-instance.odoo.com",
  "_odooDb": "your_database",
  "_odooUid": "your_user_id",
  "_odooPassword": "your-odoo-password"
}

curl

curl -X POST https://gateway.pipeworx.io/odoo/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"odoo_query_model","arguments":{"model":"product.template","domain":[["list_price",">",100]],"fields":["name","list_price"],"limit":25,"_odooUrl":"https://your-instance.odoo.com","_odooDb":"your_database","_odooUid":"your_user_id","_odooPassword":"your-odoo-password"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('odoo_query_model', {
  "model": "product.template",
  "domain": [
    [
      "list_price",
      ">",
      100
    ]
  ],
  "fields": [
    "name",
    "list_price"
  ],
  "limit": 25,
  "_odooUrl": "https://your-instance.odoo.com",
  "_odooDb": "your_database",
  "_odooUid": "your_user_id",
  "_odooPassword": "your-odoo-password"
});

More examples

{
  "model": "stock.picking",
  "domain": [
    [
      "state",
      "=",
      "confirmed"
    ]
  ],
  "order": "create_date desc",
  "limit": 10,
  "_odooUrl": "https://your-instance.odoo.com",
  "_odooDb": "your_database",
  "_odooUid": "your_user_id",
  "_odooPassword": "your-odoo-password"
}

Connect

Add this to your MCP client config, or use one-click install buttons:

{
  "mcpServers": {
    "odoo": {
      "url": "https://gateway.pipeworx.io/odoo/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

odoo_query_model