Statfin Fi MCP server

statfin-fi

Statistics Finland (StatFin) — the full catalogue of Finnish official statistics published by Tilastokeskus, served over its PxWeb API: population, education, employment, consumer prices, housing, health and national accounts.

Part of Pipeworx — an MCP gateway connecting AI agents to 1679+ live data sources.

Tools

Table paths

A table path is /.px where the id is the bare 4-character table code:

vkour/15ig.px      Population aged 15 or over by level of education, gender, age and origin
khi/11xs.px        Consumer price index

The longer statfinpxt.px form appears throughout older StatFin documentation. It was retired upstream and now returns 400 on every table; this pack rewrites it to the current form, so a caller arriving with the documented-but-dead path still gets data (fleet #497).

Asking in plain English

select maps a dimension to a value using either the English label or the native code, and query_table resolves both against the table's own metadata:

{ "path": "vkour/15ig.px", "select": { "Information": "tertiary level qualification" } }

→ 1672232 Finns aged 15+ hold a tertiary qualification (2025), alongside the matching share, 34.5%.

Dimensions you don't name are filled in for you: the year defaults to the latest published, dimensions StatFin can eliminate are aggregated to their total, and a dimension with an explicit total value (SSS, Total, or an open-ended range starting at the table's own floor such as age 15-) uses it. Every one of those choices comes back in selectionresolved**, and a dimension with no defensible total is returned in full rather than silently collapsed — a defaulted dimension nobody can see is how a wrong number gets read as a right one.

A value that matches several rows returns all of them rather than picking one, so {"Information": "tertiary level qualification"} yields both the count and the percentage. If it matches more than 20, that is reported as too broad.

Results also carry figures: the json-stat2 value[] array paired with its dimension labels, for results up to 60 cells. That is the readable form — json-stat2's flat array over an implicit cartesian product is not.

Dimension codes are native Finnish

Even on the /en/ endpoint the dimension codes are Finnish, and some labels are untranslated. There is no way to guess them, which is what select exists to spare you; pass body yourself and you need table_meta first. For vkour/15ig.px:

Worked call — population aged 15+ with a tertiary qualification, 2024:

Shortened. The full README is on GitHub.