`statcan_table`

Pack: statcan · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/statcan_table for the schema, then POST the same URL with its arguments for the data.

Whole StatCan table (or a filtered slice) in ONE call, from a local Pipeworx copy of the table — full history, every coordinate, member labels included, instead of one coordinate per call. Use this instead of statcan_cube_data when the question spans more than one coordinate (“compare all provinces”, “the whole eggs/milk/hydro table”, “full history for this table”), or instead of statcan_csv_url when you need the DATA rather than a download URL. Covers a curated set of high-demand StatCan product ids only — call with just product_id to check coverage; an uncached product_id REFUSES with a clear message naming what is cached, it does not return an empty result. Data refreshes weekly from StatCan’s official getFullTableDownloadCSV export; every response carries data_as_of. Statistics Canada Open Licence permits redistribution.

Parameters

Name	Type	Required	Description
`product_id`	number	yes	StatCan cube product ID, e.g. 42100037.
`coordinate`	string	no	Optional: restrict to one coordinate (as in statcan_cube_data), e.g. “1.1.1.1”. Omit for the whole table.
`geo`	string	no	Optional: case-insensitive substring filter on the GEO column, e.g. “Quebec” or “Ontario”.
`ref_date_from`	string	no	Optional: only rows with ref_date >= this value (matches the table’s own date grain, e.g. “2022” or “2022-01”).
`ref_date_to`	string	no	Optional: only rows with ref_date <= this value.
`limit`	number	no	Max rows per page (default 500, max 1000).
`page`	number	no	Page number, 1-based (default 1).

Example call

Arguments

{
  "product_id": 42100037
}

curl

curl -X POST https://gateway.pipeworx.io/statcan/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"statcan_table","arguments":{"product_id":42100037}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('statcan_table', {
  "product_id": 42100037
});

More examples

{
  "product_id": 32100113,
  "geo": "Quebec"
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the statcan pack

{
  "mcpServers": {
    "statcan": {
      "url": "https://gateway.pipeworx.io/statcan/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

statcan_table