{"data":{"name":"io.github.Nero-Engine/dataset-aggregate-pivot","title":"Dataset Aggregate & Pivot","description":"GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.","version":"0.1.0","websiteUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp","repositoryUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp","remotes":[{"url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp","type":"streamable-http"}],"packages":[],"status":"active","isLatest":true,"publishedAt":"2026-09-13T00:07:44.261Z","updatedAt":"2026-09-13T00:07:44.261Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":"Dataset Aggregate & Pivot","source":"official-registry","sourceId":"io.github.Nero-Engine/dataset-aggregate-pivot","updatedAt":"2026-09-13T00:07:44.261Z","confidence":100,"websiteUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp","description":"GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.","verification":"official","repositoryUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp"}],"toolIndex":{"tools":[{"serverName":"io.github.Nero-Engine/dataset-aggregate-pivot","endpointFingerprint":"5df8a81c2e394444384f5e08724bf44041ba1449d0072678f30ee72eff85dcf5","name":"aggregate_rows","title":null,"description":"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.","inputSchema":{"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},"annotations":null,"definitionHash":"e85ded3d6b3ae6a45737c3543c0aad1c06682e09917457212948afd4082d373b","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T22:47:07.884Z","metadataTrust":"untrusted"},{"serverName":"io.github.Nero-Engine/dataset-aggregate-pivot","endpointFingerprint":"5df8a81c2e394444384f5e08724bf44041ba1449d0072678f30ee72eff85dcf5","name":"list_capabilities","title":null,"description":"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.","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":null,"definitionHash":"910dac8cd5cdb68460cf50d71dbd349b19717f46e95c223480351f00c93508cb","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T22:47:07.884Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"5df8a81c2e394444384f5e08724bf44041ba1449d0072678f30ee72eff85dcf5","protocol":"streamable-http","status":"indexed","toolCount":2,"observedAt":"2026-11-19T22:47:07.884Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"io.github.Nero-Engine/dataset-aggregate-pivot":{"url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}},"Cursor":{"mcpServers":{"io.github.Nero-Engine/dataset-aggregate-pivot":{"url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}},"VS Code":{"servers":{"io.github.Nero-Engine/dataset-aggregate-pivot":{"type":"http","url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:io.github.Nero-Engine%2Fdataset-aggregate-pivot","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/io.github.Nero-Engine%2Fdataset-aggregate-pivot","name":"io.github.Nero-Engine/dataset-aggregate-pivot","description":"GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp","repositoryUrl":"https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp","version":"0.1.0"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"io.github.Nero-Engine/dataset-aggregate-pivot","status":"online","lastCheckedAt":"2026-11-20T04:17:14.305Z","lastSuccessfulCheck":"2026-11-20T04:17:14.305Z","latencyMs":60,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T04:17:14.305Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T04:17:14.305Z"},"security":null,"timestamps":{"createdAt":"2026-09-13T00:07:44.261Z","updatedAt":"2026-09-13T00:07:44.261Z","observedAt":"2026-11-20T04:17:14.305Z"},"compatibility":{"serverVersion":"0.1.0","protocolVersions":[{"protocol":"mcp","version":null}]}}}}