Dataset Aggregate, Group By & Pivot

Overview

Dataset Aggregate, Group By & Pivot is an MCP server that generates GROUP BY and pivot tables from Apify datasets, files, Google Sheets, or JSON data provided by URL. It transforms raw data into aggregated and pivoted formats, making it easy to analyze and summarize information from multiple sources through a simple interface.

The server runs as a hosted remote endpoint at https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot. You authenticate with an API key and require no local installation — just point your MCP client to the endpoint to connect. The latest release is v0.1.0, available through Apify at https://apify.com/nerolabs/dataset-aggregate-pivot.

Dataset Aggregate, Group By & Pivot is listed in the Development category on mcp.site and works with Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Zed, and other MCP clients. If you maintain this server, claim this listing to verify ownership and keep the information up to date.

Installation

Settings → Connectors → Add custom connector
Name: Dataset Aggregate, Group By & Pivot
URL:  https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot