Dataset Aggregate & Pivot

Connect Remote server

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

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

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

Settings > Connectors > Add custom connector
URL: https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp

Tools 2 found in our last check

• 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, and the limits per call (rows, pivot columns, pivot cells, aggregations). Call this first if you are unsure what is available. Free, proc…

• 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 columns, plus a summary: groups found, groups dropped by topN, values skipped because they were blank or not numeric (never guessed), and warning…

Details

More data and analytics servers See all

• topo^alpin

  Avalanche bulletins, mountain weather, stations, huts, ski and snowshoe tours in the Alps.

• MedBillAnalyzer

  Compares a medical bill with the insurer's Explanation of Benefits and lists where they disagree.

• Brush Pack

  Paint and wallpaper amounts, weather checks and lead paint safety for UK decorators' AI

• Ridge Pack

  Roof take-offs, weather windows, building regs and storm triage for UK roofers' AI assistants

• Agent Data Tools: Everyday data

  29 tools: weather, time zones, sun and moon, earthquakes, countries. 25 free calls.

• Agent Data Tools: Utilities

  105 tools: JSON repair, CSV, hashes, cron, dates, units, validators. 25 free calls.