Statistics Canada MCP Server

Read from the package source without running it. The installed server may list more.

• drop_tablewrite action

  Permanently deletes (drops) a table from the SQLite database.

• fetch_vectors_to_database

  PREFERRED tool for multi-series analysis. Fetches data for multiple StatCan vector IDs in a single API call and immediately stores the results in a SQLite table — no separate create/insert steps needed.

• get_all_cubes_list

  Provides a complete inventory of data tables available via the API, including dimension-level details. Disables SSL Verification. Corresponds to: GET /getAllCubesList

• get_all_cubes_list_lite

  Provides a complete inventory of data tables available via the API, excluding dimension or footnote information (lighter version). Disables SSL Verification. Corresponds to: GET /getAllCubesListLite

• get_bulk_vector_data_by_range

  Fetches bulk data for multiple vectors filtered by *release date* range (YYYY-MM-DDTHH:MM), NOT by reference period. Use this when you want data released within a specific date/time window (e.g., "all updates released yesterday").

• get_changed_cube_list

  Get the list of data tables/cubes that were updated on a specific date (YYYY-MM-DD). Disables SSL Verification. Corresponds to: GET /getChangedCubeList/{date}

• get_changed_series_data_from_cube_pid_coord

  Retrieves changed series data (data points that have changed) using Cube ProductId and Coordinate string. Coordinates are automatically padded to 10 dimensions. Disables SSL Verification. Corresponds to: POST /getChangedSeriesDataFromCubePidCoord

• get_changed_series_data_from_vector

  Get changed series data (data points that have changed) for a series identified by Vector ID. Disables SSL Verification. Corresponds to: POST /getChangedSeriesDataFromVector

• get_changed_series_list

  Get the list of series (vectorId, productId, coordinate, releaseTime) that were updated on a specific date (YYYY-MM-DD). Disables SSL Verification. Corresponds to: GET /getChangedSeriesList/{date}

• get_code_sets

  Retrieves definitions for various code sets used by the API (e.g., frequency, units of measure). Corresponds to: GET /getCodeSets

• get_cube_metadata

  Retrieves detailed metadata for a specific data table/cube using its ProductId. Includes dimension info, titles, date ranges, codes, etc. Disables SSL Verification. Corresponds to: POST /getCubeMetadata

• get_data_from_cube_pid_coord_and_latest_n_periods

  Retrieves data for the N most recent reporting periods for ONE specific series identified by ProductId and a single Coordinate string. Coordinates are automatically padded to 10 dimensions. Corresponds to: POST /getDataFromCubePidCoordAndLatestNPeriods

• get_data_from_vector_by_reference_period_range

  PREFERRED tool for fetching data across multiple series by reference period date range (YYYY-MM-DD). Accepts an array of vectorIds and retrieves all of them in a single API call. Disables SSL Verification. Corresponds to: GET /getDataFromVectorByReferencePeriodRange

• get_data_from_vectors_and_latest_n_periods

  Get data for the N most recent reporting periods for a specific data series identified by Vector ID. Disables SSL Verification. Corresponds to: POST /getDataFromVectorsAndLatestNPeriods

• get_full_table_download_csv

  (Discouraged: Use coordinate/vector tools if possible) Get a download link for the full data table/cube in CSV format. Specify language ('en' or 'fr'). Disables SSL Verification. Corresponds to: GET /getFullTableDownloadCSV/{productId}/{lang}

• get_full_table_download_sdmx

  (Discouraged: Use coordinate/vector tools if possible) Get a download link for the full data table/cube in bilingual SDMX (XML) format. Disables SSL Verification. Corresponds to: GET /getFullTableDownloadSDMX/{productId}

• get_sdmx_data

  Fetch filtered time-series observations from a StatCan table via SDMX REST.

• get_sdmx_key_for_dimension

  Return all leaf member IDs for a single dimension as a ready-to-use OR key string.

• get_sdmx_rows

  Fetch SDMX observations and always return rows inline — use this when you need to embed data in an artifact or widget.

• get_sdmx_structure

  Fetch the Data Structure Definition (DSD) for a StatCan table via SDMX REST.

• get_sdmx_vector_data

  Fetch time-series observations for a single StatCan vector via SDMX REST.

• get_series_info

  Resolve one or more {productId, coordinate} pairs to series metadata (vectorId, titles, frequency, UOM, etc.) in a single API call.

• get_series_info_from_cube_pid_coord

  Retrieves series metadata (vectorId, titles, frequency etc.) using Cube ProductId and Coordinate string. Coordinates are automatically padded to 10 dimensions. Disables SSL Verification. Corresponds to: POST /getSeriesInfoFromCubePidCoord

• get_series_info_from_cube_pid_coord_bulk

  Batch-fetch series metadata for MULTIPLE {productId, coordinate} pairs in a single API call. Returns vectorId, titles, frequency, etc. for each series. Corresponds to: POST /getSeriesInfoFromCubePidCoord (accepts array) REPLACED BY: get_series_info (merged single + bulk, same behaviour)

• get_series_info_from_vector

  Request series metadata (productId, coordinate, titles, frequency, etc.) by Vector ID. Disables SSL Verification. Corresponds to: POST /getSeriesInfoFromVector

• get_table_schema

  Retrieves the schema (column names and types) for a specific table.

• insert_data_into_tablewrite action

  Appends rows (list of dicts) into an ALREADY EXISTING SQLite table. Use this only to add more data to a table that was previously created.

• list_tables

  Lists all user-created tables in the SQLite database.

• query_database

  Executes a read-only SQL query (SELECT or PRAGMA) against the database and returns the results. WARNING: Potential security risk! Avoid using this tool with untrusted input or queries that modify data (INSERT, UPDATE, DELETE). Prefer more specific tools like list_tables or get_table_schema when possible. Results may be truncated.

• search_cubes_by_title

  Searches for data cubes/tables where the English or French title contains the provided search term (case-insensitive). Returns a list of matching cubes in the 'lite' format (excluding dimensions/footnotes).

• store_cube_metadata

  Fetches FULL metadata for a cube and stores it into two normalized SQLite tables (_statcan_dimensions, _statcan_members) without returning the full data to the context window.

• Code scan48 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitylocal package, no credentials required12/15
• Maintenancelast push 0 days ago15/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Statistics Canada MCP Server: common questions

Is Statistics Canada MCP Server safe?

Yes, by our scan: it is graded A (92/100). Read the Statistics Canada MCP Server safety report

How do I install Statistics Canada MCP Server?

It runs on your machine. Copy the Claude Code, Claude Desktop or Cursor config from the install section.

Does Statistics Canada MCP Server need an API key?

Not as far as the registry entry and our scan can tell: no credentials are declared or required.

Is Statistics Canada MCP Server maintained?

The last commit was in the last day (2026-09-19). The latest release is v0.7.17.