{"id":727591,"recorded_at":"2026-10-28T01:45:00.538736Z","observed_at":"2026-10-28T01:45:00.538675Z","subject_kind":"endpoint","subject":"0409ad51-5731-4d7e-b125-8100ae3023dd","kind":"mcp.tools","method":"probe.mcp/1","body":{"count":13,"tools":[{"description":"Turn Pro on for this connection with key, an MCPL1.<payload>.<signature> issued at checkout for this server or the bundle. Data under your token stays; a wrong or expired key changes nothing. license_status confirms it.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"key":{"description":"License key from checkout, MCPL1.<payload>.<signature>","type":"string"}},"required":["key"],"type":"object"},"name":"license_activate"},{"description":"Report this endpoint's licence state for your token as JSON: the product, the tier free or pro, why it is not Pro, and the checkout URL. Call it to explain a free-tier refusal. No arguments, nothing changes.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","properties":{},"type":"object"},"name":"license_status"},{"description":"Call this tool to add a computed column and save the result to a NEW file; the source is never modified unless out_path points at it. Returns the new file path, the row count and a preview of the first rows.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"decimals":{"description":"Round numeric formula results to this many decimals. Default: the widest decimal count of the columns the formula reads, capped at 2 when they all hold 2 or fewer (money in, money out); otherwise no rounding beyond float cleanup","maximum":10,"minimum":0,"type":"integer"},"formula":{"description":"Expression over the columns of each row, in the same expression language as sheet_query, e.g. \"[Qty] * [Unit Price]\" or '[Country] = \"PL\"'. Give either formula or values","type":"string"},"name":{"description":"Name of the new column. It must not already exist on the sheet","type":"string"},"out_path":{"description":"Output file; default <source>-plus-<column>.<same ext>. The source file is left untouched unless this points at it","type":"string"},"path":{"description":"Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified","type":"string"},"sheet":{"description":"Sheet name; default is the first sheet","type":"string"},"values":{"description":"Explicit values, one per data row, instead of a formula. Missing entries are left blank","type":"array"}},"required":["path","name"],"type":"object"},"name":"sheet_add_column"},{"description":"Call this tool to convert a sheet between excel (xlsx), csv and json. Writes a new file next to the source unless out_path is given; the source is never modified. Returns the new file path with its row and column counts.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"out_path":{"description":"Where to write; default is the source name with the new extension, next to the source. It must differ from the source path","type":"string"},"path":{"description":"Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified","type":"string"},"sheet":{"description":"Sheet to convert; default is the first sheet. Only that one sheet is written","type":"string"},"to":{"description":"Target format; the default out_path takes this as its extension","enum":["csv","xlsx","json"],"type":"string"}},"required":["path","to"],"type":"object"},"name":"sheet_convert"},{"description":"List the sheets loaded for this token, with their sizes and the storage left under the 2 MB cap.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","properties":{},"type":"object"},"name":"sheet_files"},{"description":"Call this tool to search every cell of a spreadsheet or CSV for text; built-in file readers cannot parse spreadsheets. Matching is case insensitive. Returns cell addresses with a preview of the row each hit is on.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"path":{"description":"Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)","type":"string"},"sheet":{"description":"Sheet name; default searches every sheet","type":"string"},"text":{"description":"Text to look for; matched case insensitively anywhere inside a cell. Up to 200 hits are returned","type":"string"}},"required":["path","text"],"type":"object"},"name":"sheet_find"},{"description":"Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Start here: sheet names, size, header row, column types and samples.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"path":{"description":"Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)","type":"string"}},"required":["path"],"type":"object"},"name":"sheet_info"},{"description":"Upload data to work on. This hosted endpoint has no filesystem, so instead of a file path you send the data once with sheet_load and then pass its name as `path` to sheet_info, sheet_read, sheet_query, sheet_stats, sheet_find, sheet_add_column, sheet_convert and sheet_write. Give exactly one of csv (raw text, comma or tab separated), xlsx_base64 (a base64-encoded .xlsx workbook) or url. url: fetch a public file instead of pasting base64 (recommended above about 10 KB): the url is fetched here with a 10 second timeout, at most 3 redirects, public http(s) hosts only, and a 2 MB cap, and a fetched file is stored as an .xlsx when it carries the PK zip header and as delimited text otherwise. Loaded sheets are kept for your token and survive between calls; the total is capped at 2 MB per token. Files the other tools write come back as a download link that is valid for one hour.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"csv":{"description":"Raw CSV or TSV text, including the header row","type":"string"},"name":{"description":"Name to refer to this data by: 1-64 characters of letters, digits, underscore or dash, e.g. \"sales\" or \"sales.csv\"","maxLength":70,"minLength":1,"type":"string"},"url":{"description":"url: fetch a public file instead of pasting base64 (recommended above about 10 KB). Public http(s) only; private, link-local and this endpoint's own zone are refused","type":"string"},"xlsx_base64":{"description":"Base64-encoded .xlsx workbook","type":"string"}},"required":["name"],"type":"object"},"name":"sheet_load"},{"description":"Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Filter, group, aggregate and sort in one call; never hand sums over sheet_read rows.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"aggregate":{"description":"Aggregates per group, e.g. [{\"col\":\"Units\",\"fn\":\"sum\",\"as\":\"total_units\"}]. Defaults to a row count when group_by is given.","items":{"additionalProperties":false,"properties":{"as":{"description":"Output name for this aggregate, e.g. total_units","type":"string"},"col":{"description":"Column to aggregate, or \"*\" to count rows","type":"string"},"fn":{"description":"sum | count | avg | min | max","enum":["sum","count","avg","min","max"],"type":"string"}},"required":["col","fn"],"type":"object"},"type":"array"},"as":{"enum":["table","json","csv"],"type":"string"},"group_by":{"description":"Group rows by these columns before aggregating, e.g. [\"Rep\"] or [\"Region\",\"Rep\"]","items":{"type":"string"},"type":"array"},"limit":{"description":"Default 100","maximum":100000,"minimum":1,"type":"integer"},"path":{"description":"Path to the .xlsx or .csv file","type":"string"},"select":{"description":"Column names to return; default all (with group_by, defaults to the group columns plus the aggregates)","items":{"type":"string"},"type":"array"},"sheet":{"type":"string"},"sort":{"additionalProperties":false,"description":"Sort column; may be an aggregate alias such as total_units","properties":{"col":{"type":"string"},"dir":{"enum":["asc","desc"],"type":"string"}},"required":["col"],"type":"object"},"where":{"description":"Filter, e.g. [Qty] >= 5 AND ([Status] = \"open\" OR [Status] = \"new\")","type":"string"}},"required":["path"],"type":"object"},"name":"sheet_query"},{"description":"Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Reads rows as a table, JSON or CSV; page with limit/offset or an A1 range.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"as":{"description":"Output format, default table","enum":["table","json","csv"],"type":"string"},"limit":{"description":"Rows to return, default 100","maximum":100000,"minimum":1,"type":"integer"},"offset":{"description":"Rows to skip, default 0","minimum":0,"type":"integer"},"path":{"type":"string"},"range":{"description":"A1 range such as A1:D50; overrides limit/offset","type":"string"},"sheet":{"description":"Sheet name; defaults to the first sheet","type":"string"}},"required":["path"],"type":"object"},"name":"sheet_read"},{"description":"Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Whole-column statistics: count, empty, distinct, min, max, sum, mean, median.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"columns":{"description":"Limit to these columns; default all","items":{"type":"string"},"type":"array"},"path":{"type":"string"},"sheet":{"type":"string"}},"required":["path"],"type":"object"},"name":"sheet_stats"},{"description":"Delete one sheet loaded for this token, freeing its space under the 2 MB cap.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"name":{"maxLength":70,"minLength":1,"type":"string"}},"required":["name"],"type":"object"},"name":"sheet_unload"},{"description":"Call this tool to write rows to an xlsx, csv, tsv or json file; the extension of out_path picks the format. mode is new_file, append or overwrite. Other sheets are kept. Free: 500 rows per file.","inputSchema":{"$schema":"http://json-schema.org/draft-07/schema#","additionalProperties":false,"properties":{"mode":{"description":"new_file writes a brand new file and refuses to clobber an existing one; append adds the rows under the existing data; overwrite replaces the file contents","enum":["new_file","append","overwrite"],"type":"string"},"out_path":{"description":"Where to write; default is a new file next to the source for new_file, or the source itself for append/overwrite. The output format follows this extension: .xlsx, .csv, .tsv or .json. An extension is required","type":"string"},"path":{"description":"Source file for append/overwrite, or the intended file for new_file (~ is expanded)","type":"string"},"rows":{"description":"Array of objects, whose keys become the headers, or an array of arrays with the header row first","items":{"anyOf":[{"additionalProperties":{},"type":"object"},{"type":"array"}]},"type":"array"},"sheet":{"description":"Sheet to write; default is the first sheet of the source, or \"Sheet1\" for a new file. Other sheets of an existing workbook are kept unchanged","type":"string"}},"required":["path","rows","mode"],"type":"object"},"name":"sheet_write"}]},"body_sha256":"9f46b5fe79ebb464055278009e63dc312d8983b15298f39b9f36e099711266b7","prev_id":null,"leaf":"0x2ba19ce61d3cff83789013c5aeff4a7ba3f85d1c1e05915888021182a184e360","leaf_text":"{\"body\":\"9f46b5fe79ebb464055278009e63dc312d8983b15298f39b9f36e099711266b7\",\"id\":727591,\"kind\":\"mcp.tools\",\"method\":\"probe.mcp/1\",\"observed_us\":1793151900538675,\"prev\":null,\"subject\":\"0409ad51-5731-4d7e-b125-8100ae3023dd\",\"subject_kind\":\"endpoint\"}","day":{"day":"2026-10-28","leaves":231336,"root":"0x2c19037464cc4c493624565f01775d6446fc78eaa118fc6865bfe2bfca9ff78e","chained":"0xd1d7dee8322ceff8f4c8d83aa1fe4a4466825c2af1c97dbde3d35db61234f7be","anchor_chain":"eip155:5042002","anchor_tx":"0x8bae2b1d097834c8b458513862d70d29ee807e98dc2e863b27250131c15b35ae","anchor_block":69584042},"proof":["0x2ba1a8f6774356ec3cebd99d48f341946f57d4ccccb866d6a41dd539cc4c4f51","0xf95d4473b4f4520cbffa339a2ce00d3e3f94a9b08f83da37a7069d26ea9f94d3","0xf9a2a9dad91af6f158afa2ab13ef8b0c3b73206f927e6869888110c6f4b1bb48","0x2bb3309a51f98db88b5fe8edaa8e286f84cf4b624fa04066af43bf95afcd3b82","0xa9afe54466d36ba1f7788e701df0a794f25616be56ac0e2becc8e0c95be21b32","0x9ba17dc6f382c4cc5af97750c7f151d59d6e1ddaf9b65f2508f7f3d79cdac9e3","0x4210365c198f232321cc6e8d443ecb6c27cf17d542b067861e5e973c9e04fb32","0x11e27103b2bee1778217fa2b32b2c5d34125409cc2e01001844019aebecd8490","0x96abc5f3755f94d8ff57d1327cd989e57e537629a80b34722a8c83933a09b417","0xc95551e4c66950a234762d163cead03d04e91499fd1153fa5827dd9418166e2c","0xd7f3a7e39561fc6f73405f156f969572d3ec680ec960160964ec81dd8bd36ecc","0x4a94a3ac3dfed6d233db13adbf426768f2e5b39636e8b941578822cffb4c7708","0x34e8921023105d1b4efc95c5f5f5debe65fd903bd04b069da2922111cc422fdf","0x5c170d609340e1f702f31fcdd7742289f0913d4395f688b3409031b758c69eae","0x8d500b42a7bdba5e17ebd9e6a404f2de5260cf3420865b41e7de8c69434ce413","0xaeb1503e5d0d358b256ba97a10178c357ddb8f55cc961925ccf0458aae5ebcae","0xf078ea7d84d98dbeffed23d8e67b36751e60464ffd4cfdc005e0aa6f8cb9b459","0xe027395fafb7fc41921c42ca0542524ea22204cbd5908b70b27f3d5fb26f5d0f"]}