sql_query
Run SQL queries directly on Ontario's open data portals. Use for quick, one-off data retrieval from datastore-active resources.
Instructions
Run a SQL query against the CKAN Datastore (remote).
NOTE: Prefer download_resource + query_cached for repeated queries — the remote API has rate limits (429 errors). Use this tool only for quick one-off queries on datastore-active resources.
Use resource IDs as table names in double quotes. Example: SELECT "Column Name" FROM "resource-id-here" WHERE "Year" > 2020 LIMIT 10
Args: sql: SQL query string (read-only, SELECT only) portal: Portal to query (default: "ontario"). Required because SQL embeds resource IDs directly.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| portal | No | ontario |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |