query_database

MCP tool from MCP Statcan by Aryan-Jhaveri

Read-only SQL against the local SQLite database.

How to use it

query_database is exposed by the MCP Statcan MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query_database tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

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.