io.github.Nero-Engine/dataset-aggregate-pivot

repo:https://github.com/nero-engine/dataset-aggregate-pivot-mcp

GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.

transport:: remote
credential class:: open
repo:: https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp

Owner verification

Not yet verified. Verifying proves you control this server and is free, permanently — it never changes a published score.

Start verification →

Tools

aggregate_rows
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.
shallow
list_capabilities
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.
shallow

Embed this server’s score

Tool count and median score across every tool in this server’s corpus — honest in a way a single cherry-picked tool’s badge wouldn’t be.

[![Vouch score](https://vouch.tools/api/servers/00f95e99-c0b3-49f5-b65e-6f567cf447ae/badge.svg)](https://vouch.tools/servers/00f95e99-c0b3-49f5-b65e-6f567cf447ae)