GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
Scored across 2 tools
The two tools serve completely distinct purposes: aggregate_rows performs the actual aggregation/pivot operation, while list_capabilities is a static metadata/discovery helper. There is no overlap in function or trigger conditions.
Both names follow a clear snake_case verb_noun pattern: aggregate_rows and list_capabilities. The convention is consistent and predictable.
With only two tools, one of which is a static capability lister, the set feels thin for a dataset aggregation server. A dedicated pivot tool or data preview tool could reasonably earn its place, though the count is not extreme.
The core aggregation/pivot operation is well covered with grouping, topN, blank handling, warnings, and limits documented via list_capabilities. Minor gaps exist around data preview or schema inspection, but agents can work around them.
SQL GROUP BY and a spreadsheet pivot table for a list of JSON rows, in one call. Returns one output row per group with the aggregated columns, plus a summary: groups found, groups dropped by topN, values skipped because they were blank or not numeric (never guessed), and warnings such as a misspelled field name. Use it to turn scraped or API records into totals: orders and revenue per region, average price per brand, listings per city per month, top 10 products by revenue. Messy data is expected: "South" and "south " group together, and "$1,234.50" sums as 1234.5. Leave groupByFields empty to summarise all rows into one row. At most 500 rows per call.
Inputs: rows (required), topN, sortBy, pivotField, +10 more.
Returns the 11 aggregation functions and what each one does, the date bucket formats, the labels used for blank, invalid-date and total rows, and the limits per call (rows, pivot columns, pivot cells, aggregations). Call this first if you are unsure what is available. Free, processes no data.
Inputs: no named parameters.
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...
Clean, filter and reshape JSON rows in one call: 26 transforms, 25 filters, sort, dedupe, limit.
Excel analytics: inspect, query (JSON rows), charts, and JSON-to-xlsx workbook writing.
Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.
Add one secure layer between your agents and this server.