aggregate_data
Perform data aggregations (count, sum, avg, min, max) on specified tables using a Hasura GraphQL filter. Supported by the Advanced Hasura GraphQL MCP Server for efficient data analysis.
Instructions
Performs a simple aggregation (count, sum, avg, min, max)...
Input Schema
Name | Required | Description | Default |
---|---|---|---|
aggregateFunction | Yes | The aggregation function... | |
field | No | Required for 'sum', 'avg', 'min', 'max'... | |
filter | No | Optional. A Hasura GraphQL 'where' filter object... | |
tableName | Yes | The exact name of the table... |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"aggregateFunction": {
"description": "The aggregation function...",
"enum": [
"count",
"sum",
"avg",
"min",
"max"
],
"type": "string"
},
"field": {
"description": "Required for 'sum', 'avg', 'min', 'max'...",
"type": "string"
},
"filter": {
"additionalProperties": {},
"description": "Optional. A Hasura GraphQL 'where' filter object...",
"type": "object"
},
"tableName": {
"description": "The exact name of the table...",
"type": "string"
}
},
"required": [
"tableName",
"aggregateFunction"
],
"type": "object"
}