listOperators

Return custom operators in a schema with left/right operand types, result type, and implementing function; mostly relevant for schemas using extensions with custom types (e.g. PostGIS).

read-onlyany connectionsweeps instancesweeps group

Synopsis

listOperators(schema)

Description

Return custom operators in a schema with left/right operand types, result type, and implementing function; mostly relevant for schemas using extensions with custom types (e.g. PostGIS).

Parameters

schema requiredstring

Also accepts connection, instance, group, described once under arguments every tool takes.

Output

Keyed by operator signature; each value is its operand and result types. An absent extension or a missing grant is reported as {error, hint} in place of the map.

Scope

A physical replica is byte-identical here, so asking each member of a replication group adds nothing.

Example mocked data

Request

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "listOperators",
    "arguments": {
      "schema": "shop"
    }
  }
}

Result

{
  "=(money_amount,money_amount)": {
    "left_type": "money_amount",
    "right_type": "money_amount",
    "result_type": "boolean",
    "function": "shop.money_amount_eq",
    "description": null
  }
}

Invented values on a fictional shop database, shaped by and checked against this tool's output schema. Real output is returned as structuredContent to clients that negotiate MCP 2025-06-18 or later.

See also

listCollations, listOperatorClasses, listTextSearchConfigs