nola_query
Pack: data-nola · Endpoint: https://gateway.pipeworx.io/data-nola/mcp
Run a raw SoQL query against any New Orleans open-data resource (data.nola.gov) by its Socrata id (8-char like “4xwx-sfte”). Full SoQL: where/select/group/order/limit/offset. Use nola_datasets to find a resource id, or nola_recent for the common ones.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
resource_id | string | yes | Socrata resource id, e.g. “4xwx-sfte”. |
where | string | no | SoQL $where filter. |
select | string | no | SoQL $select. |
group | string | no | SoQL $group. |
order | string | no | SoQL $order. |
limit | number | no | Max rows (default 100, max 5000). |
offset | number | no | Row offset for paging. |
Example call
Arguments
{
"resource_id": "4xwx-sfte",
"where": "district = '6'",
"limit": 100,
"_apiKey": "your-data-nola-api-key"
}
curl
curl -X POST https://gateway.pipeworx.io/data-nola/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"nola_query","arguments":{"resource_id":"4xwx-sfte","where":"district = '\''6'\''","limit":100,"_apiKey":"your-data-nola-api-key"}}}'
TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('nola_query', {
"resource_id": "4xwx-sfte",
"where": "district = '6'",
"limit": 100,
"_apiKey": "your-data-nola-api-key"
});
More examples
{
"resource_id": "8g4p-7q6v",
"select": "zip_code, count(*) as count",
"group": "zip_code",
"order": "count DESC",
"limit": 20,
"_apiKey": "your-data-nola-api-key"
}
Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"data-nola": {
"url": "https://gateway.pipeworx.io/data-nola/mcp"
}
}
}
See Getting Started for client-specific install steps.