Dataset Aggregate & Pivot

io.github.Nero-Engine/dataset-aggregate-pivotVersion 0.1.0

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

Status

Responds142 msNov 14, 2026, 14:40 UTCAnswered our handshake without sign-in.

Registry data may be out of date

We could not refresh it, so this page shows the last copy.

Last checked: Nov 14, 2026, 14:40 UTC
Latency: 142 ms
Remotes responding: 1 of 1
Sign-in: No sign-in
Hosting: Hosted outside the EU (detected)
Registry data as of: Nov 14, 2026, 21:12 UTC

Data from the official MCP Registry, checked by run.zero. How we check

Connect

Streamable HTTP

https://dataset-aggregate-pivot.nerolabs.workers.dev/mcpResponds142 msNov 14, 2026, 14:40 UTC

No sign-in

Claude Code

claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Claude Desktop and claude.ai

1
2
3

Settings > Connectors > Add custom connector
Name: dataset-aggregate-pivot
Remote MCP server URL: https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Cursor

{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}

VS Code

code --add-mcp '{"name":"dataset-aggregate-pivot","type":"http","url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}'

Built your own server? run.zero hosts MCP servers on European infrastructure.

Host your own MCP server on run.zero

Tools

2 tools

Tools of Dataset Aggregate & Pivot
	Description		Read-only	Idempotent	Open world
`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.	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.	Not declared	Not declared	Not declared	Not declared
`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.	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.	Not declared	Not declared	Not declared	Not declared

Details

Registry status: Active
Published: Sep 13, 2026
Updated: Sep 13, 2026
Website: https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp⁠ (opens in a new tab)
Repository: https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp⁠ (opens in a new tab)
Categories (suggested): Data and analyticsSuggested categories are assigned automatically from the registry text and may be wrong. Verified operators can correct them.
GDPR: Not declared

Are you the operator? Claim this listing