query_data
Query statistical data from OECD datasets. Use dimension filters and time periods to retrieve specific observations, with configurable limits to manage data size.
Instructions
Query actual statistical data from an OECD dataset. ⚠️ IMPORTANT: Defaults to last 100 observations (max 1000) to protect context window. Use filters, time periods, or last_n_observations to control data size. Large datasets (e.g. SOCX_AGG) can have 70,000+ observations - always specify limits!
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataflow_id | Yes | Dataflow ID to query | |
| filter | No | Dimension filter (e.g., "USA.GDP.." for US GDP). Use "*" or "all" for all values. Get structure first to see valid dimensions. | |
| start_period | No | Start period (e.g., "2020-Q1", "2020-01") | |
| end_period | No | End period (e.g., "2023-Q4", "2023-12") | |
| last_n_observations | No | Get only the last N observations (default: 100, max: 1000 to protect against context overflow) |