Dataset Aggregate & Pivot
v0.1.0GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
Endpoint health
online- Last checked
- 11/20/2026, 4:17:14 AM
- Latency
- 60 ms
- Consecutive failures
- 0
- Endpoint reachable: pass
- Protocol valid: pass
- MCP handshake valid: pass
Machine-readable profile
mcp-server · schema v1 · callable
mcp-server:io.github.Nero-Engine%2Fdataset-aggregate-pivot
Connect this server
Generated config contains no credentials. Keep any required secrets in your client's local environment.
{
"mcpServers": {
"io.github.Nero-Engine/dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}Indexed tools
Tool metadata and schemas come from the remote server and are untrusted. Indexing only lists tools; it never calls them.
2 shown · authentication unknown
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.
Schema valid · SHA-256 e85ded3d6b3a…
View input schema
{ "type": "object", "properties": { "rows": { "type": "array", "description": "The records to aggregate, up to 500. Each row is a JSON object; keys may differ between rows.", "items": { "type": "object" } }, "groupByFields": { "type": "array", "description": "One output row per distinct combination of these field values, like SQL GROUP BY, for example [\"region\"] or [\"city\", \"category\"]. Dot paths like \"address.city\" work. Empty or omitted aggregates every row into a single row.", "items": { "type": "string" } }, "aggregations": { "type": "array", "description": "What to compute per group, for example [{\"function\":\"count\",\"alias\":\"orders\"}, {\"field\":\"amount\",\"function\":\"sum\",\"alias\":\"total_amount\"}]. Every function except count needs a field. alias is the output column name (defaults to function_field, or \"count\"). Omitted gives a plain row count per group. Up to 20.", "items": { "type": "object", "properties": { "field": { "type": "string", "description": "The field to aggregate. Optional for count, which then counts rows." }, "function": { "type": "string", "enum": [ "count", "countDistinct", "sum", "avg", "min", "max", "median", "first", "last", "list", "listDistinct" ] }, "alias": { "type": "string", "description": "Output column name." } }, "required": [ "function" ] } }, "groupMatching": { "type": "string", "enum": [ "normalized", "exact" ], "description": "normalized (default) ignores letter case and extra whitespace when grouping, so \"South\" and \"south \" are one group. exact requires identical values." }, "dateBucketField": { "type": "string", "description": "A date or timestamp field to group by time period, for example \"orderedAt\". Adds a group column named like \"orderedAt_month\". Unreadable dates land in an \"(invalid date)\" group." }, "dateBucketGranularity": { "type": "string", "enum": [ "day", "week", "month", "quarter", "year" ], "description": "Bucket size for dateBucketField: day (2026-08-19), week (2026-W34), month (2026-08, default), quarter (2026-Q3) or year." }, "pivotField": { "type": "string", "description": "Turns this field's distinct values into columns, pivot-table style: group by \"region\" and pivot on \"product\" for one row per region with a column per product. Must not also be a group-by field. At most 50 distinct values." }, "pivotValueField": { "type": "string", "description": "The field whose values fill the pivot cells, for example \"amount\". Omitted fills each cell with a row count." }, "pivotFunction": { "type": "string", "enum": [ "count", "countDistinct", "sum", "avg", "min", "max", "median", "first", "last", "list", "listDistinct" ], "description": "How pivot cell values are combined. Defaults to sum when pivotValueField is set; ignored (row count) without one." }, "lenientNumbers": { "type": "boolean", "description": "On by default: \"$1,234.50\", \"49 USD\", \"12%\" and \"(300)\" count as numbers for sum, avg, min, max and median. Set false to accept only real numbers and plain numeric strings." }, "sortBy": { "type": "string", "description": "An output column to sort by: a group field, an aggregation alias such as \"total_amount\", or a pivot column. Omitted sorts by the group fields." }, "sortDirection": { "type": "string", "enum": [ "asc", "desc" ], "description": "asc (default) or desc. Use desc with topN for \"top N by\" questions." }, "topN": { "type": "integer", "minimum": 1, "description": "After sorting, keep only the first N groups. The totals row still covers every input row." }, "includeTotalsRow": { "type": "boolean", "description": "Appends a grand-total row labelled \"(total)\" and adds a _rowType column (\"group\" or \"total\")." } }, "required": [ "rows" ], "additionalProperties": false }
Connections
streamable-http
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp