oecd_list_agencies
List OECD SDMX agencies, the directorate each belongs to, and the number of dataflows each publishes. Use to discover agency IDs before filtering oecd_search_datasets by department.
Search, explore, and query 1,500+ OECD statistical datasets (national accounts, employment, trade, education, health) from the OECD SDMX API via MCP. STDIO or Streamable HTTP.
claude mcp add --transport http oecd-mcp-server https://oecd.caseyjhand.com/mcp
codex mcp add oecd-mcp-server --url https://oecd.caseyjhand.com/mcp
{
"mcpServers": {
"oecd-mcp-server": {
"url": "https://oecd.caseyjhand.com/mcp"
}
}
}
gemini mcp add --transport http oecd-mcp-server https://oecd.caseyjhand.com/mcp
{
"mcpServers": {
"oecd-mcp-server": {
"command": "bunx",
"args": [
"mcp-remote",
"https://oecd.caseyjhand.com/mcp"
]
}
}
}
{
"mcpServers": {
"oecd-mcp-server": {
"type": "http",
"url": "https://oecd.caseyjhand.com/mcp"
}
}
}
curl -X POST https://oecd.caseyjhand.com/mcp \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{"protocolVersion":"2025-11-25","capabilities":{},"clientInfo":{"name":"curl","version":"1.0.0"}}}'
List OECD SDMX agencies, the directorate each belongs to, and the number of dataflows each publishes. Use to discover agency IDs before filtering oecd_search_datasets by department.
Search OECD dataflows by keyword or theme, matching each query token at the start of a word in dataflow names and descriptions, with name matches ranked first. Returns flow_ref identifiers, names, and agency IDs for use with oecd_get_dataset_info.
Fetch a dataflow's dimensions, their order, and how to construct a query key. Returns per-dimension names, codelist references, and position in the dot-delimited key. Required before calling oecd_query_dataset to understand key structure.
Fetch the valid codes and labels for one dimension of a dataflow. Use to resolve human-readable names (countries, measures) to SDMX codes before querying with oecd_query_dataset. Pass query to match a code or label by substring — codelists run to a thousand-plus entries, and the response is a page of at most limit codes either way. A codelist is shared across dataflows and can list codes this one holds no data for: pass available_only to list only the codes with data, or key to list the codes with data given the key's other segments — a structure read, never a data download.
Fetch observations from an OECD dataflow filtered by a dimension key and optional time range. Returns one row per observation, sorted by dimension code and then period, carrying the dimensions and attributes that vary — each label with its SDMX code beside it as <ID>_code — and values already scaled by the unit multiplier; the components holding one value across the whole result come back once, in constant_columns. Large multi-country time-series spill to a DataCanvas table holding every column, codes included — inspect columns with oecd_dataframe_describe, then query the full table with SQL using oecd_dataframe_query; without DataCanvas every row still comes back, but the rendered table stops at a preview slice. Call oecd_get_dataset_info first to learn the dimension order for constructing the key.
List tables and columns staged on a DataCanvas by a prior oecd_query_dataset spill. Call this before oecd_dataframe_query to discover exact table and column names for SQL. Unavailable when the server runs with DataCanvas disabled.
Run a read-only SQL SELECT against OECD observation tables staged on a DataCanvas by oecd_query_dataset. Call oecd_dataframe_describe first to discover exact table and column names, then use this tool for aggregation, filtering, GROUP BY, JOIN, and window functions. Returns up to `limit` rows (default 100, at most 1,000 per call); truncated: true marks a result with more rows than came back, and its notice says how to reach the rest. A query still running after 30 seconds is stopped. Unavailable when the server runs with DataCanvas disabled.
Drop one table or view from a DataCanvas staged by oecd_query_dataset, freeing it once the analysis no longer needs it. The canvas and its other tables stay queryable. Call oecd_dataframe_describe first for the exact table names. Unavailable when the server runs with DataCanvas disabled.
No tools match the current filter.
Dimension metadata for a single OECD dataflow — same content as oecd_get_dataset_info. {flow_id} is the combined {dsd_id}@{df_id} string with @ percent-encoded as %40 in the URI, or the bare {df_id} for the few dataflows OECD publishes without a datastructure prefix. Example: oecd://dataflow/OECD.SDD.NAD/DSD_NAAG%40DF_NAAG_I
{
"directoryRead": true
}