Community · Official remote MCP server

The Dataset Aggregate & Pivot MCP server,
connected in one click.

GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers. Connect the official Dataset Aggregate & Pivot MCP server to Claude, ChatGPT, or Cursor through gate — one gateway URL, no config files, security-checked.

Connect Dataset Aggregate & Pivot free How it works

Free to start · No credit card · No hosting needed

Use this server

Add Dataset Aggregate & Pivot to your AI in one minute

Pick your client. Copy, paste, done — or let gate handle sign-ins and policies for you.

claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Run in your terminal, then restart Claude Code.

Dataset Aggregate & Pivot · https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

What you can do

What your AI can do with Dataset Aggregate & Pivot

Real prompts you can type the moment it's connected — no setup, no docs to read.

“Use “list_capabilities”: Returns the 11 aggregation functions and what each one does, the date bucket formats, the labels used for blank, invalid-date and total rows.”

“Use “aggregate_rows”: SQL GROUP BY and a spreadsheet pivot table for a list of JSON rows, in one call. Returns one output row per group with the aggregated column.”

Security check

How secure is the Dataset Aggregate & Pivot MCP server?

Every server in the gate directory has to pass the same four checks before your AI can touch it. Here's how Dataset Aggregate & Pivot holds up.

A97/100

Security grade A

gate scanned 2 tools on Sep 14, 2026 for prompt injection and risky tool definitions — nothing to flag.

lowaggregate_rows: Unusually long tool description

Full report Badge for your README

✓ Verified directory serverDataset Aggregate & Pivot · github.com

Official endpoint

Operated by Dataset Aggregate & Pivot (github.com) at its documented MCP endpoint — not a third-party mirror or community re-host.

No sign-in needed

This server only exposes public data — no account and no credentials are involved when you connect.

Scanned before it goes live

gate checks every tool for prompt injection, hidden instructions, data-exfiltration hints, and over-broad permissions before the server is available through your gateway.

Watched for drift

If Dataset Aggregate & Pivot adds or changes tools later, gate re-scans and alerts you — before your AI acts on the change.

Run the free scanner on Dataset Aggregate & Pivot's server →

How it works

Connected in three steps

Connect your gate

Add one gateway URL to Claude, ChatGPT, or any MCP client. One-time setup, about two minutes.

Pick Dataset Aggregate & Pivot

Choose Dataset Aggregate & Pivot in the gate directory. No sign-in needed.

Use it anywhere

Dataset Aggregate & Pivot's tools are live in every AI client you've connected — with rules and logging built in.

Connect Dataset Aggregate & Pivot free

Free to start · No credit card · No hosting needed

Straight from the server

The actual tools Dataset Aggregate & Pivot exposes

Fetched live from the official endpoint and re-checked daily by gate — not marketing copy.

list_capabilities — Returns the 11 aggregation functions and what each one does, the date bucket formats, the labels used for blank, invalid-date and total rows

aggregate_rows — SQL GROUP BY and a spreadsheet pivot table for a list of JSON rows, in one call. Returns one output row per group with the aggregated column

Author

Who runs the Dataset Aggregate & Pivot MCP server?

github.com

Homepage More servers from github.com →

Own this server? Claim the listing →

Server facts

The Dataset Aggregate & Pivot MCP server at a glance

Endpointhttps://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Operated byDataset Aggregate & Pivot (github.com)

CategoryCommunity

Sign-inNone — public data only

Available in gateYes — one-click connect

Works withClaude, ChatGPT, Cursor & any MCP client

FAQ

Questions, answered

Is there an official Dataset Aggregate & Pivot MCP server?

Yes — Dataset Aggregate & Pivot operates its own remote MCP server at dataset-aggregate-pivot.nerolabs.workers.dev. gate connects you to that official endpoint and adds security scanning, per-tool access rules, and an activity log on top.

How do I connect Dataset Aggregate & Pivot to Claude or ChatGPT?

Add gate's gateway URL to your AI client once, then pick Dataset Aggregate & Pivot in the directory. No account or sign-in is needed. From then on, Dataset Aggregate & Pivot's tools are available in every client you've connected to gate.

Do I need to host anything?

No. Dataset Aggregate & Pivot runs the server, and gate is fully managed. You just connect one URL — there's nothing to install, deploy, or maintain.

Is the Dataset Aggregate & Pivot MCP server safe to connect?

It's the vendor's official endpoint, and gate scans its tools for prompt injection and hidden instructions before it goes live, re-checks it whenever it changes, and lets you allow, block, or require approval for every single tool.