Mesa AZ Open Data: Dataset Rows by SoQL Query

mesaopendata/dataset-rows

Rows from any tabular dataset on the Mesa AZ Open Data (data.mesaaz.gov), chosen by its 8-character dataset id (for example dzpk-hxfb, Building Permits). 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 Mesa, Arizona data as served by Omnial; not an official City of Mesa 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

City of Mesa Open Data Portal (data.mesaaz.gov)

Data from the City of Mesa, Arizona, published on the City of Mesa Open Data Portal (data.mesaaz.gov). Attribute the publishing agency named in each dataset's metadata (for example Development Services) and honour that dataset's declared licence. Served by Omnial; not an official City of Mesa 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: "mesaopendata/dataset-rows" })

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

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "mesaopendata/dataset-rows", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "mesaopendata/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 24, 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=type_of_work,count(*) with group=type_of_work."
    },
    "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 issued_date DESC. Leave out for the portal's default order."
    },
    "where": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL filter, for example issued_date >= '2026-10-01T00:00:00'. 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 permit_number,property_address,status,type_of_work, 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 dzpk-hxfb. 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
}