Dataset Aggregate, Group By & Pivot
Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...
Install
Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).
claude mcp add --transport http dataset-aggregate-group-by-pivot 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot' --header 'Authorization: <Your Apify API token, sent as '\''Bearer <token>'\''. Runs are billed per event to your Apify account.>'
{
"mcpServers": {
"dataset-aggregate-group-by-pivot": {
"type": "http",
"url": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"headers": {
"Authorization": "<Your Apify API token, sent as 'Bearer <token>'. Runs are billed per event to your Apify account.>"
}
}
}
}
Frequently asked questions
What is Dataset Aggregate, Group By & Pivot?
Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...
How do I install Dataset Aggregate, Group By & Pivot?
It runs as a remote server. In Claude Code: claude mcp add --transport http dataset-aggregate-group-by-pivot 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot' --header 'Authorization: <Your Apify API token, sent as '\''Bearer <token>'\''. Runs are billed per event to your Apify account.>'. For other clients, paste the JSON configuration from this page into their MCP settings.
Does Dataset Aggregate, Group By & Pivot need an API key?
Yes. It expects Authorization, which you set in its configuration.
Who maintains Dataset Aggregate, Group By & Pivot?
It is published by Nero-Engine. AI.tn lists it but does not maintain or endorse it.
From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.