seattle_query

Active

declared in 0.1.0

Run a raw SoQL query against any Seattle open-data resource (data.seattle.gov) by its Socrata id (8-char like "tazs-3rd5"). Full SoQL: where/select/group/order/limit/offset. Use seattle_datasets to find a resource id, or seattle_recent for the common ones.

Parameters schema

{
  "type": "object",
  "required": [
    "resource_id"
  ],
  "properties": {
    "group": {
      "type": "string",
      "description": "SoQL $group."
    },
    "limit": {
      "type": "number",
      "description": "Max rows (default 100, max 5000)."
    },
    "order": {
      "type": "string",
      "description": "SoQL $order (e.g. \"report_date_time DESC\")."
    },
    "where": {
      "type": "string",
      "description": "SoQL $where filter."
    },
    "offset": {
      "type": "number",
      "description": "Row offset for paging."
    },
    "select": {
      "type": "string",
      "description": "SoQL $select (e.g. \"offense, count(*)\")."
    },
    "_apiKey": {
      "type": "string",
      "description": "Optional — your own Socrata app token for higher rate limits. Omit to use the keyless endpoint."
    },
    "resource_id": {
      "type": "string",
      "description": "Socrata resource id, e.g. \"tazs-3rd5\" (crime data)."
    }
  }
}

What this tool wraps· 0 endpoints

min confidence0.70 0.50

No endpoints wrapped at confidence ≥ 0.50.

Parent server

Data Seattle

https://github.com/pipeworx-io/mcp-data-seattle

2/7 registries

View full server →