Dataset Aggregate & Pivot MCP Server

by nero-engine Your server? Claim it

answering

Dataset Aggregate & Pivot is answering right now. Last checked 2 min ago. It exposes 2 tools. Last commit 13 Sep 2026.

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

Uptime history 51 days of history · worst day 92%

51 days agonow

100.0%

Uptime 24h

91 of 91 checks

Tools

read from the server

104 ms

Response time

average over 24h

Stars

last commit 13 Sep 2026

Nothing serious here today

Today is the operative word: we check Dataset Aggregate & Pivot every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

Endpoint below is the one we actually reach during checks — not the one copied from a README. Last verified 2 min ago.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add dataset-aggregate-pivot --transport http https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Settings → Connectors → Add custom connector, then paste this address

https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

~/.codex/config.toml

[mcp_servers.dataset-aggregate-pivot]
url = "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"

.cursor/mcp.json

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

.vscode/mcp.json

{
  "servers": {
    "dataset-aggregate-pivot": {
      "type": "http",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}

Available tools 2

Read directly from the server with tools/list, grouped by what they act on. If a tool disappears, we record the date.

aggregate

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.

capabilities

list_capabilities

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.

Endpoints

URL	Transport	State	Latency	Checked
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp	streamable-http	answering	80 ms	2 min ago

Alternatives to Dataset Aggregate & Pivot

same job, measured the same way

Dataset Aggregate, Group By & Pivot

by nero-engine

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...

answering

Pivot

by theluckystrike

Group, aggregate and pivot spreadsheet or CSV data from your AI chat: filters, sums, sorts.

13 tools local only

MCP Data

by infoinlet-marketplace

Tabular data for AI agents — load CSV/JSON/XLSX, query, group-by, stats (no database).

42 installs/wk local only

Docbase

by cloudcorprecords

MongoDB tools: query, aggregate, index, and administer collections and databases.

local only

JSON Dataset Cleaner — Merge, Dedup & Export Rows

by kriton-dev

Merge and deduplicate caller-supplied JSON datasets, keep stable row order and export CSV.

answering

Make Bracket Online MCP

by rocnubie

Create, run, and share brackets for decisions, tournaments, and group votes with no sign-up

local only

Dataset Cleaner & Exporter

by nero-engine

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

2 tools answering

GoFormz MCP by usefulapi

by usefulapi

Read GoFormz templates, forms, groups and data sources; create and update forms and rows.

23 tools answering

Dataset Aggregate & Pivot — questions

Answers built from our own checks of this server.

What can Dataset Aggregate & Pivot do?

It exposes 2 tools, read directly from the server on our last check. Among them: aggregate_rows, list_capabilities. The full list with descriptions is on this page — we take it from the server itself via tools/list, not from a README. How MCP servers expose tools in the first place →

Is Dataset Aggregate & Pivot working right now?

We send a real MCP handshake every 15 minutes. Over the last 24 hours 91 of 91 checks got a reply (100.0%), average response time 104 ms. The bar chart above shows every period we have measured.

How do I connect Dataset Aggregate & Pivot?

Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It is a remote server, so there is nothing to install — the client connects to the address.

Does Dataset Aggregate & Pivot need an API key?

No. Dataset Aggregate & Pivot completed a full MCP handshake with us as an anonymous client and listed its tools without asking for anything. All 2 of them are readable on this page. This is what we observed, not what the docs claim.

How fast is Dataset Aggregate & Pivot?

It answers our handshake in 104 ms on average, which is faster than 91% of all working MCP servers we measure. That puts it in the quick quarter of the ecosystem. The comparison comes from our own checks across the whole registry, every 15 minutes.

Is Dataset Aggregate & Pivot open source?

We cannot say either way: 0 stars on GitHub, but we could not determine the licence, and without one the code is not open source by default.