exchange-rates-mcp-server
An open-source MCP server that provides tools to list currencies, retrieve current and historical foreign exchange rates from Frankfurter v1, convert currency amounts, and query time-series data using SQL via DataCanvas. It supports STDIO and Streamable HTTP transports and requires no API key.
Endpoint and access
No sign-in to connect and list tools. Individual tools may still need a vendor account, credentials, or permissions; check the documented prerequisites.
MCP endpoint (Streamable HTTP)
https://exchange-rates.caseyjhand.com/mcpWhat its tools do
7 tools, grouped by the hints the server advertises. Hints are self-declared, not verified behavior.
Checks and signals
Each line is separate evidence, not a trust score.
- Passed Endpoint answered the live check ·
- Availability 1 of 1 checks passed in 30 days
What you can do with it
- List available currencies and their latest rate dates
- Get current or historical exchange rates for a base currency
- Convert an amount between two currencies at a specific date
- Query historical daily rates using SQL over staged DataCanvas tables
Source and maintenance
Community listingRegistry 0.6.0
- Maintenance checked
Protocol and capabilities
- Server
- exchange-rates-mcp-server 0.6.0
- MCP protocol negotiated in check
- 2025-11-25
- Tools
- 7 advertised
- Resources
- 6 advertised
- Resource templates
- 2 advertised
- Prompts
- 0 advertised
Server-advertised capabilities
{
"tools": {
"listChanged": true
},
"logging": {},
"prompts": {
"listChanged": true
},
"resources": {
"subscribe": true,
"listChanged": true
},
"extensions": {
"io.modelcontextprotocol/skills": {
"directoryRead": true
}
}
}Server-provided instructions
Untrusted server output shown for inspection. It is not Koskamo guidance and is excluded from knowledge search.
Tools
7 advertised
fx_list_currencies — Fx List Currencies
Advertised read-onlyOpen-world
List current Frankfurter v1 currency codes and names with as_of, the latest served rate date. include_retired=true adds historical codes absent from the current set. Optional official ECB start_date/end_date are outer coverage bounds, not uninterrupted availability; a dated end_date does not imply retirement. Metadata outages are disclosed without failing current discovery. Historical availability remains validated from requested v1 data. Use this to disambiguate dollars (USD vs AUD vs CAD).
fx_list_currencies input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"include_retired": {
"type": "boolean",
"description": "Include historical codes absent from current v1 discovery, default false. Optional official ECB coverage dates are outer bounds and may contain gaps."
}
},
"additionalProperties": false
}fx_list_currencies output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"currencies",
"count",
"as_of",
"source"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"as_of": {
"type": "string",
"description": "Latest served daily rate date for this current-discovery list; historical availability is checked against historical data."
},
"count": {
"type": "number",
"description": "Total number of supported currencies."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"description": "Machine-readable failure mode."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"notice": {
"type": "string",
"description": "Discloses unavailable optional coverage metadata or incomplete coverage dates."
},
"source": {
"type": "string",
"description": "Always \"Frankfurter v1\" — the upstream data provider."
},
"currencies": {
"type": "array",
"items": {
"type": "object",
"required": [
"code",
"name"
],
"properties": {
"code": {
"type": "string",
"description": "ISO 4217 currency code (e.g. USD, EUR, JPY)."
},
"name": {
"type": "string",
"description": "Full currency name (e.g. \"United States Dollar\")."
},
"end_date": {
"type": "string",
"description": "Last covered date in optional official ECB metadata; a date here does not imply retirement."
},
"start_date": {
"type": "string",
"description": "First covered date in optional official ECB metadata; outer bound, not uninterrupted availability."
}
},
"description": "A single supported currency.",
"additionalProperties": false
},
"description": "All supported currencies, sorted alphabetically by code."
}
},
"additionalProperties": false
}fx_list_currencies annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}fx_get_rates — Fx Get Rates
Advertised read-onlyOpen-world
Get all available exchange rates for one base currency in a single snapshot. Useful for bulk comparison and seeding downstream tools. Returns a map of quote currency → rate, the actual snapshot date, and whether a historical date was snapped from a weekend/holiday to the prior business day. Optionally filter to a subset of quote currencies via symbols. Listing the base currency itself in symbols is accepted and returns a rate of 1 for it.
fx_get_rates input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"base_currency"
],
"properties": {
"date": {
"type": "string",
"pattern": "^(?:\\d{4}-\\d{2}-\\d{2}|latest)$",
"description": "ISO 8601 date (YYYY-MM-DD). Omit for the latest available rate. Frankfurter v1 data starts 1999-01-04. Future dates are not supported."
},
"symbols": {
"type": "array",
"items": {
"type": "string",
"description": "ISO 4217 currency code to include in the response."
},
"minItems": 1,
"description": "Optional list of quote currency codes to filter the response. When provided, must contain at least one currency code — omit the field entirely, not an empty array, to return all ~30 supported currencies (the base is not among them). Including base_currency here is valid — it comes back with a rate of 1."
},
"base_currency": {
"type": "string",
"description": "ISO 4217 base currency code (e.g. USD). Call fx_list_currencies to get valid codes."
}
},
"additionalProperties": false
}fx_get_rates output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"base_currency",
"rate_date",
"rates",
"date_snapped",
"rate_type",
"source"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"invalid_date_format",
"unsupported_currency",
"date_out_of_range",
"upstream_no_data"
],
"description": "Machine-readable failure mode. Declared by this tool: `invalid_date_format`: date is not a real calendar date written as YYYY-MM-DD. `unsupported_currency`: base_currency or an entry in symbols is not available in the current discovery or served historical data. `date_out_of_range`: date is before 1999-01-04 or in the future. `upstream_no_data`: Every requested currency is supported but the Frankfurter v1 published no rates for this date. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"rates": {
"type": "object",
"description": "Map of quote currency code → exchange rate (units of quote per 1 base).",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "number"
}
},
"source": {
"type": "string",
"description": "Always \"Frankfurter v1\" — the upstream data provider."
},
"rate_date": {
"type": "string",
"description": "Actual date of the rates. May differ from requested date on weekends/holidays — daily observations may skip non-publication days; the API silently snaps to the prior business day."
},
"rate_type": {
"type": "string",
"description": "Always \"Daily rate (Frankfurter v1)\" — these are reference rates, not tradeable bid/ask."
},
"date_snapped": {
"type": "boolean",
"description": "True when the API returned a different date than requested — Frankfurter v1 snaps weekend/holiday requests to the prior business day. Always false when date is omitted."
},
"base_currency": {
"type": "string",
"description": "The base currency code."
}
},
"additionalProperties": false
}fx_get_rates annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}fx_get_rate — Fx Get Rate
Advertised read-onlyOpen-world
Get the exchange rate for a currency pair on a given date (default: latest). Returns the rate, the actual rate date (which may differ from the requested date on weekends/holidays — daily observations may skip non-publication days), and source provenance. Cross-rates are triangulated through EUR automatically. A same-currency pair returns a rate of 1, dated to the same publication day any other pair would report for that date. Use fx_convert_currency when you want the converted amount; use this tool when you only need the rate number.
fx_get_rate input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"base_currency",
"quote_currency"
],
"properties": {
"date": {
"type": "string",
"pattern": "^(?:\\d{4}-\\d{2}-\\d{2}|latest)$",
"description": "ISO 8601 date (YYYY-MM-DD). Omit for the latest available rate. Frankfurter v1 data starts 1999-01-04. Future dates are not supported."
},
"base_currency": {
"type": "string",
"description": "ISO 4217 base currency code (e.g. USD). Call fx_list_currencies to get valid codes."
},
"quote_currency": {
"type": "string",
"description": "ISO 4217 quote currency code (e.g. EUR). The rate is expressed as \"how many quote units per 1 base unit\". Call fx_list_currencies to get valid codes."
}
},
"additionalProperties": false
}fx_get_rate output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"base_currency",
"quote_currency",
"rate",
"rate_date",
"date_snapped",
"rate_type",
"source"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"rate": {
"type": "number",
"description": "Exchange rate: units of quote currency per 1 unit of base currency."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"invalid_date_format",
"unsupported_currency",
"date_out_of_range",
"upstream_no_data"
],
"description": "Machine-readable failure mode. Declared by this tool: `invalid_date_format`: date is not a real calendar date written as YYYY-MM-DD. `unsupported_currency`: base_currency or quote_currency is not available in the current discovery or served historical data. `date_out_of_range`: date is before 1999-01-04 or in the future. `upstream_no_data`: Both currencies are supported but the Frankfurter v1 published no rate for this date. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"source": {
"type": "string",
"description": "Always \"Frankfurter v1\" — the upstream data provider."
},
"rate_date": {
"type": "string",
"description": "Actual date of the rate returned."
},
"rate_type": {
"type": "string",
"description": "Always \"Daily rate (Frankfurter v1)\" — these are reference rates, not tradeable bid/ask."
},
"date_snapped": {
"type": "boolean",
"description": "True when the API returned a different date than requested — Frankfurter v1 snaps weekend/holiday requests to the prior business day."
},
"base_currency": {
"type": "string",
"description": "The base currency code."
},
"quote_currency": {
"type": "string",
"description": "The quote currency code."
}
},
"additionalProperties": false
}fx_get_rate annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}fx_convert_currency — Fx Convert Currency
Advertised read-onlyOpen-world
Convert an amount between any two currencies at the latest or a historical rate. Returns the converted amount, the rate used, the actual rate date, and whether the date was snapped from a weekend/holiday to the prior business day. Cross-rates are triangulated through EUR automatically.
fx_convert_currency input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"base_currency",
"quote_currency",
"amount"
],
"properties": {
"date": {
"type": "string",
"pattern": "^(?:\\d{4}-\\d{2}-\\d{2}|latest)$",
"description": "ISO 8601 date (YYYY-MM-DD) for a historical rate. Omit for the latest available rate. Frankfurter v1 data starts 1999-01-04. Future dates are not supported."
},
"amount": {
"type": "number",
"description": "Amount in the base currency to convert. Must be greater than zero.",
"exclusiveMinimum": 0
},
"base_currency": {
"type": "string",
"description": "ISO 4217 source currency code (e.g. USD). Call fx_list_currencies to get valid codes."
},
"quote_currency": {
"type": "string",
"description": "ISO 4217 target currency code (e.g. EUR). The amount will be expressed in this currency. Call fx_list_currencies to get valid codes."
}
},
"additionalProperties": false
}fx_convert_currency output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"base_currency",
"quote_currency",
"base_amount",
"quote_amount",
"rate",
"rate_date",
"date_snapped",
"rate_type",
"source"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"rate": {
"type": "number",
"description": "Exchange rate used: units of quote currency per 1 unit of base currency."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"invalid_date_format",
"unsupported_currency",
"date_out_of_range",
"upstream_no_data"
],
"description": "Machine-readable failure mode. Declared by this tool: `invalid_date_format`: date is not a real calendar date written as YYYY-MM-DD. `unsupported_currency`: base_currency or quote_currency is not available in the current discovery or served historical data. `date_out_of_range`: date is before 1999-01-04 or in the future. `upstream_no_data`: Both currencies are supported but the Frankfurter v1 published no rate for this date. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"source": {
"type": "string",
"description": "Always \"Frankfurter v1\" — the upstream data provider."
},
"rate_date": {
"type": "string",
"description": "Actual date of the rate used for conversion."
},
"rate_type": {
"type": "string",
"description": "Always \"Daily rate (Frankfurter v1)\" — these are reference rates, not tradeable bid/ask."
},
"base_amount": {
"type": "number",
"description": "The input amount in the base currency."
},
"date_snapped": {
"type": "boolean",
"description": "True when the API returned a different date than requested — Frankfurter v1 snaps weekend/holiday requests to the prior business day."
},
"quote_amount": {
"type": "number",
"description": "The unrounded amount × rate product in the quote currency, using JavaScript floating-point precision; no currency minor-unit rounding policy is applied."
},
"base_currency": {
"type": "string",
"description": "Source currency code."
},
"quote_currency": {
"type": "string",
"description": "Target currency code."
}
},
"additionalProperties": false
}fx_convert_currency annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}fx_get_timeseries — Fx Get Timeseries
Advertised read-onlyOpen-world
Get historical daily Frankfurter v1 rates over an inclusive date range. Same-date EUR legs are divided without intermediate rounding; only days with both currencies appear, including observed self-pairs at 1 and historical retired currencies. Missing-leg served days produce coverage notices; weekends and holidays are not counted as missing. summary covers all observed days before delivery: arithmetic mean, earliest tied extrema, endpoints and percentage change, without accounting policy. limit bounds returned rows (default/max 500); 0 returns summary only. Continue inline with next_start_date, the same end_date and a positive limit. Long ranges (>90 days by default) stage beyond the 40,000-character preview budget, independently of limit. Explicit canvas_id always stages the complete series, including short/empty results, and fails if unavailable or unknown. Each registration preserves earlier tables with a unique table_name. spilled=true returns canvas_id and table_name; use fx_dataframe_describe then fx_dataframe_query for SQL. Without DataCanvas, omit canvas_id to page inline.
fx_get_timeseries input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"base_currency",
"quote_currency",
"start_date",
"end_date"
],
"properties": {
"limit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": 0,
"description": "Maximum observations returned in rates, default 500, clamped to 500. Use 0 for summary only; continue inline with a positive limit. Does not affect summary, counts, bounds, staging eligibility or the complete staged table."
},
"end_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "ISO 8601 end date (YYYY-MM-DD). Must be >= start_date. Future dates are not supported."
},
"canvas_id": {
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Existing canvas ID from a prior call explicitly requesting staging even for short or empty results. Every call creates a uniquely named table. Omit for automatic staging or inline paging."
},
"start_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "ISO 8601 start date (YYYY-MM-DD). Frankfurter v1 data starts 1999-01-04. The actual first data point may be later if start_date falls on a weekend/holiday."
},
"base_currency": {
"type": "string",
"description": "ISO 4217 base currency code (e.g. USD). Call fx_list_currencies to get valid codes."
},
"quote_currency": {
"type": "string",
"description": "ISO 4217 quote currency code (e.g. EUR). Call fx_list_currencies to get valid codes."
}
},
"additionalProperties": false
}fx_get_timeseries output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"base_currency",
"quote_currency",
"start_date",
"end_date",
"rates",
"rate_count",
"truncated",
"rate_type",
"source",
"spilled"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"invalid_date_format",
"unsupported_currency",
"date_out_of_range",
"invalid_range",
"upstream_no_data",
"canvas_not_found",
"canvas_unavailable"
],
"description": "Machine-readable failure mode. Declared by this tool: `invalid_date_format`: start_date or end_date is not a real calendar date written as YYYY-MM-DD. `unsupported_currency`: base_currency or quote_currency is not available in the current discovery or served historical data. `date_out_of_range`: start_date is before 1999-01-04 or end_date is in the future. `invalid_range`: start_date is after end_date. `upstream_no_data`: Both currencies are supported but the Frankfurter v1 published no rates across this range. `canvas_not_found`: An explicitly supplied canvas_id does not exist or has expired. `canvas_unavailable`: canvas_id requests staging on a deployment with DataCanvas disabled. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"rates": {
"type": "object",
"description": "Date → rate map in date order, observed days inside the requested range only. Bounded by limit (default/max 500), and by the character budget for automatically staged previews. Empty for limit 0 or no observations. Inline partial results continue with next_start_date and a positive limit; staged tables retain every observation.",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "number"
}
},
"notice": {
"type": "string",
"description": "Explains a result that would otherwise look broken or incomplete: an empty series (no publication day in the range); an inline page cut short (the start_date to continue from, plus why a long range was not staged when DataCanvas is turned off); or a spilled series (the canvas and table it was staged to, and the tools that read it)."
},
"source": {
"type": "string",
"description": "Always \"Frankfurter v1\" — the upstream data provider."
},
"spilled": {
"type": "boolean",
"description": "True when the complete result was staged on DataCanvas, either explicitly through canvas_id or automatically after exceeding the threshold and preview budget."
},
"summary": {
"type": "object",
"required": [
"mean",
"min",
"max",
"first",
"last",
"change_pct"
],
"properties": {
"max": {
"type": "object",
"required": [
"rate",
"date"
],
"properties": {
"date": {
"type": "string",
"description": "Earliest date with the highest rate."
},
"rate": {
"type": "number",
"description": "Highest rate."
}
},
"description": "Maximum observation.",
"additionalProperties": false
},
"min": {
"type": "object",
"required": [
"rate",
"date"
],
"properties": {
"date": {
"type": "string",
"description": "Earliest date with the lowest rate."
},
"rate": {
"type": "number",
"description": "Lowest rate."
}
},
"description": "Minimum observation.",
"additionalProperties": false
},
"last": {
"type": "object",
"required": [
"rate",
"date"
],
"properties": {
"date": {
"type": "string",
"description": "Last publication date."
},
"rate": {
"type": "number",
"description": "Last rate."
}
},
"description": "Chronologically last observation.",
"additionalProperties": false
},
"mean": {
"type": "number",
"description": "Unweighted arithmetic mean of all daily observations in the requested range; not an accounting-policy prescription."
},
"first": {
"type": "object",
"required": [
"rate",
"date"
],
"properties": {
"date": {
"type": "string",
"description": "First publication date."
},
"rate": {
"type": "number",
"description": "First rate."
}
},
"description": "Chronologically first observation.",
"additionalProperties": false
},
"change_pct": {
"type": "number",
"description": "Percentage change from first to last observation."
}
},
"description": "Statistics over all observed days in the full clipped requested range before limit, paging or staging; omitted for empty ranges. Missing-leg coverage notices describe excluded served days. Continuations summarize their own requested interval.",
"additionalProperties": false
},
"end_date": {
"type": "string",
"description": "Last publication date in the requested range. Always inside the requested range — earlier than the requested end when that day had no Frankfurter v1 fix, and equal to it when the series is empty. Later than the last key in rates when truncated is true."
},
"canvas_id": {
"type": "string",
"description": "Canvas ID — present when spilled is true. Pass to fx_dataframe_describe to inspect the staged table, then to fx_dataframe_query to run SQL."
},
"rate_type": {
"type": "string",
"description": "Always \"Daily rate (Frankfurter v1)\" — these are reference rates, not tradeable bid/ask."
},
"truncated": {
"type": "boolean",
"description": "True when rates holds only part of the series: an inline page (next_start_date continues it) or a spilled preview (spilled is true). False when rates holds every publication day in the requested range."
},
"rate_count": {
"type": "number",
"description": "Total observed publication days in the requested range (the start_date through end_date passed on this call) — not the number of entries in rates, which is smaller when truncated is true. On a continuation call it counts the days from that start_date onward."
},
"start_date": {
"type": "string",
"description": "First observed publication date in the requested range, including when limit is 0. Always inside the requested range — later than the requested start when that day had no Frankfurter v1 fix, and equal to it when the series is empty."
},
"table_name": {
"type": "string",
"description": "Canvas table name — present when spilled is true. Use it as the FROM target in fx_dataframe_query SQL; fx_dataframe_describe lists its columns."
},
"base_currency": {
"type": "string",
"description": "Base currency code."
},
"quote_currency": {
"type": "string",
"description": "Quote currency code."
},
"next_start_date": {
"type": "string",
"description": "Present only when an inline page was cut short: the first publication date not in rates. Pass it as start_date with the same end_date and a positive limit to get the next page. For limit 0 it is the first observation. Absent on the final page and staged results."
}
},
"additionalProperties": false
}fx_get_timeseries annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}fx_dataframe_describe — Fx Dataframe Describe
Advertised read-only
List tables and columns staged on a DataCanvas from a prior fx_get_timeseries call. Required first step before fx_dataframe_query — use it to discover table names and column schemas. Requires DataCanvas, which is on by default — a deployment that turns it off does not list this tool at all, and fx_get_timeseries returns every range inline there.
fx_dataframe_describe input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"canvas_id"
],
"properties": {
"canvas_id": {
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Canvas ID returned by fx_get_timeseries. Re-run fx_get_timeseries to obtain a fresh canvas_id if this one has expired."
}
},
"additionalProperties": false
}fx_dataframe_describe output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"canvas_id",
"tables",
"expires_at"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"canvas_not_found"
],
"description": "Machine-readable failure mode. Declared by this tool: `canvas_not_found`: canvas_id does not exist or has been evicted. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"tables": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"kind",
"row_count",
"columns"
],
"properties": {
"kind": {
"type": "string",
"description": "Either \"table\" or \"view\"."
},
"name": {
"type": "string",
"description": "Table or view name."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type",
"nullable"
],
"properties": {
"name": {
"type": "string",
"description": "Column name."
},
"type": {
"type": "string",
"description": "DuckDB column type (e.g. VARCHAR, DOUBLE, BIGINT)."
},
"nullable": {
"type": "boolean",
"description": "Whether the column accepts NULL values."
}
},
"description": "A single column descriptor.",
"additionalProperties": false
},
"description": "Column schema for this table."
},
"row_count": {
"type": "number",
"description": "Number of rows in this table or view."
}
},
"description": "A single table or view staged on the canvas.",
"additionalProperties": false
},
"description": "All tables and views currently staged on this canvas."
},
"canvas_id": {
"type": "string",
"description": "The canvas ID echoed back — use this in fx_dataframe_query."
},
"expires_at": {
"type": "string",
"description": "ISO 8601 timestamp when this canvas will be evicted."
}
},
"additionalProperties": false
}fx_dataframe_describe annotations
{
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}fx_dataframe_query — Fx Dataframe Query
Advertised read-only
Run a read-only SQL SELECT against DataCanvas tables staged by fx_get_timeseries. Supports aggregations, GROUP BY, window functions, and JOINs across multiple registered tables. Run fx_dataframe_describe first to discover table names and column schemas. Requires DataCanvas, which is on by default — a deployment that turns it off does not list this tool at all, and fx_get_timeseries returns every range inline there.
fx_dataframe_query input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"canvas_id",
"query"
],
"properties": {
"query": {
"type": "string",
"description": "Read-only SQL SELECT statement. Reference tables by the names returned by fx_dataframe_describe or the table_name field from fx_get_timeseries. Example: SELECT date, rate FROM <table_name> WHERE date > '2024-01-01' ORDER BY date; replace <table_name> with the returned name, including its unique suffix."
},
"canvas_id": {
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Canvas ID returned by fx_get_timeseries. Re-run fx_get_timeseries to obtain a fresh canvas_id if this one has expired."
},
"row_limit": {
"type": "integer",
"default": 150,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Most rows to return (positive integer, default 150; values above 10000 clamp to 10000 with a notice). When the query produces more, truncated is true — page with ORDER BY <column> LIMIT <n> OFFSET <m> in the SQL, or aggregate, rather than raising this toward the maximum."
}
},
"additionalProperties": false
}fx_dataframe_query output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"rows",
"row_count",
"truncated",
"canvas_id"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"description": "One result row — column-name → value pairs matching the SELECT columns.",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"description": "Result rows, at most row_limit (default 150). Each key is a column name from the query."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"canvas_not_found",
"missing_table",
"invalid_query"
],
"description": "Machine-readable failure mode. Declared by this tool: `canvas_not_found`: canvas_id does not exist or has been evicted. `missing_table`: The SQL references a table that is not staged on this canvas, or whose TTL expired. `invalid_query`: SQL is not a SELECT, references unknown columns, or has a syntax error. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"notice": {
"type": "string",
"description": "Reports requested and effective row limits when clamped, and the ORDER BY … LIMIT … OFFSET query shape when the result is truncated."
},
"canvas_id": {
"type": "string",
"description": "The canvas ID used — pass to a subsequent fx_dataframe_query or fx_dataframe_describe call."
},
"row_count": {
"type": "number",
"description": "Rows returned — always the length of rows. When truncated is true this equals row_limit, not the full result size."
},
"truncated": {
"type": "boolean",
"description": "True when the query produced more rows than row_limit and rows holds only the first row_limit of them. Fetch the rest with ORDER BY <column> LIMIT <n> OFFSET <m> — ORDER BY is required for deterministic paging — or aggregate to shrink the result."
}
},
"additionalProperties": false
}fx_dataframe_query annotations
{
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}Prompts
0 advertised
Resources
6 advertised
fx-currencies — fx-currencies
Current Frankfurter v1 currency discovery with full names and the latest served rate date as_of. Historical availability is checked against historical data, including retired currencies.
fx-currencies URI
fx://currenciesLatest EUR rates — fx-rates-latest
Latest exchange rates snapshot for a base currency as a stable URI. Returns all available quote currencies at the most recent Frankfurter v1 business-day fix.
Latest EUR rates URI
fx://rates/latest/EURLatest USD rates — fx-rates-latest
Latest exchange rates snapshot for a base currency as a stable URI. Returns all available quote currencies at the most recent Frankfurter v1 business-day fix.
Latest USD rates URI
fx://rates/latest/USDLatest GBP rates — fx-rates-latest
Latest exchange rates snapshot for a base currency as a stable URI. Returns all available quote currencies at the most recent Frankfurter v1 business-day fix.
Latest GBP rates URI
fx://rates/latest/GBPLatest JPY rates — fx-rates-latest
Latest exchange rates snapshot for a base currency as a stable URI. Returns all available quote currencies at the most recent Frankfurter v1 business-day fix.
Latest JPY rates URI
fx://rates/latest/JPYexchange-rates-guide
Analyze historical FX periods with fx_* tools, discover retired currency coverage, and compare staged series with SQL. Use for period averages, highs/lows, movements, incomplete coverage, or multi-pair analysis; simple conversions and latest snapshots can use the tools directly.
exchange-rates-guide URI
skill://exchange-rates-guide/SKILL.mdfx-rates-latest — fx-rates-latest
Latest exchange rates snapshot for a base currency as a stable URI. Returns all available quote currencies at the most recent Frankfurter v1 business-day fix.
fx-rates-latest URI template
fx://rates/latest/{base}io.modelcontextprotocol/skills
io.modelcontextprotocol/skills URI template
skill://{+path}90-day uptime
A lightweight connection check about every six hours, sampled on hosts with many listings. It shows the server answered, not that its tools work.
- 2026-11-07: 1 of 1 checks answered
30-day availability
Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.
- Successful checks
- 1 of 1 (100%)
- Average latency
- 698 ms
- 95th percentile latency
- 698 ms
Maintenance history
Public check and source-refresh events. Editorial and ownership records remain private.
- · probe · passed · 698 ms · metadata changed · 7 tool(s), 6 resource(s), 2 resource template(s), 0 prompt(s)
Connect from your client
Each snippet registers the same endpoint; pick the client you use.
Claude Code
Claude Code configuration
claude mcp add --transport http exchange-rates-mcp-server-caseyjhand https://exchange-rates.caseyjhand.com/mcpCodex
Codex configuration
codex mcp add exchange-rates-mcp-server-caseyjhand --url https://exchange-rates.caseyjhand.com/mcpCursor
Cursor configuration
{
"mcpServers": {
"exchange-rates-mcp-server-caseyjhand": {
"url": "https://exchange-rates.caseyjhand.com/mcp"
}
}
}Cline
Cline configuration
{
"mcpServers": {
"exchange-rates-mcp-server-caseyjhand": {
"type": "streamableHttp",
"url": "https://exchange-rates.caseyjhand.com/mcp",
"disabled": false
}
}
}VS Code
VS Code configuration
{
"servers": {
"exchange-rates-mcp-server-caseyjhand": {
"type": "http",
"url": "https://exchange-rates.caseyjhand.com/mcp"
}
}
}Gemini CLI
Gemini CLI configuration
gemini mcp add --transport http exchange-rates-mcp-server-caseyjhand https://exchange-rates.caseyjhand.com/mcpClaude Desktop
Claude Desktop configuration
https://exchange-rates.caseyjhand.com/mcpWindsurf
Windsurf configuration
{
"mcpServers": {
"exchange-rates-mcp-server-caseyjhand": {
"serverUrl": "https://exchange-rates.caseyjhand.com/mcp"
}
}
}Let your agent find its tools
Find servers like exchange-rates-mcp-server from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.