Skip to main content
Glama

Statistics Canada — Table Search

statcan.catalogue.search
Read-onlyIdempotent

Search and discover Statistics Canada data tables (6,000+ available). Filter by keyword in the English table title, by Statistics Canada subject code (e.g. "14" for Labour, "16" for Prices and price indexes, "36" for National accounts), and by active vs. archived status. Returns table product IDs, CANSIM IDs, titles, date ranges, release frequency (annual/monthly/quarterly), and subject codes. Use the product_id from results to fetch full metadata (table_metadata) or time-series data (table_data). Source: Statistics Canada WDS, Canada Open Licence, no auth required.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
limitNoMaximum number of tables to return (1–100). Defaults to 20.
queryNoKeyword to search in English table titles (e.g. "labour force", "inflation", "housing"). Case-insensitive.
archivedNoFilter archived tables: false (default) = active only, true = archived only, "all" = both active and archived.
subject_codeNoStatistics Canada subject code to filter by (e.g. "14" for Labour, "16" for Prices, "36" for National Accounts). Two-digit string.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
errorNoPresent only when the call failed. Includes error code, message, request_id, and any provider-specific extras.
resultNoTool response payload. Shape varies per tool — consult the tool description and inputSchema. May be an object, array, string, or number depending on the upstream provider response.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint, openWorldHint, idempotentHint, and no destructive behavior, so there is no contradiction. The description adds meaningful context beyond annotations: no auth required, source/license, corpus size, and what fields are returned. It does not mention pagination or rate limits, but those gaps are minor given the strong annotation coverage.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Four sentences with clearly distinct jobs: scope, filters, return fields, downstream workflow, and licensing/auth. The purpose is front-loaded and every sentence earns its place with no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool has no required parameters and an output schema, and annotations cover safety and side effects. The description adds the remaining essential context: auth requirements, source/license, filter semantics, return fields, and downstream tool usage. An agent has everything needed to search and proceed correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description restates subject code examples and archived-status filtering that the schema already documents in detail, adding little new meaning. It does not need to compensate for schema gaps because every parameter is already explained.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with 'Search and discover Statistics Canada data tables', a specific verb plus resource, and enumerates the filters and return fields. It also distinguishes itself from downstream fetch tools by naming 'table_metadata' and 'table_data' as follow-ups, so an agent can tell search apart from data retrieval.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description makes the search-first workflow explicit: 'Use the product_id from results to fetch full metadata (table_metadata) or time-series data (table_data).' This routes the agent to the correct sibling tools. It does not provide an explicit when-not condition or compare against statcan.series.info, so it stops short of a full 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.