`query`

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

Run a Socrata SoQL query against a Bloomington Open Data dataset by resource_id (e.g. “yv82-z42g”). 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. “yv82-z42g” (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

Arguments

{
  "resource_id": "yv82-z42g",
  "where": "year >= 2020",
  "limit": 100
}

curl

curl -X POST https://gateway.pipeworx.io/data-bloomington/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{"resource_id":"yv82-z42g","where":"year >= 2020","limit":100}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('query', {
  "resource_id": "yv82-z42g",
  "where": "year >= 2020",
  "limit": 100
});

More examples

{
  "resource_id": "yv82-z42g",
  "select": "name, count(*) AS count",
  "group": "name",
  "order": "count DESC"
}

Connect

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

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

See Getting Started for client-specific install steps.

query