Open Calgary: Dataset Rows by SoQL Query

calgaryopendata/dataset-rows

Rows from any tabular dataset on the Open Calgary (data.calgary.ca), chosen by its 8-character dataset id (for example 35ra-9556, Traffic Incidents). Narrow, project, sort and aggregate with SoQL: select, where, order, group, a text search q, limit (1 to 50, default 10) and offset. Values come back as the portal publishes them, mostly strings. A filter that matches nothing returns an empty list; an unknown dataset id is refused as a validation error. City of Calgary data as served by Omnial; not an official City of Calgary product.

activeper callv1

Price

$0.0026 per call

You pay the price shown. If a call turns out to cost more than its quote, you pay the actual price, capped at twice the quote. No monthly minimum. Top-ups start at $0.50.

Data source

Open Calgary (data.calgary.ca)

Contains information licensed under the Open Government Licence - City of Calgary (https://data.calgary.ca/stories/s/u45n-7awa/). Data from the City of Calgary, published on Open Calgary. Served by Omnial; not an official City of Calgary product.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

Connect once and your AI can find and run this tool, and any other it needs.

Install it Create an account

agent

// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "calgaryopendata/dataset-rows" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "calgaryopendata/dataset-rows" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "calgaryopendata/dataset-rows", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "calgaryopendata/dataset-rows", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

Charge	Price
Per call	$0.0026

Updated: Oct 21, 2026

Input and output schemas

Input schema

input_schema.json

{
  "type": "object",
  "required": [
    "dataset_id"
  ],
  "properties": {
    "q": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional text search across the dataset's text columns."
    },
    "group": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional SoQL group by, used with an aggregate in select, for example select=city,count(*) with group=city."
    },
    "limit": {
      "type": "integer",
      "default": 10,
      "maximum": 50,
      "minimum": 1,
      "description": "How many rows to return, 1 to 50. Defaults to 10."
    },
    "order": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional SoQL ordering, for example start_dt_utc DESC. Leave out for the portal's default order."
    },
    "where": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL filter, for example quadrant = 'SE'. Column names are those of the returned rows; an unknown column is refused as a validation error."
    },
    "offset": {
      "type": "integer",
      "maximum": 1000000,
      "minimum": 0,
      "description": "Rows to skip, for reading further pages in the order given by `order`. Leave out to start at the first row."
    },
    "select": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL select: a comma list of columns or expressions, for example incident_info,description,quadrant,start_dt_utc, or count(*) with group. Leave out for every column."
    },
    "dataset_id": {
      "type": "string",
      "pattern": "^[a-z0-9]{4}-[a-z0-9]{4}$",
      "description": "The dataset's 8-character id, two groups of four lowercase letters or digits joined by a hyphen, for example 35ra-9556. Find ids with the dataset-search tool or in a dataset's page address."
    }
  },
  "additionalProperties": false
}

Output schema

output_schema.json

{
  "type": "object",
  "required": [
    "results"
  ],
  "properties": {
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "description": "One entry per row; empty when the filter matches nothing. Columns, and their value types, are the dataset's own; computed region columns and geometry objects pass through unchanged."
    }
  },
  "description": "The rows the portal returned, in the portal's order.",
  "additionalProperties": true
}