query
Pack: data-wa · Endpoint: https://gateway.pipeworx.io/data-wa/mcp
Run a Socrata SoQL query against a Washington State Open Data dataset by resource_id (e.g. “qxh8-f4bd”). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
resource_id | string | yes | Dataset id, e.g. “qxh8-f4bd” (from datasets). |
where | string | no | SoQL $where filter, e.g. “year >= 2020 AND status = ‘Active’”. |
select | string | no | SoQL $select, e.g. “name, count(*) AS n”. |
group | string | no | SoQL $group column(s). |
order | string | no | SoQL $order, e.g. “date DESC”. |
limit | number | no | Max rows (default Socrata 1000). |
offset | number | no | Pagination offset. |
Example call
curl -X POST https://gateway.pipeworx.io/data-wa/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{}}}'Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"data-wa": {
"url": "https://gateway.pipeworx.io/data-wa/mcp"
}
}
}See Getting Started for client-specific install steps.