MCP server

Dataset Aggregate, Group By & Pivot

io.github.Nero-Engine/dataset-aggregate-pivot-full

Checked 26 Oct 2026, 08:29 UTC · It answered and asked for a sign-in

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

Website

At a glance

Type

MCP server

Publisher

Not verified

Status

Needs an API key

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code, Antigravity, ChatGPT, OpenAI API, Grok

Last checked

26 Oct 2026, 08:29 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. For other apps, copy the setup below.

Claude Code

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, and paste the URL.

Codex (config.toml)

[mcp_servers.dataset-aggregate-pivot-full]
url = "https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot"

Gemini CLI

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

Cursor

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

VS Code

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

Antigravity

agy mcp add dataset-aggregate-pivot-full https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot

ChatGPT

Settings → Apps & Connectors → Advanced settings: turn on Developer mode, then Create a connector and paste the URL. Which plans can do this varies.

OpenAI API (Responses tools)

{"type":"mcp","server_label":"dataset-aggregate-pivot-full","server_url":"https://mcp.apify.com/?tools=nerolabs/dataset-aggregate-pivot","require_approval":"always"}

Grok (xAI API tools)

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

Needs an API key or token from its maker, usually added as a header in the setup.

Browse

• GitHub tools
• Apify tools
• GitHub and code hosting

Related MCP servers

• Dataset Aggregate & Pivot
  GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
• AgentNative: Public Data, Government Datasets, Federal Statistics & Official Records
  Normalized official data with provenance, aggregations, insights, free samples and agent access.
• Mostly Right
  Search, sample and query open reproducible datasets published as immutable Parquet with schemas.
• Datos Co
  datos.gov.co — Colombia's national open-data portal (Socrata platform).
• Agentic Dealer Network
  Live franchised-dealer inventory, quotes, and consented salesperson handoffs.
• Bts
  U.S. Bureau of Transportation Statistics (BTS) — data.bts.gov open-data portal (Socrata platform).
• ZeroWidth Napkin
  Draw boards, write docs and sheets, and build decks with your brand in Napkin.
• Nova Scotia Data Explorer
  Query and explore Nova Scotia open datasets via the Socrata SODA API.

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.Nero-Engine/dataset-aggregate-pivot-full.svg)](https://aptlynx.net/servers/io.github.Nero-Engine/dataset-aggregate-pivot-full)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents