`toronto_query`

Pack: data-toronto · Endpoint: https://gateway.pipeworx.io/data-toronto/mcp

Query any City of Toronto datastore resource (open.toronto.ca, CKAN) by its resource id (a UUID). Supports a free-text q, exact-match filters (field→value), sort (“field desc”), limit and offset. Use toronto_datasets to find a resource id, or toronto_recent for the common ones.

Parameters

Name	Type	Required	Description
`resource_id`	string	yes	CKAN datastore resource id (UUID), e.g. “6d0229af-bc54-46de-9c2b-26759b01dd05”.
`q`	string	no	Free-text search across columns.
`filters`	object	no	Exact-match filters as a JSON object, e.g. {“PERMIT_TYPE”:“New Building”}.
`sort`	string	no	Sort clause, e.g. “APPLICATION_DATE desc”.
`limit`	number	no	Max rows (default 100, max 1000).
`offset`	number	no	Row offset for paging.

Example call

Arguments

{
  "resource_id": "6d0229af-bc54-46de-9c2b-26759b01dd05",
  "limit": 100
}

curl

curl -X POST https://gateway.pipeworx.io/data-toronto/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"toronto_query","arguments":{"resource_id":"6d0229af-bc54-46de-9c2b-26759b01dd05","limit":100}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('toronto_query', {
  "resource_id": "6d0229af-bc54-46de-9c2b-26759b01dd05",
  "limit": 100
});

More examples

{
  "resource_id": "6d0229af-bc54-46de-9c2b-26759b01dd05",
  "filters": {
    "PERMIT_TYPE": "New Building"
  },
  "sort": "APPLICATION_DATE desc",
  "limit": 50
}

Connect

Add this to your MCP client config, or use one-click install buttons:

{
  "mcpServers": {
    "data-toronto": {
      "url": "https://gateway.pipeworx.io/data-toronto/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

toronto_query