GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
unavailable — hosted endpoints aren’t versioned
Streamable HTTP
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
Pick your client — the config below is generated for this server (hosted endpoint). Copy respects the “Pin version” switch above.
Remote (hosted) endpoint
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
Claude Desktop: Settings → Connectors → Add custom connector, paste this URL.
Format verified against the official Claude Desktop docs ↗.
terminal
claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
Format verified against the official Claude Code docs ↗.
.cursor/mcp.json (hosted endpoint)
{
"mcpServers": {
"dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}Format verified against the official Cursor docs ↗.
.vscode/mcp.json (hosted endpoint)
{
"servers": {
"dataset-aggregate-pivot": {
"type": "http",
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}Format verified against the official VS Code docs ↗.
mcp_config.json (hosted endpoint)
{
"mcpServers": {
"dataset-aggregate-pivot": {
"serverUrl": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}Format verified against the official Windsurf docs ↗.
最近更新于 46 天前
Dataset Aggregate & Pivot (Remote MCP Server) SQL GROUP BY and spreadsheet pivot tables for messy JSON rows, in a single tool call. Hand it a list of rows from a scraper, an API or a spreadsheet, say what to group by and what to compute, and it hands back one clean summary row per group plus an exac…
Summary from the project README — github.com/Nero-Engine/dataset-aggregate-pivot-mcp
Distributed as Streamable HTTP, listed under Data & Analytics. Review our MCP security guide before granting access to real data.
Dataset Aggregate & Pivot (Remote MCP Server) SQL GROUP BY and spreadsheet pivot tables for messy JSON rows, in a single tool call. Hand it a list of rows from a scraper, an API or a spreadsheet, say what to group by and what to compute, and it hands back one clean summary row per group plus an exac
Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.
The MCP server itself is free to install. The source is public on https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp. Any third-party service it calls may require its own API key and account.
Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.
Publish this server? Link back with a badge on your README or site — copy either snippet.
Markdown
[](https://mcpnav.net/server/dataset-aggregate-pivot/)
HTML
<a href="https://mcpnav.net/server/dataset-aggregate-pivot/"><img src="https://mcpnav.net/badge/dataset-aggregate-pivot.svg" alt="Listed on MCPNav" height="20"></a>