query_database

MCP tool from MCP Statcan by Aryan-Jhaveri

Read-only SQL against the local SQLite database.

How to use it

Project documentation lists query_database 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/mcp
FULL MCP STATCAN LISTING

Other tools in MCP Statcan (16)

fetch_vectors_to_database

Fetch vectors by reference period range and store to SQLite.

get_bulk_vector_data_by_range

Multiple vectors filtered by release date range.

get_changed_cube_list

Tables updated on a specific date.

get_changed_series_data_from_cube_pid_coord

Data points that changed for a coordinate.

get_changed_series_data_from_vector

Data points that changed for a vectorId.

get_changed_series_list

Series updated on a specific date.

get_code_sets

Decode StatCan numeric codes (frequency, UOM, scalar factor, status).

get_cube_metadata

Dimension info, member lists, date ranges. summary=True caps members at 10 per dimension.

get_sdmx_data

Filtered observations by productId + key. Returns a CSV download URL on the hosted server — data stays out of context.

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).

get_sdmx_structure

Dimension codelists + key syntax for a table. Call before getsdmxdata.

get_sdmx_vector_data

Observations for a single vectorId via SDMX.

get_series_info

Resolve {productId, coordinate} pairs to vectorId + metadata.

get_series_info_from_vector

Resolve a vectorId to productId, coordinate, titles, frequency.

search_cubes_by_title

Full-text search across all StatCan tables. AND logic, capped at 25 results.

store_cube_metadata

Fetch full cube metadata into SQLite — browse all members and vectorIds with SQL.