Dataset Aggregate & Pivot MCP Server

by nero-engine Your server? Claim it

answering

Dataset Aggregate & Pivot is answering right now. Last checked 3 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 6 days of history

6 days agonow

100.0%

Uptime 24h

92 of 92 checks

Tools

read from the server

76 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 3 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

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "url": "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

{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "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	87 ms	3 min ago

Alternatives to Dataset Aggregate & Pivot

same job, measured the same way

Pivot

by theluckystrike

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

local only

MCP Data

by infoinlet-marketplace

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

23 installs/wk local only

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

China NMPA Medical Device Data

by huangjunsong404-crypto

Structured China NMPA UDI data for AI agents: devices, registrants, models and registration numbers.

6 tools answering

Dataset to Postgres, Supabase & MySQL (Database Push)

by nero-engine

Push rows from a dataset, file or Google Sheet into a Postgres, Supabase, Neon or MySQL table.

answering

MCP Coda

by vish288

MCP server for Coda API — docs, pages, tables, rows, formulas, permissions, and automation.

264 installs/wk local only

Appwrite

by appwrite

Manage Appwrite projects, databases, auth, storage, functions, and messaging; search Appwrite docs

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 92 of 92 checks got a reply (100.0%), average response time 76 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 with the file path 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 76 ms on average, which is faster than 86% 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.