{"name":"io.github.Aryan-Jhaveri/mcp-statcan","slug":"aryan-jhaveri-mcp-statcan","title":"Statistics Canada MCP Server","description":"Access Statistics Canada data via the Web Data Services API","url":"https://mcp.market/server/aryan-jhaveri-mcp-statcan","rating":null,"grade":"A","score":92,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":37,"stars":6,"forks":1,"downloads_week":145,"last_push_at":"2026-09-19T17:53:48.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/Aryan-Jhaveri/mcp-statcan","website":"https://github.com/Aryan-Jhaveri/mcp-statcan","version":"0.7.17","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"statcan-mcp-server","version":"0.7.17","runtimeHint":"uvx","transport":{"type":"stdio"}}],"tools":[{"name":"drop_table","description":"Permanently deletes (drops) a table from the SQLite database.","write_action":true,"price_micros":0,"input_schema":null},{"name":"fetch_vectors_to_database","description":"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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_all_cubes_list","description":"Provides a complete inventory of data tables available via the API, including dimension-level details. Disables SSL Verification. Corresponds to: GET /getAllCubesList","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_all_cubes_list_lite","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_bulk_vector_data_by_range","description":"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\").","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_changed_cube_list","description":"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}","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_changed_series_data_from_cube_pid_coord","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_changed_series_data_from_vector","description":"Get changed series data (data points that have changed) for a series identified by Vector ID. Disables SSL Verification. Corresponds to: POST /getChangedSeriesDataFromVector","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_changed_series_list","description":"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}","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_code_sets","description":"Retrieves definitions for various code sets used by the API (e.g., frequency, units of measure). Corresponds to: GET /getCodeSets","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_cube_metadata","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_data_from_cube_pid_coord_and_latest_n_periods","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_data_from_vector_by_reference_period_range","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_data_from_vectors_and_latest_n_periods","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_full_table_download_csv","description":"(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}","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_full_table_download_sdmx","description":"(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}","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sdmx_data","description":"Fetch filtered time-series observations from a StatCan table via SDMX REST.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sdmx_key_for_dimension","description":"Return all leaf member IDs for a single dimension as a ready-to-use OR key string.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sdmx_rows","description":"Fetch SDMX observations and always return rows inline — use this when you need to embed data in an artifact or widget.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sdmx_structure","description":"Fetch the Data Structure Definition (DSD) for a StatCan table via SDMX REST.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sdmx_vector_data","description":"Fetch time-series observations for a single StatCan vector via SDMX REST.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_series_info","description":"Resolve one or more {productId, coordinate} pairs to series metadata (vectorId, titles, frequency, UOM, etc.) in a single API call.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_series_info_from_cube_pid_coord","description":"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","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_series_info_from_cube_pid_coord_bulk","description":"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)","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_series_info_from_vector","description":"Request series metadata (productId, coordinate, titles, frequency, etc.) by Vector ID. Disables SSL Verification. Corresponds to: POST /getSeriesInfoFromVector","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_table_schema","description":"Retrieves the schema (column names and types) for a specific table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"insert_data_into_table","description":"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.","write_action":true,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"Lists all user-created tables in the SQLite database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"query_database","description":"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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"search_cubes_by_title","description":"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).","write_action":false,"price_micros":0,"input_schema":null},{"name":"store_cube_metadata","description":"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.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":92,"grade":"A","scanned_at":"2026-09-19T20:14:46.366Z","report":{"scannerVersion":"0.1.5","scannedAt":"2026-09-19T20:14:46.356Z","components":{"code":{"score":25,"max":25,"notes":["48 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":12,"max":15,"notes":["local package, no credentials required"]},"maintenance":{"score":15,"max":15,"notes":["last push 0 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"statcan-mcp-server","version":"0.7.17","found":true,"weeklyDownloads":145,"license":"MIT","dependencyCount":9,"publishedAt":"2026-09-19T17:53:42.805818Z","repositoryUrl":"https://github.com/Aryan-Jhaveri/mcp-statcan"}],"repo":{"found":true,"owner":"Aryan-Jhaveri","repo":"mcp-statcan","archived":false,"pushedAt":"2026-09-19T17:53:48Z","stars":6,"forks":1,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/96702278?v=4","ownerCreatedAt":"2021-12-26T21:12:04Z","license":"MIT"},"icon":{"url":"https://raw.githubusercontent.com/Aryan-Jhaveri/mcp-statcan/main/assets/Flag.jpg","source":"registry"},"presence":{"stars":6,"forks":1,"downloadsWeek":145,"license":"MIT","lastPushAt":"2026-09-19T17:53:48.000Z","score":37}}}},"grade_history":[],"reviews":[]}