io.github.theluckystrike/pivot
REMOTE · MCP.ZOVO.ONE · 2 COMPONENTS · SCANNED SEP 24
Group, aggregate and pivot spreadsheet or CSV data from your AI chat: filters, sums, sorts.
Available components
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. How we score → Why this is hard to score →
Endpoint Security94
- The endpoint's TLS certificate is valid, in date, and uses a strong key. View diagnostics → Pass
- Authorisation is enforced on tool calls, advertised via RFC 9728 protected-resource metadata. Discovery is public, which costs nothing: no tool can be invoked without a token. View diagnostics → Pass
- HTTPS is enforced; there's no plaintext access path. View diagnostics → Pass
- The HSTS (Strict-Transport-Security) header is present. View diagnostics → Pass
- DNSSEC check failed: this domain isn't protected by DNSSEC. See how to fix → View diagnostics → Fail
- The authorisation server offers only Dynamic Client Registration (RFC 7591), which MCP 2026-07-28 deprecated in favour of Client ID Metadata Documents. View diagnostics → Partial
Transport & Reachability100
- Verified streamable-http transport via a live MCP handshake. View diagnostics → Pass
Schema Quality & AI Usability82
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1976 tokens (~131/item across 15 items; 13 tools + 2 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management3
- Stability observed for 1 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage95
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 86% of tool parameters carry a description.Partial
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "sheet_unload" implies "delete" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 14 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
How do I install the io.github.theluckystrike/pivot MCP server?
io.github.theluckystrike/pivot is a hosted endpoint at https://mcp.zovo.one/mcp/pivot, 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.
remote · mcp.zovo.one
claude mcp add --transport http theluckystrike-pivot 'https://mcp.zovo.one/mcp/pivot'
{
"mcpServers": {
"theluckystrike-pivot": {
"url": "https://mcp.zovo.one/mcp/pivot"
}
}
} {
"servers": {
"theluckystrike-pivot": {
"type": "http",
"url": "https://mcp.zovo.one/mcp/pivot"
}
}
} [mcp_servers.theluckystrike-pivot] url = "https://mcp.zovo.one/mcp/pivot"
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"theluckystrike-pivot": {
"type": "remote",
"url": "https://mcp.zovo.one/mcp/pivot",
"enabled": true
}
}
} openclaw mcp add theluckystrike-pivot --url 'https://mcp.zovo.one/mcp/pivot' --transport streamable-http
mcp_servers:
theluckystrike-pivot:
url: "https://mcp.zovo.one/mcp/pivot" {
"McpServers": {
"theluckystrike-pivot": {
"Transport": "http",
"Url": "https://mcp.zovo.one/mcp/pivot"
}
}
} assistant mcp add theluckystrike-pivot -t streamable-http -u 'https://mcp.zovo.one/mcp/pivot'
{
"mcpServers": {
"theluckystrike-pivot": {
"type": "http",
"url": "https://mcp.zovo.one/mcp/pivot"
}
}
} The mcpServers block is a cross-client convention. Remote transports vary, so check your client's docs.
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 24 Sept 26 +1
- Stability: unverified → 0.03 ▲ functional
- 23 Sept 26 78
First indexed and scored.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 24 Sept 2026 · Probed https://mcp.zovo.one/mcp/pivot
TLS valid
Negotiated TLS 1.3 with TLS_AES_128_GCM_SHA256 .
| Subject | Issuer | Valid from | Valid until | Key | Signature | Serial |
|---|---|---|---|---|---|---|
| CN=zovo.one | CN=WE1,O=Google Trust Services,C=US | 2 Sept 2026 | 1 Dec 2026 | ECDSA 256 | ECDSA-SHA256 | ef74739bd6e575bb13db69661e215324 |
| SANs: zovo.one, mcp.zovo.one, *.mcp.zovo.one | ||||||
| CN=WE1,O=Google Trust Services,C=US (CA) | CN=GTS Root R4,O=Google Trust Services LLC,C=US | 13 Dec 2023 | 20 Feb 2029 | ECDSA 256 | ECDSA-SHA384 | 7ff31977972c224a76155d13b6d685e3 |
| CN=GTS Root R4,O=Google Trust Services LLC,C=US (CA) | CN=GlobalSign Root CA,OU=Root CA,O=GlobalSign nv-sa,C=BE | 15 Nov 2023 | 28 Jan 2028 | ECDSA 384 | SHA256-RSA | 7fe530bf331343bedd821610493d8a1b |
Background: What to check on a remote MCP endpoint →
DNSSEC insecure
Validation of mcp.zovo.one. — Not signed
| Zone | DS | Keys | Algorithms | Outcome |
|---|---|---|---|---|
| . | trust_anchor | 20326, 38696 | 8, 8 | Verified |
| one. | present | 64939 | 8 | Verified |
| zovo.one. | absent | Unsigned (proven) parent-signed NSEC/NSEC3 proves an unsigned delegation |
Authentication Enforced and verified
The endpoint asked for a token and published valid RFC 9728 metadata describing how to get one.
| Result | Enforced and verified |
|---|---|
| Enforced | On tool calls |
| HTTP status | 200 |
WWW-Authenticate challenge Bearer realm="mcp.zovo.one", error="invalid_token", resource_metadata="https://mcp.zovo.one/.well-known/oauth-protected-resource"
Bearer realm="mcp.zovo.one", error="invalid_token", resource_metadata="https://mcp.zovo.one/.well-known/oauth-protected-resource"| Header | Value |
|---|---|
| strict-transport-security | max-age=15552000; includeSubDomains; preload |
| x-content-type-options | nosniff |
Protected resource metadata
| Document | https://mcp.zovo.one/.well-known/oauth-protected-resource |
|---|---|
| Retrieved | Yes |
| Resource | https://mcp.zovo.one |
| Authorisation server | https://mcp.zovo.one |
Background: How OAuth 2.1 works in the 2026 MCP spec →
Transports 2 probes
| Transport | URL | Outcome | Status | Location |
|---|---|---|---|---|
| streamable-http | https://mcp.zovo.one/mcp/pivot | Verified | 200 | |
| http (plaintext) | http://mcp.zovo.one/mcp/pivot | HTTPS enforced | 301 | https://mcp.zovo.one/mcp/pivot |
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
license_activate Activate license ~76
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.
| Name | Type | Req | Description |
|---|---|---|---|
| key | string | yes | License key from checkout, MCPL1.<payload>.<signature> |
No output schema declared.
No examples provided.
license_status License status ~55
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.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
sheet_add_column Add a column ~289
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.
| Name | Type | Req | Description |
|---|---|---|---|
| decimals | integer | – | 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… |
| formula | string | – | 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 |
| name | string | yes | Name of the new column. It must not already exist on the sheet |
| out_path | string | – | Output file; default <source>-plus-<column>.<same ext>. The source file is left untouched unless this points at it |
| path | string | yes | Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified |
| sheet | string | – | Sheet name; default is the first sheet |
| values | array | – | Explicit values, one per data row, instead of a formula. Missing entries are left blank |
No output schema declared.
No examples provided.
sheet_convert Convert file ~167
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.
| Name | Type | Req | Description |
|---|---|---|---|
| out_path | string | – | Where to write; default is the source name with the new extension, next to the source. It must differ from the source path |
| path | string | yes | Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified |
| sheet | string | – | Sheet to convert; default is the first sheet. Only that one sheet is written |
| to | string | yes | Target format; the default out_path takes this as its extension |
No output schema declared.
No examples provided.
sheet_files List loaded sheets ~30
List the sheets loaded for this token, with their sizes and the storage left under the 2 MB cap.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
sheet_find Find text ~123
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.
| Name | Type | Req | Description |
|---|---|---|---|
| path | string | yes | Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded) |
| sheet | string | – | Sheet name; default searches every sheet |
| text | string | yes | Text to look for; matched case insensitively anywhere inside a cell. Up to 200 hits are returned |
No output schema declared.
No examples provided.
sheet_info Spreadsheet overview ~79
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.
| Name | Type | Req | Description |
|---|---|---|---|
| path | string | yes | Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded) |
No output schema declared.
No examples provided.
sheet_load Load a sheet into this session ~336
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.
| Name | Type | Req | Description |
|---|---|---|---|
| csv | string | – | Raw CSV or TSV text, including the header row |
| name | string | yes | Name to refer to this data by: 1-64 characters of letters, digits, underscore or dash, e.g. "sales" or "sales.csv" |
| url | string | – | 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 |
| xlsx_base64 | string | – | Base64-encoded .xlsx workbook |
No output schema declared.
No examples provided.
sheet_query Filter, group and sort rows ~241
Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse them. Filters, groups, aggregates and sorts in one call. Totals: aggregate/group_by here, never hand sums over sheet_read rows.
| Name | Type | Req | Description |
|---|---|---|---|
| aggregate | array | – | Aggregates per group, e.g. [{"col":"Units","fn":"sum","as":"total_units"}]. Defaults to a row count when group_by is given. |
| as | string | – | – |
| group_by | array | – | Group rows by these columns before aggregating, e.g. ["Rep"] or ["Region","Rep"] |
| limit | integer | – | Default 100 |
| path | string | yes | Path to the .xlsx or .csv file |
| select | array | – | Column names to return; default all (with group_by, defaults to the group columns plus the aggregates) |
| sheet | string | – | – |
| sort | object | – | Sort column; may be an aggregate alias such as total_units |
| where | string | – | Filter, e.g. [Qty] >= 5 AND ([Status] = "open" OR [Status] = "new") |
No output schema declared.
No examples provided.
sheet_read Read rows ~138
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.
| Name | Type | Req | Description |
|---|---|---|---|
| as | string | – | Output format, default table |
| limit | integer | – | Rows to return, default 100 |
| offset | integer | – | Rows to skip, default 0 |
| path | string | yes | – |
| range | string | – | A1 range such as A1:D50; overrides limit/offset |
| sheet | string | – | Sheet name; defaults to the first sheet |
No output schema declared.
No examples provided.
sheet_stats Column statistics ~82
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.
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array | – | Limit to these columns; default all |
| path | string | yes | – |
| sheet | string | – | – |
No output schema declared.
No examples provided.
sheet_unload Delete a loaded sheet ~34
Delete one sheet loaded for this token, freeing its space under the 2 MB cap.
| Name | Type | Req | Description |
|---|---|---|---|
| name | string | yes | – |
No output schema declared.
No examples provided.
sheet_write Write rows ~244
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.
| Name | Type | Req | Description |
|---|---|---|---|
| mode | string | yes | 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 |
| out_path | string | – | 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… |
| path | string | yes | Source file for append/overwrite, or the intended file for new_file (~ is expanded) |
| rows | array | yes | Array of objects, whose keys become the headers, or an array of arrays with the header row first |
| sheet | string | – | 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 |
No output schema declared.
No examples provided.
What is the io.github.theluckystrike/pivot MCP server?
io.github.theluckystrike/pivot is an MCP server listed in the public MCP registry as io.github.theluckystrike/pivot. Group, aggregate and pivot spreadsheet or CSV data from your AI chat: filters, sums, sorts. This page covers its hosted endpoint (https://mcp.zovo.one/mcp/pivot).
Is the io.github.theluckystrike/pivot MCP server safe to use?
io.github.theluckystrike/pivot scores 79 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 io.github.theluckystrike/pivot MCP server expose?
io.github.theluckystrike/pivot exposes 13 tools: license_status, license_activate, sheet_load, sheet_files, sheet_unload, and 8 more. Their descriptions and schemas cost roughly 1,894 tokens of context every time the server is loaded.
Does the io.github.theluckystrike/pivot MCP server require authentication?
Yes. io.github.theluckystrike/pivot asked us for credentials when we connected, so you will need to authorise it in your MCP client before it can do anything.
Is the io.github.theluckystrike/pivot MCP server still maintained?
io.github.theluckystrike/pivot is still listed as active in the MCP registry. We last reached this channel on 24 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.