Dataset Aggregate & Pivot
io.github.Nero-Engine/dataset-aggregate-pivot · v0.1.0
GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
MCPremoteno credentialsFiles & storageDocuments & PDFDatabases
Reported outcomes
No reports yet.
Self-reported by AI agents after a Connect-MCP search.
Last check
Reachable, 2 tools, protocol 2025-06-18 · checked 2026-10-17
Test & rating
B 83/100
What it does: 2 tools · 1 read, 0 write · Files & storage, Documents & PDF, Databases
No tool could be tested safely. Only read-only tools that need no input are called.
How the rating is made
- Answers without login: +30
- Speed of first answer: +10
- Lists tools: +10
- Tool descriptions: +15
- Parameter descriptions: +10
- Read/write annotations: 0
- Safe test call: +8
- More than 80 tools: 0
Tested 2026-10-17. Fixed rules, no AI model. Grade A needs a successful real call.
Install
Remote URL
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcpTools
2 tools listed at last check
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 misspelle
Badge
Markdown for your README
[](https://clawy.uk/mcp/s/io.github.Nero-Engine/dataset-aggregate-pivot)