MCP server

Dataset Aggregate & Pivot

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

Checked 26 Oct 2026, 08:29 UTC · Connected to it and listed its tools

GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.

Website Source

At a glance

Type

MCP server

Publisher

Not verified

Status

Working at last check

Tools

2

Token cost

About 1,342 tokens per request

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 https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Claude Desktop

Settings → Connectors → Add custom connector, and paste the URL.

Codex (config.toml)

[mcp_servers.dataset-aggregate-pivot]
url = "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"

Gemini CLI

{"mcpServers":{"dataset-aggregate-pivot":{"httpUrl":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}}

Cursor

{"mcpServers":{"dataset-aggregate-pivot":{"url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}}

VS Code

{"servers":{"dataset-aggregate-pivot":{"type":"http","url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}}}

Antigravity

agy mcp add dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

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","server_url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp","require_approval":"always"}

Grok (xAI API tools)

{"type":"mcp","server_label":"dataset-aggregate-pivot","server_url":"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"}

Tools

• aggregate_rows ~1223 tokens
  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 columns, plus a summary: groups found, groups dropped by topN, values skipped because they were blank or not numeric (never guessed), and warnings such as a misspelle
• list_capabilities ~119 tokens
  Returns the 11 aggregation functions and what each one does, the date bucket formats, the labels used for blank, invalid-date and total rows, and the limits per call (rows, pivot columns, pivot cells, aggregations). Call this first if you are unsure what is available. Free, processes no data.

Browse

• GitHub tools
• Spreadsheets
• GitHub and code hosting
• Databases

Related MCP servers

• Mostly Right
  Search, sample and query open reproducible datasets published as immutable Parquet with schemas.
• Eurostat
  Search and query the Eurostat catalogue — EU economy, demography, trade, and NUTS regional data.
• Oecd
  Search and query 1,500+ OECD statistical datasets via SDMX. Keyless.
• Nova Scotia Data Explorer
  Query and explore Nova Scotia open datasets via the Socrata SODA API.
• Openfda
  Query FDA data on drugs, food, devices, and recalls via openFDA. STDIO or Streamable HTTP.
• Method CRM MCP by usefulapi
  Query Method CRM customers, leads, activities and invoices; create and update records.
• Citiview Agent Market
  186 pay-per-call tools: search, LLMs, UK KYB, FRED, Census, maps, crypto. x402 USDC.
• Istanbul MCP
  Read-only Istanbul open city data: transport, parking, water, nearby services and datasets.

Badge for your README

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

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