# Dataset Aggregate, Group By & Pivot

> Dataset Aggregate, Group By & Pivot is an MCP server. Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON... It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Website:** https://apify.com/nerolabs/dataset-aggregate-pivot
- **MCP Registry name:** io.github.Nero-Engine/dataset-aggregate-pivot-full
- **Listing updated:** 2026-11-13

## About

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http dataset-aggregate-pivot-full 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot'
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot
```

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "dataset-aggregate-pivot-full": {
      "serverUrl": "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

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

## FAQ

### How do I add Dataset Aggregate, Group By & Pivot to Claude Code?

Run this command in your terminal: claude mcp add --transport http dataset-aggregate-pivot-full 'https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot'

## Where this comes from

- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.

---
Source: https://ai-powered.com/mcp/dataset-aggregate-group-by-and-pivot
