Skip to main content
Glama

Get Price Statistics

get_price_statistics
Read-onlyIdempotent

Need to analyze Alberta electricity price patterns? Get key statistics like mean, median, range, standard deviation, and percentiles from hourly pool price data for any interval.

Instructions

Calculates count, mean, median, range, population standard deviation, negative/high price hours, and requested percentiles from complete hourly Pool Price observations.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
requestYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
metadataYesProvenance and semantic metadata attached to dataset responses.
warningsNo
percentilesYes
observation_countYes
median_cad_per_mwhNo
average_cad_per_mwhNo
maximum_cad_per_mwhNo
minimum_cad_per_mwhNo
negative_price_hoursNo
standard_deviation_cad_per_mwhNo
hours_at_or_above_100_cad_per_mwhNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv0.3.0

TDQS

A3.6/5.0
Behavior4/5

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

Annotations already declare this as read-only, open-world, and idempotent. The description adds valuable behavioral specifics: it computes population standard deviation (not sample), includes negative/high price hours, and supports requested percentiles. The 'complete observations' phrasing also hints at a data-completeness assumption, which is useful context beyond the annotations.

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

Conciseness5/5

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

The description is a single, dense sentence that front-loads the action and resource. Every listed statistic is relevant and contributes to understanding the tool's output. There is no filler or redundancy.

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?

Given the moderate complexity of a nested request object and 0% schema description coverage, the description does not fully equip an agent to correctly structure the call. The output schema and annotations cover returns and safety, but the tool's core trigger parameters (start, end, percentiles) are only vaguely alluded to. Overall, it is minimally viable but has clear gaps.

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

Parameters2/5

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

With schema description coverage at 0%, the description must compensate, but it only hints at one parameter ('requested percentiles') and provides no meaning for the request object's start/end properties or how percentiles should be formatted. It does not explain that the request must contain a time interval, leaving a significant gap for an agent constructing input.

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

Purpose5/5

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

The description uses a specific verb 'Calculates' with a clear resource ('complete hourly Pool Price observations') and enumerates the exact statistics produced. This clearly distinguishes it from sibling tools like get_pool_prices or get_price_duration_curve, which focus on raw data or distribution shapes rather than aggregate statistics.

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

Usage Guidelines2/5

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

No explicit guidance is given on when to prefer this tool over alternatives. The phrase 'complete hourly Pool Price observations' implies a data-completeness requirement, but it does not state when to use this versus get_price_duration_curve, find_price_events, or other statistical tools. There are no exclusions or alternative references.

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