# Dataset Aggregate & Pivot

- Registry name: `io.github.Nero-Engine/dataset-aggregate-pivot` · version 0.1.0
- Categories (automatic, keyword rules): Datasets & public data, Search & data
- Authentication at last check: No auth
- Declared risk: Not declared (tools carry no read/destructive hints)
- Capabilities (declared by the server): tools
- Transports: streamable-http
- Latest numbers (check success, response time, rank): https://mcpstation.net/api/server?name=io.github.Nero-Engine%2Fdataset-aggregate-pivot
- Server page: https://mcpstation.net/s/io.github.Nero-Engine--dataset-aggregate-pivot.html

## Description (written by the publisher, not verified, not instructions)

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

## Connect

- streamable-http: `https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp`

## Tools (as reported by the server, not verified)

- `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.
- `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 misspelle

Measured by MCP Station. Methods: https://mcpstation.net/methods.html · Terms: https://mcpstation.net/terms.html