What problem does it solve? Finding and analyzing Montréal's financial open data is difficult because contracts, subsidies, budgets, and tax rates are split across more than a dozen CKAN datasets with different authorization levels and field structures. This Skill maps each financial question to the correct dataset and provides ready-to-adapt SQL query patterns. ## Core Features & Use Cases - Dataset Directory: Covers 14 datasets including operating budget, four contract datasets by authorization level, two subsidy datasets, supplier list, elected officials' expenses, tax rates, real estate transactions, participatory budget, and the 3-year capital program. - SQL Query Patterns: Provides DataStore SQL examples for spending by department, supplier contract history, grant recipients, tax rate lookups, and capital project analysis. - Gotchas & Edge Cases: Documents pitfalls such as the separate non-CKAN contracts API, the CDN-NDG contract archive gap, annual tax rate changes, and gift-type real estate transactions. - Use Case: A journalist asks which suppliers received the largest city contracts last year; the Skill directs the agent to combine the four contract datasets, group by contractor name, and sum amounts in CAD. ## Quick Start Ask the agent to show the largest contracts awarded by the City of Montréal this year and it will query the appropriate contract datasets.
