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

Est-ce que io.github.Nero-Engine/dataset-aggregate-pivot est sûr ?

Au dernier audit MCP Hub, le serveur MCP « io.github.Nero-Engine/dataset-aggregate-pivot » est classé « Non encore testé ». Référencé dans l'annuaire. Seul le pentest comportemental fait foi, et il n'a pas encore été exécuté sur ce serveur. Le verdict est réévalué en continu ; consultez la fiche pour l'état à jour.

Méthode : MCP Hub analyse la description de chaque outil (couche 1) et, pour le verdict fort, exécute le serveur dans une micro-VM isolée avec leurres et réseau bloqué (couche 2). On publie des noms et des compteurs, jamais le contenu brut renvoyé par un outil.

Les 2 outils

• aggregate_rows≈ 1105 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.

  Paramètres, retour & exemple (14)

  Paramètres

  • rows · array · requis
    The records to aggregate, up to 500. Each row is a JSON object; keys may differ between rows.
  • topN · integer · optionnel
    After sorting, keep only the first N groups. The totals row still covers every input row.
  • sortBy · string · optionnel
    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.
  • pivotField · string · optionnel
    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 most 50 distinct values.
  • aggregations · array · optionnel
    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 output column name (defaults to function_field, or "count"). Omitted gives a plain row count per group. Up to 20.
  • groupByFields · array · optionnel
    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 row into a single row.
  • groupMatching · string · optionnel · normalized | exact
    normalized (default) ignores letter case and extra whitespace when grouping, so "South" and "south " are one group. exact requires identical values.
  • pivotFunction · string · optionnel · count | countDistinct | sum | avg | min | max | median | first
    How pivot cell values are combined. Defaults to sum when pivotValueField is set; ignored (row count) without one.
  • sortDirection · string · optionnel · asc | desc
    asc (default) or desc. Use desc with topN for "top N by" questions.
  • lenientNumbers · boolean · optionnel
    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.
  • dateBucketField · string · optionnel
    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.
  • pivotValueField · string · optionnel
    The field whose values fill the pivot cells, for example "amount". Omitted fills each cell with a row count.
  • includeTotalsRow · boolean · optionnel
    Appends a grand-total row labelled "(total)" and adds a _rowType column ("group" or "total").
  • dateBucketGranularity · string · optionnel · day | week | month | quarter | year
    Bucket size for dateBucketField: day (2026-08-19), week (2026-W34), month (2026-08, default), quarter (2026-Q3) or year.

  Exemple d'appel

  {"name": "aggregate_rows", "arguments": {"rows": []}}

  Exemple de retour

  {"content": [{"type": "text", "text": "…"}]}

• list_capabilities≈ 106 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.

  Paramètres, retour & exemple (0)

  Exemple d'appel

  {"name": "list_capabilities", "arguments": {}}

  Exemple de retour

  {"content": [{"type": "text", "text": "…"}]}

C'est votre serveur ?

Revendiquez-le sur l'espace créateur (preuve GitHub, domaine ou npm) pour afficher le badge « propriétaire vérifié » et lancer un pentest comportemental à la demande afin d'obtenir le badge « Vérifié ».

Créer un compte / revendiquer →

Source

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