Dataset Aggregate, Group By & Pivot

io.github.Nero-EnginePublished by GitHub account Nero-Enginev0.1.0Updated Oct 24, 2026

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

The publisher's own server: Aggregate

VerifiedStreamable HTTPWeb executableData & Analytics

Overview

AI-generated overview

An Apify-hosted MCP server that returns GROUP BY and pivot tables for Apify datasets, files, Google Sheets or JSON data.

What you can do
Build GROUP BY aggregations over a dataset, file, Google Sheet URL or JSON input, returning summarized tables rather than raw rows. Produce pivot tables from the same sources for cross-tabulated views. Point it at an Apify dataset by its identifier or at an external source by URL.
When to use it
Useful when an assistant needs summarized or cross-tabulated views of Apify dataset output or of tabular data held in files, Google Sheets or JSON, instead of reading every row.
Requirements
A remote streamable HTTP endpoint at mcp.apify.com with OAuth authentication. An Apify API token is supplied in the Authorization header as a Bearer token. An Apify account is needed, and runs are billed to that account.
Before you install
The Authorization header carries an Apify API token, so treat it as a secret. Runs are billed per event to your Apify account, so repeated or large aggregations cost money. Data from the supplied dataset, file, Google Sheet or JSON is sent to Apify for processing.

Installation

In SourceWeft

  1. Open Dataset Aggregate, Group By & Pivot in the dashboard and add it to a workspace.
  2. Connect the required credentials. They are stored privately and never shown on public pages.
  3. 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.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.github.Nero-Engine%2Fdataset-aggregate-pivot-full/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config. The client completes OAuth sign-in on first connect.

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

Tools

0
This server asks you to sign in, so SourceWeft could not read its tools without an account and has not indexed them. What a connected account sees can depend on that account and its permissions.

Version history

1
  1. v0.1.0LatestOct 1, 2026

Score

67% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts

    Declare a GitHub repository with a README, or serve resource_documentation in the OAuth protected-resource metadata.

  • LicenseNot applicable

    A hosted service is used under its provider's terms, so no license is expected here. This check is left out of the percentage.

Other Aggregate integrations

Aggregate

finance.aggregateOfficial publisher

Aggregate is a read-only finance MCP server that lets an assistant query your banks, cards, payments, books and payroll in one double-entry ledger.

Streamable HTTPWeb executableAuth
FinanceCredential requiredNov 3, 2026

Dataset Aggregate & Pivot

Published by GitHub account Nero-Engine

A remote MCP server that groups, aggregates and pivots JSON rows like SQL GROUP BY or a spreadsheet pivot table, returning one summary row per group.

Streamable HTTPWeb executable
Databases2 toolsOct 24, 2026