Tools

6 tools for discovering and querying Eurostat statistical datasets, plus 2 more when the optional dataframe canvas is enabled:

eurostat_search_datasets

Search the Eurostat dataset catalogue by keyword.

• Tokenized keyword match — whitespace-separated tokens are ANDed case-insensitively across each dataset's label, theme breadcrumb, and code, so word order and theme-named queries resolve without a verbatim label
• Returns code, label, type (dataset/table), period coverage, observation count, and theme breadcrumb
• One row per dataset code — Eurostat files some datasets under several theme branches; matches are deduplicated so totalMatches and page slots count unique query targets
• Cursor pagination: limit (1–100, default 20) sets the page size, totalMatches reports the full count, and passing the returned nextCursor back as cursor pages through every match over a stable order. Cursors are bound to their originating query and catalogue snapshot — reusing one with a different query, or after the catalogue refreshes, returns invalid_cursor instead of a silently shifted page
• nextStep hint on each result points at the next tool to call
• Catalogue TOC cached in memory for 12 hours (EUROSTAT_TOC_CACHE_TTL_MS), then refreshed on the next call
• Pair with eurostat_browse_themes for structured domain exploration when keywords are unclear

eurostat_browse_themes

Navigate the Eurostat theme tree.

• Without theme_code: returns the top-level themes (Economy and finance, Population, Transport, etc.)
• With theme_code: returns immediate children — subtheme folders and datasets in that branch
• Each entry includes code, label, type (folder/dataset/table), data period, and observation count where available
• Returns a breadcrumb path from root to the current node, plus a nextStep hint suited to the level (drill into folders or inspect a dataset)
• One branch per folder code — Eurostat files a few folder codes under several branches; a code resolves to the first one the catalogue lists, which never has fewer children than the branches it shadows, and otherPlacements names those so the ambiguity is visible
• Use for structured discovery when you know the domain but not the exact dataset code

eurostat_get_dataset_info

Fetch metadata for a Eurostat dataset before querying it.

• Returns all dimensions with their codes, labels, and up to 10 sample values each
• Reports overall time range and total observation count across all periods, each omitted when Eurostat does not report it
• Combines the dataset-scoped SDMX dataflow descendants with its content constraint, so every dimension — including time — is described from the full dataset-available value set rather than from a populated observation slice
• For dimensions with more than 10 values, use eurostat_get_dimension_values for the full list
• Provides a link to the ESMS metadata page when available

eurostat_get_dimension_values

List all valid values for a specific dataset dimension.

• Retrieves the complete dataset-available set of codes and labels for any dimension (unit, na_item, geo, time, etc.) from the same SDMX content constraint used by dataset metadata
• For the geo dimension, supports NUTS hierarchy filtering: aggregate (EU/EA totals), country (the default when omitted), nuts1, nuts2, and nuts3. The response reports the effective level; an empty level is no_results, not a claim that the dataset is missing. Pairing geo_level with any other dimension is rejected rather than ignored
• Prevents silent no-data returns — invalid dimension values in eurostat_query_dataset return nothing without error; verify codes here first

eurostat_query_dataset

Fetch statistical data from a Eurostat dataset.

• Accepts dimension filters as a map of {dimension_code: [value1, value2, ...]}
• NUTS geo-level filter (aggregate, country, nuts1, nuts2, nuts3) — mutually exclusive with a non-empty geo entry in filters; an empty array is treated as no filter and dropped
• Time range via since_period/until_period (e.g., "2020", "2023-Q1") or last_n_periods for the N most recent
• preview_limit controls the deterministic inline prefix (default 50, max 500). It does not change the match, totals, period coverage, or staged rows; filters and period controls reduce the match itself. There is deliberately no cursor or offset
• Returns decoded observations with dimension codes and labels, numeric values, an OBS_FLAG status (p = provisional, e = estimated, etc.) and a separate CONF_STATUS confidentiality marker (C = confidential, usually the reason a value is null)
• Reports total observation count, missing value count, and the effective time range of the result, each period bound omitted when neither the observations nor Eurostat report it
• obsCount, missingObsCount, and timeRange always describe the full match. truncated is independent of preview_limit and is true only when the match crosses the 5,000-observation staging threshold
• With the dataframe canvas enabled, only a match above 5,000 observations is staged whole as a SQL table and the response returns canvasId / tableName / stagedRowCount; matches at or below 5,000 are never staged. The rows stream into the table one at a time from the response body already in memory, so nothing extra is fetched and the match is never materialized as an array. Call eurostat_dataframe_describe before eurostat_dataframe_query. Without a canvas those fields and tool guidance are absent, and narrowing the query is the way to the rest
• Pass canvas_id from an earlier response to stage several results side by side and join across them
• Async-response detection — large unfiltered queries return an actionable, non-retryable error with filter guidance rather than silently timing out
• Fetches a slice. When the target is a whole dataset, eurostat_download_dataset reads the SDMX bulk endpoint instead, at roughly half the bytes

eurostat_download_dataset

Download a whole dataset through the SDMX 2.1 TSV bulk endpoint (/sdmx/2.1/data/{dataset}?format=TSV).