protogrid

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

Dataset Aggregate & Pivot

R0· no sign-in

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

v0.1.0 · active · repository · website · descriptor JSON · versions

An agent can connect right now, no human step.Remote endpoint, no authentication, reachable on the last probe.
Quality79good
Trust93of 100
Uptime, 30 days96%
Latency p50133 ms

Connect

8 clients · secrets stay placeholders
{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "type": "http",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}
claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp
[mcp_servers.dataset-aggregate-pivot]
url = "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "dataset-aggregate-pivot": {
      "type": "remote",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp",
      "enabled": true
    }
  }
}
{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "type": "http",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=dataset-aggregate-pivot&config=eyJ0eXBlIjoiaHR0cCIsInVybCI6Imh0dHBzOi8vZGF0YXNldC1hZ2dyZWdhdGUtcGl2b3QubmVyb2xhYnMud29ya2Vycy5kZXYvbWNwIn0%3D"
}
{
  "servers": {
    "dataset-aggregate-pivot": {
      "type": "http",
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}
{
  "mcpServers": {
    "dataset-aggregate-pivot": {
      "httpUrl": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    }
  }
}
extensions:
  "dataset-aggregate-pivot":
    enabled: true
    name: "dataset-aggregate-pivot"
    type: streamable_http
    uri: "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
    timeout: 300

Quality 79 / 100good

protocol75 · weight 25
  • warn
    protocol.modernnewest supported version is 2025-06-18; 2026-07-28 not supported, older versions are deprecated until 2027-07-28
  • n/a
    protocol.statelessonly applies to 2026-07-28 servers
  • pass
    protocol.transportstreamable HTTP
  • n/a
    protocol.list_ttlonly applies to 2026-07-28 servers
authorizationn/a · weight 15
  • n/a
    auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
  • n/a
    auth.secret_in_urlno templated URL
tool hygiene71 · weight 30
  • pass
    tools.descriptionsevery tool has a description
  • pass
    tools.description_lengthdescriptions are concise
  • pass
    tools.schemasevery tool has an object input schema
  • fail
    tools.annotationsno tool declares readOnlyHint or destructiveHint, so clients cannot tell safe calls from risky ones
  • fail
    tools.directory_hintsno tool declares all four of readOnlyHint, destructiveHint, idempotentHint and openWorldHint; missing: list_capabilities (readOnlyHint, destructiveHint, idempotentHint, openWorldHint); aggregate_rows (readOnlyHint, destructiveHint, idempotentHint, openWorldHint)
  • pass
    tools.token_costabout 1,152 tokens to load every tool
  • pass
    tools.api_dumptools are not a one-to-one API dump
stability100 · weight 15
  • pass
    stability.changesno tool changes in 30 days
  • pass
    stability.rug_pullno tool changed its meaning under the same name
dependenciesn/a · weight 15
  • n/a
    deps.known_vulns, deps.mcp_sdk_version, deps.resolvableno npm or PyPI package

2 tools, about 1,152 tokens to load them all · tool set 1cb61bf4ba21 · checked 2026-10-20 14:54 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 93 / 100

provenance90
liveness98
freshness85
hygiene100

+repository +namespace-matches-repo +website +reachable +uptime-96% ~updated-38d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Endpoints

remoteauthreachableuptime 30dp50protocollast ok
https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp streamable-httpnoneyes96%133 ms2025-06-182026-10-20

Tools (2)

aggregate_rowsSQL 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.
list_capabilitiesReturns 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.

Schemas: list_tools.

Similar MCP servers

More from io.github.Nero-Engine

And 50 more from this publisher.

Official server.json
{
  "name": "io.github.Nero-Engine/dataset-aggregate-pivot",
  "title": "Dataset Aggregate & Pivot",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "remotes": [
    {
      "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp",
      "type": "streamable-http"
    }
  ],
  "version": "0.1.0",
  "repository": {
    "url": "https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp",
    "source": "github"
  },
  "websiteUrl": "https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp",
  "description": "GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers."
}