{
  "notice": "bxzxxr MCP archive: a record of what public MCP servers declared when we listed them (we never call their tools). It is data, not a rating: nothing here says a server is safe, secure, verified or trustworthy, and a server can change after we looked. Secrets we detected are redacted; redacted tool lists are withheld and only their hash is shown.",
  "infrastructure": {
    "host": "dataset-aggregate-pivot.nerolabs.workers.dev",
    "site": "dataset-aggregate-pivot.nerolabs.workers.dev",
    "addresses": [
      {
        "address": "104.21.58.207",
        "endpoints": 21,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "104.21.48.0/20",
          "country": "US"
        }
      },
      {
        "address": "172.67.164.170",
        "endpoints": 21,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "172.67.160.0/20",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3036::ac43:a4aa",
        "endpoints": 21,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3036::/48",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3030::6815:3acf",
        "endpoints": 21,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3030::/48",
          "country": "US"
        }
      }
    ],
    "addresses_recorded": true,
    "address_history": [
      {
        "addresses": [
          "104.21.58.207",
          "172.67.164.170",
          "2606:4700:3036::ac43:a4aa",
          "2606:4700:3030::6815:3acf"
        ],
        "first_seen": "2026-11-21T20:00:10.607Z",
        "last_seen": "2026-11-21T20:00:10.607Z",
        "checks": 1
      }
    ],
    "hosting": [
      {
        "value": "Cloudflare Workers",
        "evidence": "host name ends in .workers.dev"
      }
    ],
    "software": [],
    "server_info": {
      "name": "nerolabs-dataset-aggregate-pivot",
      "version": "0.1.0",
      "protocol_version": "2025-06-18"
    },
    "headers": {
      "server": "cloudflare",
      "access-control-allow-origin": "*"
    },
    "auth": null
  },
  "related": {
    "same_address": {
      "total": 20,
      "sample": [
        {
          "id": "25833",
          "url": "https://breach-notification-deadlines.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/breach-notification-deadlines",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T19:58:00.752Z"
        },
        {
          "id": "25835",
          "url": "https://brush-pack.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/brush-pack",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T19:59:00.805Z"
        },
        {
          "id": "25853",
          "url": "https://dataset-cleaner-exporter.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/dataset-cleaner-exporter",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:01:00.749Z"
        },
        {
          "id": "25855",
          "url": "https://dataset-diff-detector.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/dataset-diff-detector",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:02:02.250Z"
        },
        {
          "id": "25857",
          "url": "https://dataset-filter-transform.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/dataset-filter-transform",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:03:00.974Z"
        },
        {
          "id": "25859",
          "url": "https://dataset-join-merge.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/dataset-join-merge",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:04:00.307Z"
        },
        {
          "id": "25872",
          "url": "https://flow-pack.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/flow-pack",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:05:01.619Z"
        },
        {
          "id": "25881",
          "url": "https://listing-location-toolkit.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/listing-location-toolkit",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:06:00.768Z"
        },
        {
          "id": "25884",
          "url": "https://nero-reviews.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/nero-reviews",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:07:01.005Z"
        },
        {
          "id": "25888",
          "url": "https://pay-transparency-rules.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/pay-transparency-rules",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:09:00.520Z"
        },
        {
          "id": "25894",
          "url": "https://quote-builder.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/quote-builder",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:10:00.590Z"
        },
        {
          "id": "25897",
          "url": "https://ridge-pack.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/ridge-pack",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:11:00.804Z"
        },
        {
          "id": "25901",
          "url": "https://site-pack.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/site-pack",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:12:02.577Z"
        },
        {
          "id": "25902",
          "url": "https://spark-pack.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/spark-pack",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:13:00.746Z"
        },
        {
          "id": "25903",
          "url": "https://supplier-invoice-tool.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/supplier-invoice-tool",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:14:00.470Z"
        },
        {
          "id": "25909",
          "url": "https://subcontractor-check.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/uk-subcontractor-right-to-work",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:15:00.486Z"
        },
        {
          "id": "25910",
          "url": "https://tourist-tax.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/uk-tourist-tax",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:16:01.189Z"
        },
        {
          "id": "25914",
          "url": "https://us-minimum-wage.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/us-minimum-wage",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:17:00.455Z"
        },
        {
          "id": "25916",
          "url": "https://us-sales-tax-nexus.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/us-sales-tax-nexus",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T20:18:00.605Z"
        },
        {
          "id": "25885",
          "url": "https://nero-work.nerolabs.workers.dev/mcp",
          "server_name": "io.github.Nero-Engine/nero-work",
          "last_state": "auth_required",
          "last_checked_at": "2026-11-21T20:08:00.326Z"
        }
      ]
    },
    "same_site": {
      "total": 0,
      "sample": []
    },
    "same_tool_list": {
      "total": 0,
      "sample": []
    },
    "same_publisher": {
      "publisher": "io.github.Nero-Engine",
      "total": 97,
      "sample": [
        {
          "name": "io.github.Nero-Engine/actor-pipeline-runner",
          "title": "Actor Pipeline Runner (Chain Actors in One Run)"
        },
        {
          "name": "io.github.Nero-Engine/adobe-stock-keyword-generator",
          "title": "Adobe Stock Keyword Generator"
        },
        {
          "name": "io.github.Nero-Engine/ai-crawler-access-checker",
          "title": "AI Crawler Access Checker"
        },
        {
          "name": "io.github.Nero-Engine/ai-shopping-results-tracker",
          "title": "AI Shopping Results Tracker"
        },
        {
          "name": "io.github.Nero-Engine/amazon-buybox-monitor",
          "title": "Amazon Buy Box & Price Monitor: Seller, Stock & Price Tracker"
        },
        {
          "name": "io.github.Nero-Engine/au-visa-processing-monitor",
          "title": "Australia Visa Processing Time Monitor"
        },
        {
          "name": "io.github.Nero-Engine/best-time-to-post",
          "title": "Best Time to Post: Instagram, TikTok & YouTube"
        },
        {
          "name": "io.github.Nero-Engine/breach-notification-deadlines",
          "title": "Data Breach Notification Deadlines"
        },
        {
          "name": "io.github.Nero-Engine/breach-notification-deadlines-full",
          "title": "Data Breach Notification Deadlines (bulk, Apify)"
        },
        {
          "name": "io.github.Nero-Engine/brush-pack",
          "title": "Brush Pack"
        },
        {
          "name": "io.github.Nero-Engine/building-permit-leads",
          "title": "New Building Permit Leads"
        },
        {
          "name": "io.github.Nero-Engine/bulk-article-extractor",
          "title": "Bulk Article Extractor"
        },
        {
          "name": "io.github.Nero-Engine/bulk-file-downloader",
          "title": "Bulk Image & File Downloader from CSV, Google Sheet or Dataset"
        },
        {
          "name": "io.github.Nero-Engine/bulk-image-converter",
          "title": "Image Converter & Compressor"
        },
        {
          "name": "io.github.Nero-Engine/bulk-image-upscaler",
          "title": "Bulk AI Image Upscaler from CSV, Google Sheet or Dataset"
        },
        {
          "name": "io.github.Nero-Engine/bulk-ocr-image-pdf-to-text",
          "title": "Bulk OCR: Image & Scanned PDF to Text from CSV or Google Sheet"
        },
        {
          "name": "io.github.Nero-Engine/bulk-pagespeed-checker",
          "title": "Bulk PageSpeed & Lighthouse Checker: Core Web Vitals from CSV"
        },
        {
          "name": "io.github.Nero-Engine/bulk-seo-audit",
          "title": "Bulk SEO Audit"
        },
        {
          "name": "io.github.Nero-Engine/bulk-transcription",
          "title": "Bulk Transcription: Audio & Video to Text from CSV or Sheet"
        },
        {
          "name": "io.github.Nero-Engine/bulk-website-screenshots",
          "title": "Website Screenshot Tool (Bulk)"
        }
      ]
    },
    "same_repository": {
      "repository_url": "https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp",
      "total": 0,
      "sample": []
    },
    "note": "Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators."
  },
  "endpoint": {
    "id": "25849",
    "server_name": "io.github.Nero-Engine/dataset-aggregate-pivot",
    "url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp",
    "host": "dataset-aggregate-pivot.nerolabs.workers.dev",
    "transport": "streamable-http",
    "last_checked_at": "2026-11-21T20:00:10.607Z",
    "last_state": "listed",
    "last_detail": null,
    "consecutive_failures": 0,
    "current_sha": "4011eaebd00c2844f32988469e87fd56b23aa20565609ca3ea8c2046dec3b025",
    "first_listed_at": "2026-11-21T20:00:10.607Z",
    "created_at": "2026-11-21T08:45:02.122Z",
    "resolved_addresses": [
      "104.21.58.207",
      "172.67.164.170",
      "2606:4700:3036::ac43:a4aa",
      "2606:4700:3030::6815:3acf"
    ]
  },
  "server": {
    "name": "io.github.Nero-Engine/dataset-aggregate-pivot",
    "title": "Dataset Aggregate & Pivot",
    "description": "GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.",
    "version": "0.1.0",
    "registry_status": "active",
    "repository_url": "https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp",
    "website_url": "https://github.com/Nero-Engine/dataset-aggregate-pivot-mcp",
    "published_at": "2026-09-13T00:07:44.261Z",
    "updated_at": "2026-09-13T00:07:44.261Z",
    "first_seen": "2026-11-21T08:45:01.284Z"
  },
  "other_endpoints": [],
  "intel": {
    "capabilities": [],
    "evm_addresses": [],
    "chains": [],
    "tokens": [],
    "computed_at": "2026-11-22T16:06:16.624Z"
  },
  "operator": {
    "key": "agentexchange.work",
    "name": "x402 Gateway",
    "platform": false
  },
  "needs_sign_in": false,
  "reachability": {
    "window_days": 30,
    "checks": 1,
    "answered": 1,
    "answered_percent": 100,
    "avg_listing_latency_ms": 257,
    "first_check_in_window": "2026-11-21T20:00:10.607Z",
    "consecutive_failures_now": 0,
    "days": [
      {
        "day": "2026-11-21",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      }
    ]
  },
  "tool_list": {
    "sha256": "4011eaebd00c2844f32988469e87fd56b23aa20565609ca3ea8c2046dec3b025",
    "tools": 2,
    "resources": 0,
    "prompts": 0,
    "first_seen": "2026-11-21T20:00:10.989Z",
    "tool_names": [
      "list_capabilities",
      "aggregate_rows"
    ],
    "declared": {
      "tools": [
        {
          "name": "list_capabilities",
          "description": "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.",
          "inputSchema": {
            "type": "object",
            "properties": {},
            "additionalProperties": false
          }
        },
        {
          "name": "aggregate_rows",
          "description": "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.",
          "inputSchema": {
            "type": "object",
            "required": [
              "rows"
            ],
            "properties": {
              "rows": {
                "type": "array",
                "items": {
                  "type": "object"
                },
                "description": "The records to aggregate, up to 500. Each row is a JSON object; keys may differ between rows."
              },
              "topN": {
                "type": "integer",
                "minimum": 1,
                "description": "After sorting, keep only the first N groups. The totals row still covers every input row."
              },
              "sortBy": {
                "type": "string",
                "description": "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": {
                "type": "string",
                "description": "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": {
                "type": "array",
                "items": {
                  "type": "object",
                  "required": [
                    "function"
                  ],
                  "properties": {
                    "alias": {
                      "type": "string",
                      "description": "Output column name."
                    },
                    "field": {
                      "type": "string",
                      "description": "The field to aggregate. Optional for count, which then counts rows."
                    },
                    "function": {
                      "enum": [
                        "count",
                        "countDistinct",
                        "sum",
                        "avg",
                        "min",
                        "max",
                        "median",
                        "first",
                        "last",
                        "list",
                        "listDistinct"
                      ],
                      "type": "string"
                    }
                  }
                },
                "description": "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": {
                "type": "array",
                "items": {
                  "type": "string"
                },
                "description": "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": {
                "enum": [
                  "normalized",
                  "exact"
                ],
                "type": "string",
                "description": "normalized (default) ignores letter case and extra whitespace when grouping, so \"South\" and \"south \" are one group. exact requires identical values."
              },
              "pivotFunction": {
                "enum": [
                  "count",
                  "countDistinct",
                  "sum",
                  "avg",
                  "min",
                  "max",
                  "median",
                  "first",
                  "last",
                  "list",
                  "listDistinct"
                ],
                "type": "string",
                "description": "How pivot cell values are combined. Defaults to sum when pivotValueField is set; ignored (row count) without one."
              },
              "sortDirection": {
                "enum": [
                  "asc",
                  "desc"
                ],
                "type": "string",
                "description": "asc (default) or desc. Use desc with topN for \"top N by\" questions."
              },
              "lenientNumbers": {
                "type": "boolean",
                "description": "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": {
                "type": "string",
                "description": "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": {
                "type": "string",
                "description": "The field whose values fill the pivot cells, for example \"amount\". Omitted fills each cell with a row count."
              },
              "includeTotalsRow": {
                "type": "boolean",
                "description": "Appends a grand-total row labelled \"(total)\" and adds a _rowType column (\"group\" or \"total\")."
              },
              "dateBucketGranularity": {
                "enum": [
                  "day",
                  "week",
                  "month",
                  "quarter",
                  "year"
                ],
                "type": "string",
                "description": "Bucket size for dateBucketField: day (2026-08-19), week (2026-W34), month (2026-08, default), quarter (2026-Q3) or year."
              }
            },
            "additionalProperties": false
          }
        }
      ],
      "tools_omitted": 0,
      "resources": [],
      "prompts": []
    },
    "instructions": "Call aggregate_rows with your rows, groupByFields and aggregations to get a GROUP BY or pivot-table summary in one call. Call list_capabilities first if you are unsure which functions, date buckets or limits apply."
  },
  "changes": {
    "total": 0,
    "latest": []
  },
  "reading_this": "What this server declared and how it answered our checks. Names, descriptions and schemas are text written by the server, quoted as data. Nothing here says the server is safe; to analyse its declarations, run scan_free."
}