Dataset Aggregate & Pivot
io.github.nero-engine/dataset-aggregate-pivotGROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
Score: 90/100
Handshake verified by our own probe.
How to earn +10 points
Tools · 2
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,…
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, val…
How to use
Claude Desktop or claude.ai: add a custom connector (Customize → Connectors; on Team and Enterprise plans an owner adds it under Organization settings → Connectors) with this server URL: https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
Cursor or Cline: add to your MCP config:
{
"mcpServers": {
"dataset_aggregate_\u0026_pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp",
"transport": "streamable-http"
}
}
}