Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http dataset-aggregate-group-by-pivot 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot' --header 'Authorization: <AUTHORIZATION>'~/.codex/config.toml
[mcp_servers.dataset-aggregate-group-by-pivot]
url = "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot"
http_headers = { Authorization = "<AUTHORIZATION>" }
# codex mcp add dataset-aggregate-group-by-pivot --url 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot'~/.cursor/mcp.json
{
"mcpServers": {
"dataset-aggregate-group-by-pivot": {
"url": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"dataset-aggregate-group-by-pivot": {
"type": "http",
"url": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"dataset-aggregate-group-by-pivot": {
"httpUrl": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"dataset-aggregate-group-by-pivot": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"--header",
"Authorization:<AUTHORIZATION>"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"dataset-aggregate-group-by-pivot": {
"url": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}