Skip to main content
Glama

exchange-rates-mcp-server

Fx Get Timeseries

fx_get_timeseries
Read-onlyIdempotent

Get historical daily exchange rates for a currency pair over a date range. ECB publishes on business days only — weekends and holidays produce no entry, and no date outside the requested range is ever returned, so a range covering only non-publication days comes back with an empty rates map and a notice explaining why. A same-currency pair returns a rate of 1 on each publication day in the range. Short ranges (≤90 days by default) are returned inline as a date→rate map. When DataCanvas is enabled (CANVAS_PROVIDER_TYPE=duckdb) long ranges spill to it: the response carries spilled=true, a canvas_id, and a table_name — call fx_dataframe_describe to inspect the staged table, then fx_dataframe_query to run SQL against it. Without DataCanvas long ranges stay inline (spilled=false) and the notice says so.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
end_dateYesISO 8601 end date (YYYY-MM-DD). Must be >= start_date. Future dates are not supported.
canvas_idNoOptional canvas ID from a prior call. Omit on the first call to start a fresh canvas; pass the returned canvas_id to append tables to an existing canvas.
start_dateYesISO 8601 start date (YYYY-MM-DD). ECB data starts 1999-01-04. The actual first data point may be later if start_date falls on a weekend/holiday.
base_currencyYesISO 4217 base currency code (e.g. USD). Call fx_list_currencies to get valid codes.
quote_currencyYesISO 4217 quote currency code (e.g. EUR). Call fx_list_currencies to get valid codes.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
errorNoPresent when the call failed. Absent on success.
ratesNoDate → rate map for the inline result. Publication days inside the requested range only. Truncated to a preview when the result was spilled to canvas; empty when the range contains no publication day at all.
noticeNoExplains a result that would otherwise look broken — an empty series, or a long range that stayed inline because DataCanvas is not configured.
sourceNoAlways "ECB via Frankfurter" — the upstream data provider.
spilledNoTrue when the full result was staged on the DataCanvas (range exceeded threshold).
end_dateNoLast date in the returned series. Always inside the requested range — earlier than the requested end when that day had no ECB fix, and equal to it when the series is empty.
canvas_idNoCanvas ID — present when spilled is true. Pass to fx_dataframe_query.
rate_typeNoAlways "ECB reference (mid-market)" — these are reference rates, not tradeable bid/ask.
rate_countNoTotal number of data points (publication days) inside the requested range.
start_dateNoFirst date in the returned series. Always inside the requested range — later than the requested start when that day had no ECB fix, and equal to it when the series is empty.
table_nameNoCanvas table name — present when spilled is true. Use in fx_dataframe_query SQL.
base_currencyNoBase currency code.
quote_currencyNoQuote currency code.

TDQS

A4.4/5.0
Behavior5/5

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

Beyond the annotations (readOnly, idempotent, openWorld), the description discloses extensive behaviors: ECB publication days only, empty map with a notice for non-publication ranges, same-currency rate of 1, inline vs spill based on range length and DataCanvas configuration, and the exact response flags (spilled, canvas_id, table_name). This is far beyond what annotations provide.

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 long but every sentence serves a distinct purpose: purpose first, then edge cases, then spill logic. It is front-loaded with the primary function and organized in a logical flow. While it could be trimmed slightly, the structure is strong and there is no fluff.

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

Completeness5/5

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

Given the tool's complexity (multiple conditional behaviors, spill integration, and response variations), the description is remarkably complete. It explains all return scenarios, the spill condition and how to proceed, and the same-currency case. The existence of an output schema further reduces the burden, but the description goes beyond that by describing response fields and follow-up actions, leaving nothing critical missing.

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?

The input schema covers all parameters at 100% with descriptions, so the baseline is 3. The description adds domain context (e.g., date-boundary behavior, ECB holidays) but does not explain individual parameters beyond what the schema already states. It does clarify the 'short range' default of 90 days, which relates to start/end dates, but this is more about behavior than parameter semantics. Therefore, it meets the baseline without exceeding it.

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 names a specific verb ('Get historical daily exchange rates'), a precise resource ('currency pair over a date range'), and explicitly distinguishes itself from sibling tools by describing the spill workflow to fx_dataframe_describe/query. The purpose is unambiguous and not a tautology.

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?

It provides clear conditional guidance: when long ranges spill to DataCanvas, it explicitly directs the agent to call fx_dataframe_describe and fx_dataframe_query. It also implies this is the tool for historical daily series as opposed to single-rate tools, though it never explicitly states 'use fx_get_rate for a single date'. The lack of explicit 'when not to use' is a minor gap.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

TDQS

A4.6/5.0
Disambiguation5/5

Each tool has a distinct, non-overlapping purpose: conversion, single rate, bulk rates, timeseries, currency listing, and DataFrame inspection/query. The descriptions clearly differentiate between getting a rate vs converting an amount, and between inline vs DataCanvas-stored timeseries.

Naming Consistency5/5

All tools follow a consistent fx_verb_noun pattern (e.g., fx_get_rate, fx_convert_currency, fx_list_currencies). The two dataframe tools also adhere to fx_dataframe_verb, maintaining a uniform convention across the entire set.

Tool Count5/5

Seven tools is well-scoped for an exchange-rate server. Each tool addresses a needed operation (conversion, rates, timeseries, metadata) without redundancy or bloat, and adding DataFrame analysis feels justified for handling large datasets.

Completeness5/5

The surface covers the full lifecycle of exchange-rate queries: listing currencies, fetching single or bulk rates, converting with historical dates, and retrieving timeseries. The optional DataCanvas integration fills the gap for large-range analysis, leaving no obvious dead ends for common use cases.