GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
Install
Run one of the commands below, then add the client config underneath.
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcpClient configuration
Paste into Claude Desktop, Cursor (mcp.json), VS Code or any MCP client, then restart the client.
{
"mcpServers": {
"dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}About this server
Dataset Aggregate & Pivot is listed in the Data & Analytics category of the MCPNav directory. It is distributed as Streamable HTTP and can be loaded by any client that speaks the Model Context Protocol.
Typical uses include giving your assistant scoped access to the corresponding service so it can answer questions and take actions with real data instead of guessing. Always review what a server can access before you enable it — see our MCP security guide.
Frequently asked questions
What is the Dataset Aggregate & Pivot MCP server?＋
Dataset Aggregate & Pivot is an MCP server by Nero-Engine. GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
How do I install Dataset Aggregate & Pivot?＋
Install it with: https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp. Then add the JSON config to your client's MCP settings and restart the client.
Is Dataset Aggregate & Pivot free to use?＋
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 API it calls (such as a search or maps API) may require its own key and billing.
Which clients support Dataset Aggregate & Pivot?＋
Any MCP-compatible client can use it, including Claude Desktop, Cursor, VS Code, Windsurf and custom agents.