get_sdmx_key_for_dimension
All leaf member IDs for a large dimension as a ready-to-paste OR key. Use when a dimension has >30 codes (e.g. NOC, CMAs).
How to use it
Project documentation lists get_sdmx_key_for_dimension for the MCP Statcan MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.
Install MCP Statcan
uvx mcp-proxy --transport streamablehttp http://localhost:8000/mcpOther tools in MCP Statcan (16)
Fetch vectors by reference period range and store to SQLite.
Multiple vectors filtered by release date range.
Tables updated on a specific date.
Data points that changed for a coordinate.
Data points that changed for a vectorId.
Series updated on a specific date.
Decode StatCan numeric codes (frequency, UOM, scalar factor, status).
Dimension info, member lists, date ranges. summary=True caps members at 10 per dimension.
Filtered observations by productId + key. Returns a CSV download URL on the hosted server — data stays out of context.
Dimension codelists + key syntax for a table. Call before getsdmxdata.
Observations for a single vectorId via SDMX.
Resolve {productId, coordinate} pairs to vectorId + metadata.
Resolve a vectorId to productId, coordinate, titles, frequency.
Read-only SQL against the local SQLite database.
Full-text search across all StatCan tables. AND logic, capped at 25 results.
Fetch full cube metadata into SQLite — browse all members and vectorIds with SQL.