Dataset Aggregate & Pivot
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp ↗
Description
GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
What our measurements say
Dataset Aggregate & Pivot is a remote MCP server published at dataset-aggregate-pivot.nerolabs.workers.dev. It has been probed 5 times since 9/13/2026. It answered in 5 of them (100.0%), a near-uninterrupted record. Median response time is 357 ms, placing it among the faster endpoints. It offers a narrow, focused set of 2 tools. On the protocol side it still runs 2025-11-25 and has not moved to the newer spec.
Agent readability score
Can an LLM agent pick the right tool here — names, descriptions and parameter clarity are assessed.
Agent readability score
Agent readability score
Sign up free to generateEvent narrative
Sign up free to generateRaw observations
| Run | Era | Modern | ms | Legacy | ms | Versions |
|---|---|---|---|---|---|---|
| 2026-09-13 12:47:19 | Legacy | 200 | 309 | 200 | 310 | 2025-06-18 |
| 2026-09-13 10:45:14 | Legacy | 200 | 365 | 200 | 395 | 2025-06-18 |
| 2026-09-13 08:43:04 | Legacy | 200 | 370 | 200 | 348 | 2025-06-18 |
| 2026-09-13 06:40:42 | Legacy | 200 | 357 | 200 | 366 | 2025-06-18 |
| 2026-09-13 04:35:29 | Legacy | 200 | 210 | 200 | 211 | 2025-06-18 |
Schema compliance
tools/list structure, inputSchema validity, and a functional smoke test — the components of the 0-100 score.
- tools/list schema valid
- inputSchema is valid JSON Schema
- Smoke test passed · last run:
- Cold-start: cold 42ms → warm 49ms (penalty 0ms)
Tools
Tools the server advertised in the latest measurement — measured, not catalog-claimed.
list_capabilitiesReturns 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_rowsSQL 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.
rowsarrayrequiredgroupByFieldsarrayaggregationsarraygroupMatchingstringdateBucketFieldstringdateBucketGranularitystringpivotFieldstringpivotValueFieldstringpivotFunctionstringlenientNumbersbooleansortBystringsortDirectionstringtopNintegerincludeTotalsRowboolean
Availability history
Each block is one measurement round. Green: working response. Amber: responded but the server was returning errors (5xx). Red: no response at all.
Era history
Each cell is one probe run. Faded cells are incomplete probes — one leg did not answer, so the era is inconclusive.
Response time history
The two probe legs separately: modern server/discover and legacy initialize.
Event log
Derived by comparing consecutive probes — changes in era, protocol version, build and reachability.
- Added to watch — era: Legacy
Get your badge
Add this badge to your README — it updates automatically as measurements change.
[](https://mcpmetrics.io/servers/io-github-nero-engine-dataset-aggregate-pivot)<a href="https://mcpmetrics.io/servers/io-github-nero-engine-dataset-aggregate-pivot"><img src="https://mcpmetrics.io/badge/io.github.Nero-Engine/dataset-aggregate-pivot/era.svg" alt="mcpmetrics"></a>You are seeing the last 7 days. Sign up for the full history. Which check failed and why is in the dashboard.
Sign up free to seeSimilar MCP servers
The catalog entries whose name and description are closest to this one, found with the same index the search box uses.
- Dataset Cleaner & Exporterdataset-cleaner-exporter.nerolabs.workers.dev
Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.
- Dataset Filter & Transformdataset-filter-transform.nerolabs.workers.dev
Clean, filter and reshape JSON rows in one call: 26 transforms, 25 filters, sort, dedupe, limit.
- Dataset Join & Mergedataset-join-merge.nerolabs.workers.dev
Join two lists of JSON rows on a key, like SQL or VLOOKUP: left, inner, full, anti joins, union.
- The Aggregate — LLM benchmark aggregatetheaggregate.ai
Fused LLM rankings: one IRT/Elo scale across ~5,000 public benchmark leaderboards, updated daily.
- Due Datedue-date.gumballtools.com
Estimate a due date from LMP, conception, or ultrasound, with ACOG redating rules.
- UTC ISO dateagent-observatory-sensor.nolimit-observatory.workers.dev
UTC ISO date
Comments
Sign in to write a comment
No comments yet. Be the first.