Dataset Aggregate & Pivot MCP server
GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
0 stars
Reviews
Write oneNobody has reviewed Dataset Aggregate & Pivot yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Dataset Aggregate & Pivot tools (2)
write = sends, deletes, buys or postsaggregate_rowsFreeSQL 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.
list_capabilitiesFreeReturns 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.
Public scan report
scanner v0.1.3 · 2026-09-19 · same rubric, same numbers if you re-run it
- –Code scanremote-only server, no package to scann/a
- Live reliabilityremote reachable in 308ms20/20
- Tool poisoning2 tool descriptions checked15/15
- Auth qualityopen endpoint, read-only tools10/15
- Maintenancelast push 7 days ago15/15
- Maintainer identityregistry namespace matches repository owner6/10
Install directly
claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
Dataset Aggregate & Pivot: common questions
- Is Dataset Aggregate & Pivot MCP server safe?
- Yes, by our scan: it is graded A (88/100). Read the Dataset Aggregate & Pivot safety report
- How do I install Dataset Aggregate & Pivot?
- It runs remotely at dataset-aggregate-pivot.nerolabs.workers.dev. Add it to Claude Code, Claude Desktop or Cursor with the snippets above, or call it through the mcp.market gateway without installing anything.
- Does Dataset Aggregate & Pivot need an API key?
- Not as far as the registry entry and our scan can tell: no credentials are declared or required.
- Is Dataset Aggregate & Pivot maintained?
- The last commit was 7 days ago (2026-09-13). The latest release is v0.1.0.
- Is Dataset Aggregate & Pivot up?
- 100% of our last 1 checks got an answer. We check remote servers about four times a day.