Dataset Aggregate, Group By & Pivot

io.github.Nero-Enginev0.1.0Updated Oct 1, 2026

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...

VerifiedStreamable HTTPWeb executableData & Analytics

Overview

AI-generated overview

Lets an assistant run GROUP BY and pivot-style aggregations over Apify datasets, files, Google Sheets, or JSON inputs.

What it does
This remote MCP server produces grouped and pivot table results from tabular data. According to its description, it accepts an Apify dataset, a file or Google Sheet by URL, or JSON as input and returns aggregated output. It is hosted by Apify and reached over streamable HTTP, so no local package is installed.
When to use it
Use it when you already have data in an Apify dataset, a shared file, a Google Sheet, or JSON and want grouped summaries or pivot tables without writing aggregation code. It fits quick reporting and exploratory analysis rather than general data processing.
Requirements
A remote endpoint at mcp.apify.com over streamable HTTP. An Apify API token is required, sent in the Authorization header as a Bearer token. No local runtime or packages are declared. Network access to the endpoint is needed.
Before you install
The Authorization header carries an Apify API token, so treat it as a secret and avoid exposing it. Runs are billed per event to your Apify account, so usage can cost money. Inputs may include files, Google Sheets, or JSON that are sent to a third-party service.

Installation

In SourceWeft

  1. Open Dataset Aggregate, Group By & Pivot in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "dataset-aggregate-pivot-full": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot"
    }
  }
}

Tools

0
Tool metadata has not been indexed yet.

Version history

1
  1. v0.1.0LatestOct 1, 2026