Skip to main content
Glama

pxweb-mcp

MCP server for accessing statistical data via the PxWeb API v2.

Quick Start

npx -y @jarib/pxweb-mcp
npx -y @jarib/pxweb-mcp --transport streamable-http --port 3000

Related MCP server: mcp-stat-lv

Known PxWeb v2 Instances

Organization

URL

Statistics Norway (SSB)

https://data.ssb.no/api/pxwebapi/v2

Statistics Sweden (SCB)

https://statistikdatabasen.scb.se/api/v2

Use the --url option to connect to a different instance:

npx @jarib/pxweb-mcp --url https://statistikdatabasen.scb.se/api/v2

Development

pnpm install
pnpm build
node build/index.js

Configuration

{
  "mcpServers": {
    "pxweb": {
      "type": "http",
      "url": "http://localhost:3000/mcp"
    }
  }
}

License

MIT

Available Tools

6 tools
fetch_metadataA

Fetch detailed metadata for a table to understand its structure.

Returns variable IDs, value codes, elimination info, and available code lists. Use this to construct queries.

Inputs: table_id (required), language.

get_code_listA

Fetch a code list (valueset or grouping).

Valuesets (vs_*): Lists of valid values for a variable. Groupings (agg_*): Aggregation mappings (e.g., municipality mergers).

Find available code lists in table metadata under 'codeLists'.

Inputs: code_list_id (required), language.

get_table_infoA

Get basic information about a table (title, time range, variables).

Use this for a quick overview before fetching full metadata.

Inputs: table_id (required), language.

list_recent_tablesA

List tables updated in the past N days.

Use this to find newly published statistics.

Inputs: days (required), language.

query_tableB

Query data from a table using the v2 API syntax.

Value selection syntax:

  • Specific values: valueCodes[Region]=0301,0402

  • All values: valueCodes[Region]=*

  • Wildcard: valueCodes[Konsumgrp]=?? (two-digit codes)

  • Latest N: valueCodes[Tid]=top(5)

  • From value: valueCodes[Tid]=from(2020M01)

  • Range: valueCodes[Region]=[range(01,05)]

Output formats: json-stat2, csv, xlsx, html, px, json-px

For csv/xlsx/html, use stub and heading to control layout.

Inputs: table_id (required), value_codes (required), language, code_list, +2 more.

search_tablesA

Search for tables in Statistics Norway (SSB) database.

Supports wildcards (*) at end of words, boolean operators (AND, OR), and special filters:

  • title:word - search only in titles

  • updated:20250908* - tables updated on date

  • "word1 word2"~5 - proximity search (words within 5 words of each other)

Geographic indicators in titles: (F) = county, (K) = municipality, (B) = city district.

Inputs: query (required), language, include_discontinued.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4/5.0

    Scored across 6 tools

    Disambiguation4/5

    Tools are mostly separable: search_tables and list_recent_tables both discover tables but use different criteria, and query_table/get_code_list have unique roles. The only mild overlap is get_table_info versus fetch_metadata, where the descriptions distinguish basic overview from detailed query-building metadata.

    Naming Consistency5/5

    All tool names follow the same verb_noun snake_case pattern (search_tables, query_table, get_code_list, etc.). The use of fetch instead of get in fetch_metadata is a minor synonym variation but does not break the overall pattern.

    Tool Count5/5

    Six tools is a well-scoped size for a statistical data server, covering discovery, metadata inspection, code lists, and querying. Each tool has a distinct role and none feels like filler.

    Completeness5/5

    The tool set supports the full user workflow: find tables, inspect metadata, resolve code lists, and query data. For a read-only public statistics API, there are no obvious missing operations that would create dead ends.

    Maintenance

    ActivityInactive
    ResponsivenessLimited data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      D
      maintenance
      MCP server for official statistics from Statistics Finland (Tilastokeskus) — the StatFin database, exposed through the PxWeb API. Search 3000+ tables, inspect their dimensions, and pull data as JSON-stat2.
      4
      51 npm
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      MCP server that enables querying Latvian official statistics from data.stat.gov.lv via PxWeb tables, allowing retrieval of table definitions and data through natural language or direct tool calls.
      296 npm
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      MCP server for Statistics Norway (SSB) PxWebApi, enabling table metadata queries via a single tool.
      299 npm
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      MCP server for accessing Norges Bank exchange rates and interest rates via SDMX data flows.
      100 npm
      MIT