Skip to main content
Glama
Meador793

Stats Explorer MCP

by Meador793

Summary by group

group_summary
Read-only

Computes grouped statistics such as count, sum, mean, median, min, max, or standard deviation for each category in a file, with sorting and top-N output for comparisons.

Instructions

Analytics-style breakdown: count, sum, mean, median, min, max or SD of a numeric column for each category of another column (e.g. total revenue by region, average order value by segment, top 10 products by profit, rows per status), sorted, top N. Without value_column it counts rows per category. Descriptive only, no p-values. The user confirms the columns first.

Input Schema

NameRequiredDescriptionDefault
topNo
fileNoPath to the data file: CSV, TSV, Excel (.xlsx/.xls) or Parquet. If the user attached the file to the chat, pass its path or name here (a file:// link, @name or #file:name also works); do not paste its contents. Relative names are found in the workspace folders. Files of millions of rows are fine. JSON/BSON and other NoSQL data are not tabular and are not supported.
statsNoWhich numbers to show (default count, sum, mean, median; just count without value_column).
sort_byNo
descendingNo
group_columnYes
value_columnNo
confirmation_tokenNoOnly after the user has confirmed the proposed choices: the confirmation_token from the previous response.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv1.5.1

TDQS

A3.8/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The annotations already declare this as a non-destructive, read-only, closed-world operation, so the description need not restate safety. It adds useful behavioral context: results are descriptive only, no p-values are produced, omitting value_column switches to row counts, and confirmation is required before execution.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is front-loaded with the core operation and uses short follow-up sentences for key constraints. The first sentence is dense with examples and statistic names, but those examples earn their place by clarifying the tool's scope.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The definition is adequate for the core grouped-summary use case, but for an 8-parameter tool with no output schema it omits some parameter-level details and does not describe the return shape or top-N behavior beyond a brief mention. The schema covers some gaps, such as file input and confirmation_token, but not all.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

With schema description coverage at 38%, the description does add meaning for the core parameters: group_column is the category, value_column is the numeric column, stats are the summary measures, and sorting/top N are mentioned. However, it does not clarify sort_by, descending, top limits/defaults, or file handling, leaving several parameters dependent on the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description gives a clear verb-like operation and resource: grouped summary statistics over a numeric column by another category column. It distinguishes the tool from inferential siblings by stating 'Descriptive only, no p-values,' though it does not explicitly name alternatives such as describe or run_test.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The examples make the intended use cases concrete, and the 'Descriptive only, no p-values' line excludes inferential use cases. It also notes the workflow prerequisite that the user confirms the columns first, but it does not explicitly route the agent to named alternative tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.