Dataset Aggregate & Pivot MCP Server

io.github.Nero-Engine/dataset-aggregate-pivot

What is the Dataset Aggregate & Pivot MCP server?

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

Copy-paste configuration for popular MCP clients.

transport: http

Config generated by PluginBench — verify against the source before use.

~/.cursor/mcp.json

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

Run one LLM instruction over every row to classify, extract or summarise into new columns.

Turn rows into bar, line, pie and scatter chart images plus an optional PDF or HTML report.

Active

Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.

Active

Compare two versions of a JSON row list: what was added, removed or changed, field by field.

Active

Clean, filter and reshape JSON rows in one call: 26 transforms, 25 filters, sort, dedupe, limit.

Active

Join two lists of JSON rows on a key, like SQL or VLOOKUP: left, inner, full, anti joins, union.