# Dataset Aggregate & Pivot (remote · dataset-aggregate-pivot.nerolabs.workers.dev)

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

- Trust score: 59/100 (low)
- Change this week: +4
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-20

## Components

- remote · `dataset-aggregate-pivot.nerolabs.workers.dev`: 59/100 (this document), [markdown](https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot.md), [page](https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot)

## Channel facts

- Endpoint: `https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp`
- Transports: `streamable-http`
- Auth: `none`
- Version: `0.1.0`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically against the live server, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-09-20.

- **Endpoint Security**: 46/100
  - The endpoint's TLS certificate is valid, in date, and uses a strong key.
  - Authorisation not fully verified: no authorisation is required to call this server, and 2 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe.
  - HTTPS enforcement could not be verified: the plaintext port answered with HTTP 405, which proves neither a plaintext path nor enforcement.
  - HSTS check failed: the Strict-Transport-Security header is absent.
  - DNSSEC check failed: this domain isn't protected by DNSSEC.
- **Transport & Reachability**: 100/100
  - Verified streamable-http transport via a live MCP handshake.
- **Schema Quality & AI Usability**: 59/100
  - AI-judged instruction clarity (excellent).
  - Context-footprint check failed: tool/resource definitions use about 886 tokens (~443/item across 2 items; 2 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 23/100
  - Stability observed for 7 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Tool Safety**: 100/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - We read all 2 captured tool definition(s), and no name or description among them implies an irreversible operation.
  - An AI judge read all 3 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 60/100
  - Spec-recency check failed: implements MCP spec 2025-06-18; the latest is 2026-07-28.

## Install

### How do I install the Dataset Aggregate & Pivot MCP server?

Dataset Aggregate & Pivot is a hosted endpoint at https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp, so there is nothing to install locally. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add --transport http nero-engine-dataset-aggregate-pivot 'https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp'
```

### Cursor

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

### VS Code

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

### Codex

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

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "nero-engine-dataset-aggregate-pivot": {
      "type": "remote",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp",
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add nero-engine-dataset-aggregate-pivot --url 'https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp' --transport streamable-http
```

### Hermes

```yaml
mcp_servers:
  nero-engine-dataset-aggregate-pivot:
    url: "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
```

### Netclaw

```json
{
  "McpServers": {
    "nero-engine-dataset-aggregate-pivot": {
      "Transport": "http",
      "Url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}
```

### Vellum

```bash
assistant mcp add nero-engine-dataset-aggregate-pivot -t streamable-http -u 'https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp'
```

### Other

```json
{
  "mcpServers": {
    "nero-engine-dataset-aggregate-pivot": {
      "type": "http",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}
```

The mcpServers block is a cross-client convention. Remote transports vary, so check your client's docs.

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-09-20 (score 59, +1)

No change was recorded against any check on this day. Stability & Change Management went from 20 to 23. That category is still filling its 30-day observation window: 6 days of observed history at the previous scan, 7 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-18 (score 58, +1)

No change was recorded against any check on this day. Stability & Change Management went from 13 to 17. That category is still filling its 30-day observation window: 4 days of observed history at the previous scan, 5 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-16 (score 57, +1)

No change was recorded against any check on this day. Stability & Change Management went from 7 to 10. That category is still filling its 30-day observation window: 2 days of observed history at the previous scan, 3 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-14 (score 56, +1)

- [functional improvement] Stability: unverified → 0.03

### 2026-09-13 (score 55)

First indexed and scored.

## MCP tools (2)

### `list_capabilities` (~72 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.

### `aggregate_rows` (~767 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 misspelled field name. Use it to turn scraped or API records into totals: orders and revenue per region, average price per brand, listings per city per month, top 10 products by revenue. Messy data is expected: "South" and "south " group together, and "$1,234.50" sums as 1234.5. Leave groupByFields empty to summarise all rows into one row. At most 500 rows per call.

Input parameters:

- `aggregations` (array): What to compute per group, for example [{"function":"count","alias":"orders"}, {"field":"amount","function":"sum","alias":"total_amount"}]. Every function except count needs a field. alias is the out…
- `dateBucketField` (string): A date or timestamp field to group by time period, for example "orderedAt". Adds a group column named like "orderedAt_month". Unreadable dates land in an "(invalid date)" group.
- `dateBucketGranularity` (string): Bucket size for dateBucketField: day (2026-08-19), week (2026-W34), month (2026-08, default), quarter (2026-Q3) or year.
- `groupByFields` (array): One output row per distinct combination of these field values, like SQL GROUP BY, for example ["region"] or ["city", "category"]. Dot paths like "address.city" work. Empty or omitted aggregates every…
- `groupMatching` (string): normalized (default) ignores letter case and extra whitespace when grouping, so "South" and "south " are one group. exact requires identical values.
- `includeTotalsRow` (boolean): Appends a grand-total row labelled "(total)" and adds a _rowType column ("group" or "total").
- `lenientNumbers` (boolean): On by default: "$1,234.50", "49 USD", "12%" and "(300)" count as numbers for sum, avg, min, max and median. Set false to accept only real numbers and plain numeric strings.
- `pivotField` (string): Turns this field's distinct values into columns, pivot-table style: group by "region" and pivot on "product" for one row per region with a column per product. Must not also be a group-by field. At mo…
- `pivotFunction` (string): How pivot cell values are combined. Defaults to sum when pivotValueField is set; ignored (row count) without one.
- `pivotValueField` (string): The field whose values fill the pivot cells, for example "amount". Omitted fills each cell with a row count.
- `rows` (array, required): The records to aggregate, up to 500. Each row is a JSON object; keys may differ between rows.
- `sortBy` (string): An output column to sort by: a group field, an aggregation alias such as "total_amount", or a pivot column. Omitted sorts by the group fields.
- `sortDirection` (string): asc (default) or desc. Use desc with topN for "top N by" questions.
- `topN` (integer): After sorting, keep only the first N groups. The totals row still covers every input row.

## Diagnostics

Captured diagnostic sections: TLS, DNSSEC, Authorisation, Transports. The full working is on the page: https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot#diagnostics

## Score history

- 2026-09-20: 59
- 2026-09-19: 58
- 2026-09-18: 58
- 2026-09-17: 57
- 2026-09-16: 57
- 2026-09-15: 56
- 2026-09-14: 56
- 2026-09-13: 55

## Common questions

### What is the Dataset Aggregate & Pivot MCP server?

Dataset Aggregate & Pivot is an MCP server listed in the public MCP registry as io.github.Nero-Engine/dataset-aggregate-pivot. GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers. This page covers its hosted endpoint (https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp).

### Is the Dataset Aggregate & Pivot MCP server safe to use?

Dataset Aggregate & Pivot scores 59 out of 100 on VerifyMCP. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.

### What tools does the Dataset Aggregate & Pivot MCP server expose?

Dataset Aggregate & Pivot exposes 2 tools: list_capabilities, aggregate_rows. Their descriptions and schemas cost roughly 839 tokens of context every time the server is loaded.

### Does the Dataset Aggregate & Pivot MCP server require authentication?

No. We connected to Dataset Aggregate & Pivot without credentials and it answered, so anything it exposes is reachable by anyone who knows the address.

### Is the Dataset Aggregate & Pivot MCP server still maintained?

Dataset Aggregate & Pivot is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.

## Links

- Remote endpoint: https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
- Repository: https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp
- Changelog RSS feed: https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot.xml
- Changelog JSON feed: https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot.json
- HTML version of this page: https://verifymcp.io/servers/nero-engine-dataset-aggregate-pivot/dataset-aggregate-pivot