Skip to main content
Glama

Run read-only trade SQL

exim__analytics__sql
Read-onlyIdempotent

Runs one read-only SELECT over the allowed trade tables; raw fact tables need a WHERE clause and results are row-limited. Use it when analytics query cannot express the question.

Input Schema

NameRequiredDescriptionDefault
sqlYesOne read-only SELECT over the trade tables.
limitNoMax rows per page (default 100, max 10000)
offsetNoRow offset for paging (minimum 0; use ORDER BY for a stable page order).

Output Schema

NameRequiredDescriptionDefault
dataYes
statsNo
_debugNo
summaryYes
warningsNo
nextActionsYes
correlationIdNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed58 schema fields changed
    • addedOutput schema / $defs / value14 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value14 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value14 / properties
      Added value: +{
      +  "company": {
      +    "anyOf": [
      +      {
      +        "$ref": "#/$defs/value16"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "fit": {
      +    "anyOf": [
      +      {
      +        "$ref": "#/$defs/value15"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "membership": {
      +    "anyOf": [
      +      {
      +        "$ref": "#/$defs/value17"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "pending": {
      +    "anyOf": [
      +      {
      +        "$ref": "#/$defs/value20"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  }
      +}
    • addedOutput schema / $defs / value14 / type
      Added value: +"object"
    • addedOutput schema / $defs / value15 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value15 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value16"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value15 / properties
      Added value: +{
      +  "company_id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "created_at": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "discovery_source": {
      +    "type": "string"
      +  },
      +  "evidence_tier": {
      +    "type": "integer"
      +  },
      +  "id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "match_reasons": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "priority": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "reasoning": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "score": {
      +    "anyOf": [
      +      {
      +        "type": "number"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "target_id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "target_kind": {
      +    "type": "string"
      +  },
      +  "updated_at": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "user_id": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value15 / required
      Added value: +[
      +  "company_id",
      +  "created_at",
      +  "discovery_source",
      +  "evidence_tier",
      +  "id",
      +  "match_reasons",
      +  "priority",
      +  "reasoning",
      +  "score",
      +  "target_id",
      +  "target_kind",
      +  "updated_at",
      +  "user_id"
      +]
    • addedOutput schema / $defs / value15 / type
      Added value: +"object"
    • addedOutput schema / $defs / value16 / properties / address
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / base_url
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / canonical_url
      Added value: +{
      +  "type": "string"
      +}
    • removedOutput schema / $defs / value16 / properties / command
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value16 / properties / cost
      Removed value: -{
      -  "type": "string"
      -}
    • addedOutput schema / $defs / value16 / properties / country
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / description
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / id
      Added value: +{
      +  "anyOf": [
      +    {
      +      "format": "uuid",
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / industry
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • removedOutput schema / $defs / value16 / properties / label
      Removed value: -{
      -  "type": "string"
      -}
    • addedOutput schema / $defs / value16 / properties / name
      Added value: +{
      +  "type": "string"
      +}
    • removedOutput schema / $defs / value16 / properties / rationale
      Removed value: -{
      -  "type": "string"
      -}
    • addedOutput schema / $defs / value16 / properties / resolution_source
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value16 / properties / trade_potential
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "number"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / trade_potential_reasoning
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / updated_at
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value16 / properties / url
      Added value: +{
      +  "anyOf": [
      +    {
      +      "type": "string"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • changedOutput schema / $defs / value16 / required
      Previous value: -[
      -  "command",
      -  "cost",
      -  "label",
      -  "rationale"
      -]New value: +[
      +  "address",
      +  "base_url",
      +  "canonical_url",
      +  "country",
      +  "description",
      +  "id",
      +  "industry",
      +  "name",
      +  "resolution_source",
      +  "trade_potential",
      +  "trade_potential_reasoning",
      +  "updated_at",
      +  "url"
      +]
    • addedOutput schema / $defs / value17 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value17 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": "number"
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value17 / properties
      Added value: +{
      +  "ai_column_meta": {
      +    "type": [
      +      "null",
      +      "boolean",
      +      "number",
      +      "string",
      +      "array",
      +      "object"
      +    ]
      +  },
      +  "ai_column_values": {
      +    "$ref": "#/$defs/value19"
      +  },
      +  "canonical_url": {
      +    "type": "string"
      +  },
      +  "collection_id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "company_country": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "company_id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "company_name": {
      +    "type": "string"
      +  },
      +  "company_url": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "created_at": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "discovery_source": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "id": {
      +    "anyOf": [
      +      {
      +        "format": "uuid",
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "keywords": {
      +    "$ref": "#/$defs/value18"
      +  },
      +  "match_reasons": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "outreach_stage": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "priority": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "reasoning": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "score": {
      +    "anyOf": [
      +      {
      +        "type": "number"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  },
      +  "updated_at": {
      +    "anyOf": [
      +      {
      +        "type": "string"
      +      },
      +      {
      +        "type": "null"
      +      }
      +    ]
      +  }
      +}
    • addedOutput schema / $defs / value17 / required
      Added value: +[
      +  "ai_column_meta",
      +  "ai_column_values",
      +  "canonical_url",
      +  "collection_id",
      +  "company_country",
      +  "company_id",
      +  "company_name",
      +  "company_url",
      +  "created_at",
      +  "discovery_source",
      +  "id",
      +  "keywords",
      +  "match_reasons",
      +  "outreach_stage",
      +  "priority",
      +  "reasoning",
      +  "score",
      +  "updated_at"
      +]
    • addedOutput schema / $defs / value17 / type
      Added value: +"object"
    • changedOutput schema / $defs / value18 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value19"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value19 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value19 / anyOf
      Added value: +[
      +  {
      +    "type": "string"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value19 / properties
      Removed value: -{
      -  "code": {
      -    "type": "string"
      -  },
      -  "message": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value19 / required
      Removed value: -[
      -  "code",
      -  "message"
      -]
    • removedOutput schema / $defs / value19 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value20 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value20 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value20 / properties
      Added value: +{
      +  "displayName": {
      +    "type": "string"
      +  },
      +  "message": {
      +    "type": "string"
      +  },
      +  "pendingId": {
      +    "type": "string"
      +  },
      +  "reportingCountry": {
      +    "type": "string"
      +  },
      +  "status": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value20 / required
      Added value: +[
      +  "displayName",
      +  "message",
      +  "pendingId",
      +  "reportingCountry",
      +  "status"
      +]
    • addedOutput schema / $defs / value20 / type
      Added value: +"object"
    • addedOutput schema / $defs / value21
      Added value: +{
      +  "additionalProperties": false,
      +  "properties": {
      +    "id": {
      +      "type": "string"
      +    },
      +    "url": {
      +      "type": "string"
      +    }
      +  },
      +  "required": [
      +    "id",
      +    "url"
      +  ],
      +  "type": "object"
      +}
    • addedOutput schema / $defs / value22
      Added value: +{
      +  "anyOf": [
      +    {
      +      "items": {
      +        "type": [
      +          "null",
      +          "boolean",
      +          "number",
      +          "string",
      +          "array",
      +          "object"
      +        ]
      +      },
      +      "type": "array"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value23
      Added value: +{
      +  "anyOf": [
      +    {
      +      "items": {
      +        "$ref": "#/$defs/value24"
      +      },
      +      "type": "array"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value24
      Added value: +{
      +  "additionalProperties": false,
      +  "properties": {
      +    "command": {
      +      "type": "string"
      +    },
      +    "cost": {
      +      "type": "string"
      +    },
      +    "label": {
      +      "type": "string"
      +    },
      +    "rationale": {
      +      "type": "string"
      +    }
      +  },
      +  "required": [
      +    "command",
      +    "cost",
      +    "label",
      +    "rationale"
      +  ],
      +  "type": "object"
      +}
    • addedOutput schema / $defs / value25
      Added value: +{
      +  "anyOf": [
      +    {
      +      "additionalProperties": {
      +        "type": "number"
      +      },
      +      "type": "object"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value26
      Added value: +{
      +  "anyOf": [
      +    {
      +      "items": {
      +        "$ref": "#/$defs/value27"
      +      },
      +      "type": "array"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • addedOutput schema / $defs / value27
      Added value: +{
      +  "additionalProperties": false,
      +  "properties": {
      +    "code": {
      +      "type": "string"
      +    },
      +    "message": {
      +      "type": "string"
      +    }
      +  },
      +  "required": [
      +    "code",
      +    "message"
      +  ],
      +  "type": "object"
      +}
    • addedOutput schema / $defs / value28
      Added value: +{
      +  "anyOf": [
      +    {
      +      "additionalProperties": {
      +        "type": [
      +          "null",
      +          "boolean",
      +          "number",
      +          "string",
      +          "array",
      +          "object"
      +        ]
      +      },
      +      "type": "object"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • changedOutput schema / properties / _debug / $ref
      Previous value: -"#/$defs/value20"New value: +"#/$defs/value28"
    • addedOutput schema / properties / data / properties / context / anyOf
      Added value: +[
      +  {
      +    "type": [
      +      "null",
      +      "boolean",
      +      "number",
      +      "string",
      +      "array",
      +      "object"
      +    ]
      +  },
      +  {
      +    "additionalProperties": false,
      +    "properties": {
      +      "collection": {
      +        "$ref": "#/$defs/value21"
      +      },
      +      "sourceObservation": {
      +        "type": [
      +          "null",
      +          "boolean",
      +          "number",
      +          "string",
      +          "array",
      +          "object"
      +        ]
      +      }
      +    },
      +    "required": [
      +      "sourceObservation"
      +    ],
      +    "type": "object"
      +  }
      +]
    • removedOutput schema / properties / data / properties / context / type
      Removed value: -[
      -  "null",
      -  "boolean",
      -  "number",
      -  "string",
      -  "array",
      -  "object"
      -]
    • changedOutput schema / properties / data / properties / items / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value0"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "anyOf": [
      +        {
      +          "$ref": "#/$defs/value0"
      +        },
      +        {
      +          "$ref": "#/$defs/value14"
      +        }
      +      ]
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • changedOutput schema / properties / nextActions / $ref
      Previous value: -"#/$defs/value15"New value: +"#/$defs/value23"
    • changedOutput schema / properties / stats / $ref
      Previous value: -"#/$defs/value17"New value: +"#/$defs/value25"
    • changedOutput schema / properties / warnings / $ref
      Previous value: -"#/$defs/value18"New value: +"#/$defs/value26"
  2. Changed70 schema fields changed
    • removedInput schema / properties / querySql
      Removed value: -{
      -  "description": "A single read-only SELECT over the trade tables (tradeData + signal tables)",
      -  "maxLength": 20000,
      -  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      -  "type": "string"
      -}
    • addedInput schema / properties / sql
      Added value: +{
      +  "description": "One read-only SELECT over the trade tables.",
      +  "maxLength": 20000,
      +  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      +  "type": "string"
      +}
    • changedInput schema / required
      Previous value: -[
      -  "querySql"
      -]New value: +[
      +  "sql"
      +]
    • changedOutput schema / $defs / value10 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value11"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value11 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value11 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value12"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value11 / properties
      Removed value: -{
      -  "Column": {
      -    "type": "string"
      -  },
      -  "Prefix": {
      -    "type": "boolean"
      -  },
      -  "Values": {
      -    "$ref": "#/$defs/value12"
      -  }
      -}
    • removedOutput schema / $defs / value11 / required
      Removed value: -[
      -  "Column",
      -  "Prefix",
      -  "Values"
      -]
    • removedOutput schema / $defs / value11 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value12 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value12 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value12 / properties
      Added value: +{
      +  "Column": {
      +    "type": "string"
      +  },
      +  "Prefix": {
      +    "type": "boolean"
      +  },
      +  "Values": {
      +    "$ref": "#/$defs/value13"
      +  }
      +}
    • addedOutput schema / $defs / value12 / required
      Added value: +[
      +  "Column",
      +  "Prefix",
      +  "Values"
      +]
    • addedOutput schema / $defs / value12 / type
      Added value: +"object"
    • changedOutput schema / $defs / value13 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • changedOutput schema / $defs / value14 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value15"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": [
      +        "null",
      +        "boolean",
      +        "number",
      +        "string",
      +        "array",
      +        "object"
      +      ]
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value15 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value15 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value16"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value15 / properties
      Removed value: -{
      -  "command": {
      -    "type": "string"
      -  },
      -  "cost": {
      -    "type": "string"
      -  },
      -  "label": {
      -    "type": "string"
      -  },
      -  "rationale": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value15 / required
      Removed value: -[
      -  "command",
      -  "cost",
      -  "label",
      -  "rationale"
      -]
    • removedOutput schema / $defs / value15 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value16 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value16 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": "number"
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value16 / properties
      Added value: +{
      +  "command": {
      +    "type": "string"
      +  },
      +  "cost": {
      +    "type": "string"
      +  },
      +  "label": {
      +    "type": "string"
      +  },
      +  "rationale": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value16 / required
      Added value: +[
      +  "command",
      +  "cost",
      +  "label",
      +  "rationale"
      +]
    • addedOutput schema / $defs / value16 / type
      Added value: +"object"
    • changedOutput schema / $defs / value17 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value18"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": {
      +      "type": "number"
      +    },
      +    "type": "object"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value18 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value18 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value19"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value18 / properties
      Removed value: -{
      -  "code": {
      -    "type": "string"
      -  },
      -  "message": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value18 / required
      Removed value: -[
      -  "code",
      -  "message"
      -]
    • removedOutput schema / $defs / value18 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value19 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value19 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value19 / properties
      Added value: +{
      +  "code": {
      +    "type": "string"
      +  },
      +  "message": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value19 / required
      Added value: +[
      +  "code",
      +  "message"
      +]
    • addedOutput schema / $defs / value19 / type
      Added value: +"object"
    • addedOutput schema / $defs / value20
      Added value: +{
      +  "anyOf": [
      +    {
      +      "additionalProperties": {
      +        "type": [
      +          "null",
      +          "boolean",
      +          "number",
      +          "string",
      +          "array",
      +          "object"
      +        ]
      +      },
      +      "type": "object"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • changedOutput schema / $defs / value4 / properties / scope / $ref
      Previous value: -"#/$defs/value5"New value: +"#/$defs/value6"
    • addedOutput schema / $defs / value4 / properties / valueEvidence
      Added value: +{
      +  "anyOf": [
      +    {
      +      "$ref": "#/$defs/value5"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • removedOutput schema / $defs / value5 / properties / CompanyKeys
      Removed value: -{
      -  "$ref": "#/$defs/value6"
      -}
    • removedOutput schema / $defs / value5 / properties / Destination
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Empty
      Removed value: -{
      -  "type": "boolean"
      -}
    • removedOutput schema / $defs / value5 / properties / From
      Removed value: -{
      -  "format": "date-time",
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / GroupBy
      Removed value: -{
      -  "$ref": "#/$defs/value8"
      -}
    • removedOutput schema / $defs / value5 / properties / HS2
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / HS6
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / NormalizedNames
      Removed value: -{
      -  "$ref": "#/$defs/value7"
      -}
    • removedOutput schema / $defs / value5 / properties / Origin
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Population
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / ReportingCountry
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / RetainedFilters
      Removed value: -{
      -  "$ref": "#/$defs/value10"
      -}
    • removedOutput schema / $defs / value5 / properties / Role
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Source
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / To
      Removed value: -{
      -  "format": "date-time",
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Transport
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Unsupported
      Removed value: -{
      -  "$ref": "#/$defs/value9"
      -}
    • addedOutput schema / $defs / value5 / properties / shipmentsExcludedImplausible
      Added value: +{
      +  "type": "integer"
      +}
    • addedOutput schema / $defs / value5 / properties / shipmentsUsed
      Added value: +{
      +  "type": "integer"
      +}
    • addedOutput schema / $defs / value5 / properties / weightKg
      Added value: +{
      +  "type": "number"
      +}
    • changedOutput schema / $defs / value5 / required
      Previous value: -[
      -  "CompanyKeys",
      -  "Destination",
      -  "Empty",
      -  "From",
      -  "GroupBy",
      -  "HS2",
      -  "HS6",
      -  "NormalizedNames",
      -  "Origin",
      -  "Population",
      -  "ReportingCountry",
      -  "RetainedFilters",
      -  "Role",
      -  "Source",
      -  "To",
      -  "Transport",
      -  "Unsupported"
      -]New value: +[
      +  "shipmentsExcludedImplausible",
      +  "shipmentsUsed",
      +  "weightKg"
      +]
    • addedOutput schema / $defs / value6 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value6 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value6 / properties
      Added value: +{
      +  "CompanyKeys": {
      +    "$ref": "#/$defs/value7"
      +  },
      +  "Destination": {
      +    "type": "string"
      +  },
      +  "Empty": {
      +    "type": "boolean"
      +  },
      +  "From": {
      +    "format": "date-time",
      +    "type": "string"
      +  },
      +  "GroupBy": {
      +    "$ref": "#/$defs/value9"
      +  },
      +  "HS2": {
      +    "type": "string"
      +  },
      +  "HS6": {
      +    "type": "string"
      +  },
      +  "NormalizedNames": {
      +    "$ref": "#/$defs/value8"
      +  },
      +  "Origin": {
      +    "type": "string"
      +  },
      +  "Population": {
      +    "type": "string"
      +  },
      +  "ReportingCountry": {
      +    "type": "string"
      +  },
      +  "RetainedFilters": {
      +    "$ref": "#/$defs/value11"
      +  },
      +  "Role": {
      +    "type": "string"
      +  },
      +  "Source": {
      +    "type": "string"
      +  },
      +  "To": {
      +    "format": "date-time",
      +    "type": "string"
      +  },
      +  "Transport": {
      +    "type": "string"
      +  },
      +  "Unsupported": {
      +    "$ref": "#/$defs/value10"
      +  }
      +}
    • addedOutput schema / $defs / value6 / required
      Added value: +[
      +  "CompanyKeys",
      +  "Destination",
      +  "Empty",
      +  "From",
      +  "GroupBy",
      +  "HS2",
      +  "HS6",
      +  "NormalizedNames",
      +  "Origin",
      +  "Population",
      +  "ReportingCountry",
      +  "RetainedFilters",
      +  "Role",
      +  "Source",
      +  "To",
      +  "Transport",
      +  "Unsupported"
      +]
    • addedOutput schema / $defs / value6 / type
      Added value: +"object"
    • changedOutput schema / properties / _debug / $ref
      Previous value: -"#/$defs/value19"New value: +"#/$defs/value20"
    • changedOutput schema / properties / nextActions / $ref
      Previous value: -"#/$defs/value14"New value: +"#/$defs/value15"
    • changedOutput schema / properties / stats / $ref
      Previous value: -"#/$defs/value16"New value: +"#/$defs/value17"
    • changedOutput schema / properties / warnings / $ref
      Previous value: -"#/$defs/value17"New value: +"#/$defs/value18"
  3. Changed70 schema fields changed
    • addedInput schema / properties / querySql
      Added value: +{
      +  "description": "A single read-only SELECT over the trade tables (tradeData + signal tables)",
      +  "maxLength": 20000,
      +  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      +  "type": "string"
      +}
    • removedInput schema / properties / sql
      Removed value: -{
      -  "description": "One read-only SELECT over the trade tables.",
      -  "maxLength": 20000,
      -  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      -  "type": "string"
      -}
    • changedInput schema / required
      Previous value: -[
      -  "sql"
      -]New value: +[
      +  "querySql"
      +]
    • changedOutput schema / $defs / value10 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value11"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • addedOutput schema / $defs / value11 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value11 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value12"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value11 / properties
      Added value: +{
      +  "Column": {
      +    "type": "string"
      +  },
      +  "Prefix": {
      +    "type": "boolean"
      +  },
      +  "Values": {
      +    "$ref": "#/$defs/value12"
      +  }
      +}
    • addedOutput schema / $defs / value11 / required
      Added value: +[
      +  "Column",
      +  "Prefix",
      +  "Values"
      +]
    • addedOutput schema / $defs / value11 / type
      Added value: +"object"
    • removedOutput schema / $defs / value12 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value12 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value12 / properties
      Removed value: -{
      -  "Column": {
      -    "type": "string"
      -  },
      -  "Prefix": {
      -    "type": "boolean"
      -  },
      -  "Values": {
      -    "$ref": "#/$defs/value13"
      -  }
      -}
    • removedOutput schema / $defs / value12 / required
      Removed value: -[
      -  "Column",
      -  "Prefix",
      -  "Values"
      -]
    • removedOutput schema / $defs / value12 / type
      Removed value: -"object"
    • changedOutput schema / $defs / value13 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": [
      +        "null",
      +        "boolean",
      +        "number",
      +        "string",
      +        "array",
      +        "object"
      +      ]
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • changedOutput schema / $defs / value14 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value15"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • addedOutput schema / $defs / value15 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value15 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value16"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value15 / properties
      Added value: +{
      +  "command": {
      +    "type": "string"
      +  },
      +  "cost": {
      +    "type": "string"
      +  },
      +  "label": {
      +    "type": "string"
      +  },
      +  "rationale": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value15 / required
      Added value: +[
      +  "command",
      +  "cost",
      +  "label",
      +  "rationale"
      +]
    • addedOutput schema / $defs / value15 / type
      Added value: +"object"
    • removedOutput schema / $defs / value16 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value16 / anyOf
      Added value: +[
      +  {
      +    "additionalProperties": {
      +      "type": "number"
      +    },
      +    "type": "object"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value16 / properties
      Removed value: -{
      -  "command": {
      -    "type": "string"
      -  },
      -  "cost": {
      -    "type": "string"
      -  },
      -  "label": {
      -    "type": "string"
      -  },
      -  "rationale": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value16 / required
      Removed value: -[
      -  "command",
      -  "cost",
      -  "label",
      -  "rationale"
      -]
    • removedOutput schema / $defs / value16 / type
      Removed value: -"object"
    • changedOutput schema / $defs / value17 / anyOf
      Previous value: -[
      -  {
      -    "additionalProperties": {
      -      "type": "number"
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value18"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • addedOutput schema / $defs / value18 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value18 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value19"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value18 / properties
      Added value: +{
      +  "code": {
      +    "type": "string"
      +  },
      +  "message": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value18 / required
      Added value: +[
      +  "code",
      +  "message"
      +]
    • addedOutput schema / $defs / value18 / type
      Added value: +"object"
    • removedOutput schema / $defs / value19 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value19 / anyOf
      Added value: +[
      +  {
      +    "additionalProperties": {
      +      "type": [
      +        "null",
      +        "boolean",
      +        "number",
      +        "string",
      +        "array",
      +        "object"
      +      ]
      +    },
      +    "type": "object"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value19 / properties
      Removed value: -{
      -  "code": {
      -    "type": "string"
      -  },
      -  "message": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value19 / required
      Removed value: -[
      -  "code",
      -  "message"
      -]
    • removedOutput schema / $defs / value19 / type
      Removed value: -"object"
    • removedOutput schema / $defs / value20
      Removed value: -{
      -  "anyOf": [
      -    {
      -      "additionalProperties": {
      -        "type": [
      -          "null",
      -          "boolean",
      -          "number",
      -          "string",
      -          "array",
      -          "object"
      -        ]
      -      },
      -      "type": "object"
      -    },
      -    {
      -      "type": "null"
      -    }
      -  ]
      -}
    • changedOutput schema / $defs / value4 / properties / scope / $ref
      Previous value: -"#/$defs/value6"New value: +"#/$defs/value5"
    • removedOutput schema / $defs / value4 / properties / valueEvidence
      Removed value: -{
      -  "anyOf": [
      -    {
      -      "$ref": "#/$defs/value5"
      -    },
      -    {
      -      "type": "null"
      -    }
      -  ]
      -}
    • addedOutput schema / $defs / value5 / properties / CompanyKeys
      Added value: +{
      +  "$ref": "#/$defs/value6"
      +}
    • addedOutput schema / $defs / value5 / properties / Destination
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / Empty
      Added value: +{
      +  "type": "boolean"
      +}
    • addedOutput schema / $defs / value5 / properties / From
      Added value: +{
      +  "format": "date-time",
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / GroupBy
      Added value: +{
      +  "$ref": "#/$defs/value8"
      +}
    • addedOutput schema / $defs / value5 / properties / HS2
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / HS6
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / NormalizedNames
      Added value: +{
      +  "$ref": "#/$defs/value7"
      +}
    • addedOutput schema / $defs / value5 / properties / Origin
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / Population
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / ReportingCountry
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / RetainedFilters
      Added value: +{
      +  "$ref": "#/$defs/value10"
      +}
    • addedOutput schema / $defs / value5 / properties / Role
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / Source
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / To
      Added value: +{
      +  "format": "date-time",
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / Transport
      Added value: +{
      +  "type": "string"
      +}
    • addedOutput schema / $defs / value5 / properties / Unsupported
      Added value: +{
      +  "$ref": "#/$defs/value9"
      +}
    • removedOutput schema / $defs / value5 / properties / shipmentsExcludedImplausible
      Removed value: -{
      -  "type": "integer"
      -}
    • removedOutput schema / $defs / value5 / properties / shipmentsUsed
      Removed value: -{
      -  "type": "integer"
      -}
    • removedOutput schema / $defs / value5 / properties / weightKg
      Removed value: -{
      -  "type": "number"
      -}
    • changedOutput schema / $defs / value5 / required
      Previous value: -[
      -  "shipmentsExcludedImplausible",
      -  "shipmentsUsed",
      -  "weightKg"
      -]New value: +[
      +  "CompanyKeys",
      +  "Destination",
      +  "Empty",
      +  "From",
      +  "GroupBy",
      +  "HS2",
      +  "HS6",
      +  "NormalizedNames",
      +  "Origin",
      +  "Population",
      +  "ReportingCountry",
      +  "RetainedFilters",
      +  "Role",
      +  "Source",
      +  "To",
      +  "Transport",
      +  "Unsupported"
      +]
    • removedOutput schema / $defs / value6 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value6 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value6 / properties
      Removed value: -{
      -  "CompanyKeys": {
      -    "$ref": "#/$defs/value7"
      -  },
      -  "Destination": {
      -    "type": "string"
      -  },
      -  "Empty": {
      -    "type": "boolean"
      -  },
      -  "From": {
      -    "format": "date-time",
      -    "type": "string"
      -  },
      -  "GroupBy": {
      -    "$ref": "#/$defs/value9"
      -  },
      -  "HS2": {
      -    "type": "string"
      -  },
      -  "HS6": {
      -    "type": "string"
      -  },
      -  "NormalizedNames": {
      -    "$ref": "#/$defs/value8"
      -  },
      -  "Origin": {
      -    "type": "string"
      -  },
      -  "Population": {
      -    "type": "string"
      -  },
      -  "ReportingCountry": {
      -    "type": "string"
      -  },
      -  "RetainedFilters": {
      -    "$ref": "#/$defs/value11"
      -  },
      -  "Role": {
      -    "type": "string"
      -  },
      -  "Source": {
      -    "type": "string"
      -  },
      -  "To": {
      -    "format": "date-time",
      -    "type": "string"
      -  },
      -  "Transport": {
      -    "type": "string"
      -  },
      -  "Unsupported": {
      -    "$ref": "#/$defs/value10"
      -  }
      -}
    • removedOutput schema / $defs / value6 / required
      Removed value: -[
      -  "CompanyKeys",
      -  "Destination",
      -  "Empty",
      -  "From",
      -  "GroupBy",
      -  "HS2",
      -  "HS6",
      -  "NormalizedNames",
      -  "Origin",
      -  "Population",
      -  "ReportingCountry",
      -  "RetainedFilters",
      -  "Role",
      -  "Source",
      -  "To",
      -  "Transport",
      -  "Unsupported"
      -]
    • removedOutput schema / $defs / value6 / type
      Removed value: -"object"
    • changedOutput schema / properties / _debug / $ref
      Previous value: -"#/$defs/value20"New value: +"#/$defs/value19"
    • changedOutput schema / properties / nextActions / $ref
      Previous value: -"#/$defs/value15"New value: +"#/$defs/value14"
    • changedOutput schema / properties / stats / $ref
      Previous value: -"#/$defs/value17"New value: +"#/$defs/value16"
    • changedOutput schema / properties / warnings / $ref
      Previous value: -"#/$defs/value18"New value: +"#/$defs/value17"
  4. Changed70 schema fields changed
    • removedInput schema / properties / querySql
      Removed value: -{
      -  "description": "A single read-only SELECT over the trade tables (tradeData + signal tables)",
      -  "maxLength": 20000,
      -  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      -  "type": "string"
      -}
    • addedInput schema / properties / sql
      Added value: +{
      +  "description": "One read-only SELECT over the trade tables.",
      +  "maxLength": 20000,
      +  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      +  "type": "string"
      +}
    • changedInput schema / required
      Previous value: -[
      -  "querySql"
      -]New value: +[
      +  "sql"
      +]
    • changedOutput schema / $defs / value10 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value11"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value11 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value11 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value12"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value11 / properties
      Removed value: -{
      -  "Column": {
      -    "type": "string"
      -  },
      -  "Prefix": {
      -    "type": "boolean"
      -  },
      -  "Values": {
      -    "$ref": "#/$defs/value12"
      -  }
      -}
    • removedOutput schema / $defs / value11 / required
      Removed value: -[
      -  "Column",
      -  "Prefix",
      -  "Values"
      -]
    • removedOutput schema / $defs / value11 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value12 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value12 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value12 / properties
      Added value: +{
      +  "Column": {
      +    "type": "string"
      +  },
      +  "Prefix": {
      +    "type": "boolean"
      +  },
      +  "Values": {
      +    "$ref": "#/$defs/value13"
      +  }
      +}
    • addedOutput schema / $defs / value12 / required
      Added value: +[
      +  "Column",
      +  "Prefix",
      +  "Values"
      +]
    • addedOutput schema / $defs / value12 / type
      Added value: +"object"
    • changedOutput schema / $defs / value13 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": "string"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • changedOutput schema / $defs / value14 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value15"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "items": {
      +      "type": [
      +        "null",
      +        "boolean",
      +        "number",
      +        "string",
      +        "array",
      +        "object"
      +      ]
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value15 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value15 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value16"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value15 / properties
      Removed value: -{
      -  "command": {
      -    "type": "string"
      -  },
      -  "cost": {
      -    "type": "string"
      -  },
      -  "label": {
      -    "type": "string"
      -  },
      -  "rationale": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value15 / required
      Removed value: -[
      -  "command",
      -  "cost",
      -  "label",
      -  "rationale"
      -]
    • removedOutput schema / $defs / value15 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value16 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value16 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": "number"
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value16 / properties
      Added value: +{
      +  "command": {
      +    "type": "string"
      +  },
      +  "cost": {
      +    "type": "string"
      +  },
      +  "label": {
      +    "type": "string"
      +  },
      +  "rationale": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value16 / required
      Added value: +[
      +  "command",
      +  "cost",
      +  "label",
      +  "rationale"
      +]
    • addedOutput schema / $defs / value16 / type
      Added value: +"object"
    • changedOutput schema / $defs / value17 / anyOf
      Previous value: -[
      -  {
      -    "items": {
      -      "$ref": "#/$defs/value18"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]New value: +[
      +  {
      +    "additionalProperties": {
      +      "type": "number"
      +    },
      +    "type": "object"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value18 / additionalProperties
      Removed value: -false
    • addedOutput schema / $defs / value18 / anyOf
      Added value: +[
      +  {
      +    "items": {
      +      "$ref": "#/$defs/value19"
      +    },
      +    "type": "array"
      +  },
      +  {
      +    "type": "null"
      +  }
      +]
    • removedOutput schema / $defs / value18 / properties
      Removed value: -{
      -  "code": {
      -    "type": "string"
      -  },
      -  "message": {
      -    "type": "string"
      -  }
      -}
    • removedOutput schema / $defs / value18 / required
      Removed value: -[
      -  "code",
      -  "message"
      -]
    • removedOutput schema / $defs / value18 / type
      Removed value: -"object"
    • addedOutput schema / $defs / value19 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value19 / anyOf
      Removed value: -[
      -  {
      -    "additionalProperties": {
      -      "type": [
      -        "null",
      -        "boolean",
      -        "number",
      -        "string",
      -        "array",
      -        "object"
      -      ]
      -    },
      -    "type": "object"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value19 / properties
      Added value: +{
      +  "code": {
      +    "type": "string"
      +  },
      +  "message": {
      +    "type": "string"
      +  }
      +}
    • addedOutput schema / $defs / value19 / required
      Added value: +[
      +  "code",
      +  "message"
      +]
    • addedOutput schema / $defs / value19 / type
      Added value: +"object"
    • addedOutput schema / $defs / value20
      Added value: +{
      +  "anyOf": [
      +    {
      +      "additionalProperties": {
      +        "type": [
      +          "null",
      +          "boolean",
      +          "number",
      +          "string",
      +          "array",
      +          "object"
      +        ]
      +      },
      +      "type": "object"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • changedOutput schema / $defs / value4 / properties / scope / $ref
      Previous value: -"#/$defs/value5"New value: +"#/$defs/value6"
    • addedOutput schema / $defs / value4 / properties / valueEvidence
      Added value: +{
      +  "anyOf": [
      +    {
      +      "$ref": "#/$defs/value5"
      +    },
      +    {
      +      "type": "null"
      +    }
      +  ]
      +}
    • removedOutput schema / $defs / value5 / properties / CompanyKeys
      Removed value: -{
      -  "$ref": "#/$defs/value6"
      -}
    • removedOutput schema / $defs / value5 / properties / Destination
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Empty
      Removed value: -{
      -  "type": "boolean"
      -}
    • removedOutput schema / $defs / value5 / properties / From
      Removed value: -{
      -  "format": "date-time",
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / GroupBy
      Removed value: -{
      -  "$ref": "#/$defs/value8"
      -}
    • removedOutput schema / $defs / value5 / properties / HS2
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / HS6
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / NormalizedNames
      Removed value: -{
      -  "$ref": "#/$defs/value7"
      -}
    • removedOutput schema / $defs / value5 / properties / Origin
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Population
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / ReportingCountry
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / RetainedFilters
      Removed value: -{
      -  "$ref": "#/$defs/value10"
      -}
    • removedOutput schema / $defs / value5 / properties / Role
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Source
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / To
      Removed value: -{
      -  "format": "date-time",
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Transport
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / $defs / value5 / properties / Unsupported
      Removed value: -{
      -  "$ref": "#/$defs/value9"
      -}
    • addedOutput schema / $defs / value5 / properties / shipmentsExcludedImplausible
      Added value: +{
      +  "type": "integer"
      +}
    • addedOutput schema / $defs / value5 / properties / shipmentsUsed
      Added value: +{
      +  "type": "integer"
      +}
    • addedOutput schema / $defs / value5 / properties / weightKg
      Added value: +{
      +  "type": "number"
      +}
    • changedOutput schema / $defs / value5 / required
      Previous value: -[
      -  "CompanyKeys",
      -  "Destination",
      -  "Empty",
      -  "From",
      -  "GroupBy",
      -  "HS2",
      -  "HS6",
      -  "NormalizedNames",
      -  "Origin",
      -  "Population",
      -  "ReportingCountry",
      -  "RetainedFilters",
      -  "Role",
      -  "Source",
      -  "To",
      -  "Transport",
      -  "Unsupported"
      -]New value: +[
      +  "shipmentsExcludedImplausible",
      +  "shipmentsUsed",
      +  "weightKg"
      +]
    • addedOutput schema / $defs / value6 / additionalProperties
      Added value: +false
    • removedOutput schema / $defs / value6 / anyOf
      Removed value: -[
      -  {
      -    "items": {
      -      "type": "string"
      -    },
      -    "type": "array"
      -  },
      -  {
      -    "type": "null"
      -  }
      -]
    • addedOutput schema / $defs / value6 / properties
      Added value: +{
      +  "CompanyKeys": {
      +    "$ref": "#/$defs/value7"
      +  },
      +  "Destination": {
      +    "type": "string"
      +  },
      +  "Empty": {
      +    "type": "boolean"
      +  },
      +  "From": {
      +    "format": "date-time",
      +    "type": "string"
      +  },
      +  "GroupBy": {
      +    "$ref": "#/$defs/value9"
      +  },
      +  "HS2": {
      +    "type": "string"
      +  },
      +  "HS6": {
      +    "type": "string"
      +  },
      +  "NormalizedNames": {
      +    "$ref": "#/$defs/value8"
      +  },
      +  "Origin": {
      +    "type": "string"
      +  },
      +  "Population": {
      +    "type": "string"
      +  },
      +  "ReportingCountry": {
      +    "type": "string"
      +  },
      +  "RetainedFilters": {
      +    "$ref": "#/$defs/value11"
      +  },
      +  "Role": {
      +    "type": "string"
      +  },
      +  "Source": {
      +    "type": "string"
      +  },
      +  "To": {
      +    "format": "date-time",
      +    "type": "string"
      +  },
      +  "Transport": {
      +    "type": "string"
      +  },
      +  "Unsupported": {
      +    "$ref": "#/$defs/value10"
      +  }
      +}
    • addedOutput schema / $defs / value6 / required
      Added value: +[
      +  "CompanyKeys",
      +  "Destination",
      +  "Empty",
      +  "From",
      +  "GroupBy",
      +  "HS2",
      +  "HS6",
      +  "NormalizedNames",
      +  "Origin",
      +  "Population",
      +  "ReportingCountry",
      +  "RetainedFilters",
      +  "Role",
      +  "Source",
      +  "To",
      +  "Transport",
      +  "Unsupported"
      +]
    • addedOutput schema / $defs / value6 / type
      Added value: +"object"
    • changedOutput schema / properties / _debug / $ref
      Previous value: -"#/$defs/value19"New value: +"#/$defs/value20"
    • changedOutput schema / properties / nextActions / $ref
      Previous value: -"#/$defs/value14"New value: +"#/$defs/value15"
    • changedOutput schema / properties / stats / $ref
      Previous value: -"#/$defs/value16"New value: +"#/$defs/value17"
    • changedOutput schema / properties / warnings / $ref
      Previous value: -"#/$defs/value17"New value: +"#/$defs/value18"
  5. Changed8 schema fields changed
    • removedInput schema / properties / --limit
      Removed value: -{
      -  "description": "Max rows per page (default 100, max 10000)",
      -  "type": "string"
      -}
    • removedInput schema / properties / --offset
      Removed value: -{
      -  "description": "Row offset for paging the full result set (use ORDER BY for a stable page order; nextActions returns the next-page command)",
      -  "type": "string"
      -}
    • removedInput schema / properties / --querySql
      Removed value: -{
      -  "description": "A single read-only SELECT over the trade tables (tradeData + signal tables)",
      -  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      -  "type": "string"
      -}
    • addedInput schema / properties / limit
      Added value: +{
      +  "description": "Max rows per page (default 100, max 10000)",
      +  "maximum": 10000,
      +  "minimum": 1,
      +  "type": "integer"
      +}
    • addedInput schema / properties / offset
      Added value: +{
      +  "description": "Row offset for paging (minimum 0; use ORDER BY for a stable page order).",
      +  "minimum": 0,
      +  "type": "integer"
      +}
    • addedInput schema / properties / querySql
      Added value: +{
      +  "description": "A single read-only SELECT over the trade tables (tradeData + signal tables)",
      +  "maxLength": 20000,
      +  "pattern": "[^\\t\\n\\v\\f\\r\\x85\\p{Z}]",
      +  "type": "string"
      +}
    • changedInput schema / required
      Previous value: -[
      -  "--querySql"
      -]New value: +[
      +  "querySql"
      +]
    • changedOutput schema / (root)
      Previous value: -nullNew value: +{
      +  "$defs": {
      +    "value0": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "columns": {
      +          "$ref": "#/$defs/value1"
      +        },
      +        "history": {
      +          "anyOf": [
      +            {
      +              "$ref": "#/$defs/value4"
      +            },
      +            {
      +              "type": "null"
      +            }
      +          ]
      +        },
      +        "rowCount": {
      +          "type": "integer"
      +        },
      +        "rows": {
      +          "$ref": "#/$defs/value2"
      +        },
      +        "sql": {
      +          "type": "string"
      +        }
      +      },
      +      "required": [
      +        "columns",
      +        "rowCount",
      +        "rows",
      +        "sql"
      +      ],
      +      "type": "object"
      +    },
      +    "value1": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value10": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "$ref": "#/$defs/value11"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value11": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "Column": {
      +          "type": "string"
      +        },
      +        "Prefix": {
      +          "type": "boolean"
      +        },
      +        "Values": {
      +          "$ref": "#/$defs/value12"
      +        }
      +      },
      +      "required": [
      +        "Column",
      +        "Prefix",
      +        "Values"
      +      ],
      +      "type": "object"
      +    },
      +    "value12": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value13": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": [
      +              "null",
      +              "boolean",
      +              "number",
      +              "string",
      +              "array",
      +              "object"
      +            ]
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value14": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "$ref": "#/$defs/value15"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value15": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "command": {
      +          "type": "string"
      +        },
      +        "cost": {
      +          "type": "string"
      +        },
      +        "label": {
      +          "type": "string"
      +        },
      +        "rationale": {
      +          "type": "string"
      +        }
      +      },
      +      "required": [
      +        "command",
      +        "cost",
      +        "label",
      +        "rationale"
      +      ],
      +      "type": "object"
      +    },
      +    "value16": {
      +      "anyOf": [
      +        {
      +          "additionalProperties": {
      +            "type": "number"
      +          },
      +          "type": "object"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value17": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "$ref": "#/$defs/value18"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value18": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "code": {
      +          "type": "string"
      +        },
      +        "message": {
      +          "type": "string"
      +        }
      +      },
      +      "required": [
      +        "code",
      +        "message"
      +      ],
      +      "type": "object"
      +    },
      +    "value19": {
      +      "anyOf": [
      +        {
      +          "additionalProperties": {
      +            "type": [
      +              "null",
      +              "boolean",
      +              "number",
      +              "string",
      +              "array",
      +              "object"
      +            ]
      +          },
      +          "type": "object"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value2": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "$ref": "#/$defs/value3"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value3": {
      +      "anyOf": [
      +        {
      +          "additionalProperties": {
      +            "type": [
      +              "null",
      +              "boolean",
      +              "number",
      +              "string",
      +              "array",
      +              "object"
      +            ]
      +          },
      +          "type": "object"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value4": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "action": {
      +          "type": "string"
      +        },
      +        "builtAt": {
      +          "format": "date-time",
      +          "type": "string"
      +        },
      +        "correctionsThrough": {
      +          "format": "date-time",
      +          "type": "string"
      +        },
      +        "factsThrough": {
      +          "format": "date-time",
      +          "type": "string"
      +        },
      +        "reason": {
      +          "type": "string"
      +        },
      +        "scope": {
      +          "$ref": "#/$defs/value5"
      +        },
      +        "state": {
      +          "type": "string"
      +        }
      +      },
      +      "required": [
      +        "action",
      +        "builtAt",
      +        "correctionsThrough",
      +        "factsThrough",
      +        "reason",
      +        "scope",
      +        "state"
      +      ],
      +      "type": "object"
      +    },
      +    "value5": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "CompanyKeys": {
      +          "$ref": "#/$defs/value6"
      +        },
      +        "Destination": {
      +          "type": "string"
      +        },
      +        "Empty": {
      +          "type": "boolean"
      +        },
      +        "From": {
      +          "format": "date-time",
      +          "type": "string"
      +        },
      +        "GroupBy": {
      +          "$ref": "#/$defs/value8"
      +        },
      +        "HS2": {
      +          "type": "string"
      +        },
      +        "HS6": {
      +          "type": "string"
      +        },
      +        "NormalizedNames": {
      +          "$ref": "#/$defs/value7"
      +        },
      +        "Origin": {
      +          "type": "string"
      +        },
      +        "Population": {
      +          "type": "string"
      +        },
      +        "ReportingCountry": {
      +          "type": "string"
      +        },
      +        "RetainedFilters": {
      +          "$ref": "#/$defs/value10"
      +        },
      +        "Role": {
      +          "type": "string"
      +        },
      +        "Source": {
      +          "type": "string"
      +        },
      +        "To": {
      +          "format": "date-time",
      +          "type": "string"
      +        },
      +        "Transport": {
      +          "type": "string"
      +        },
      +        "Unsupported": {
      +          "$ref": "#/$defs/value9"
      +        }
      +      },
      +      "required": [
      +        "CompanyKeys",
      +        "Destination",
      +        "Empty",
      +        "From",
      +        "GroupBy",
      +        "HS2",
      +        "HS6",
      +        "NormalizedNames",
      +        "Origin",
      +        "Population",
      +        "ReportingCountry",
      +        "RetainedFilters",
      +        "Role",
      +        "Source",
      +        "To",
      +        "Transport",
      +        "Unsupported"
      +      ],
      +      "type": "object"
      +    },
      +    "value6": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value7": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value8": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    },
      +    "value9": {
      +      "anyOf": [
      +        {
      +          "items": {
      +            "type": "string"
      +          },
      +          "type": "array"
      +        },
      +        {
      +          "type": "null"
      +        }
      +      ]
      +    }
      +  },
      +  "additionalProperties": false,
      +  "properties": {
      +    "_debug": {
      +      "$ref": "#/$defs/value19"
      +    },
      +    "correlationId": {
      +      "type": "string"
      +    },
      +    "data": {
      +      "additionalProperties": false,
      +      "properties": {
      +        "context": {
      +          "type": [
      +            "null",
      +            "boolean",
      +            "number",
      +            "string",
      +            "array",
      +            "object"
      +          ]
      +        },
      +        "cursor": {
      +          "type": "string"
      +        },
      +        "has_more": {
      +          "type": "boolean"
      +        },
      +        "items": {
      +          "anyOf": [
      +            {
      +              "items": {
      +                "$ref": "#/$defs/value0"
      +              },
      +              "type": "array"
      +            },
      +            {
      +              "type": "null"
      +            }
      +          ]
      +        }
      +      },
      +      "required": [
      +        "context",
      +        "has_more",
      +        "items"
      +      ],
      +      "type": "object"
      +    },
      +    "nextActions": {
      +      "$ref": "#/$defs/value14"
      +    },
      +    "stats": {
      +      "$ref": "#/$defs/value16"
      +    },
      +    "summary": {
      +      "type": "string"
      +    },
      +    "warnings": {
      +      "$ref": "#/$defs/value17"
      +    }
      +  },
      +  "required": [
      +    "data",
      +    "nextActions",
      +    "summary"
      +  ],
      +  "type": "object"
      +}
  6. First observed

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint, idempotentHint, and destructiveHint=false, so the safety profile is covered. The description adds useful operational constraints beyond annotations: raw fact tables require a WHERE clause and results are row-limited.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two tight sentences with the core purpose and key constraints front-loaded. Every clause carries useful information with no repetition.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only SQL tool with an output schema and full parameter documentation, the description covers the important constraints: read-only, single SELECT, allowed tables, WHERE requirement, row limits, and the fallback sibling. It does not enumerate allowed tables, but the catalog sibling likely covers that.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% and each parameter is already documented, so the baseline is 3. The description adds a general SQL constraint about raw fact tables needing WHERE, but does not expand on limit or offset semantics beyond what the schema provides.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb and resource: running one read-only SELECT over allowed trade tables. It also distinguishes the tool from the analytics query sibling by explaining when SQL is needed instead.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives an explicit condition for choosing this tool: use it when the analytics query cannot express the question. However, it does not name the exact sibling or state additional exclusions, so it falls short of the most complete routing guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.