query
Pack: data-ny · Endpoint: https://gateway.pipeworx.io/data-ny/mcp
SoQL query on a single resource.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
resource_id | string | yes | Socrata 4x4, e.g. “xj2p-gjci” |
where | string | no | SoQL WHERE clause (without “WHERE”). |
select | string | no | |
group | string | no | |
order | string | no | |
limit | number | no | |
offset | number | no |
Example call
curl -X POST https://gateway.pipeworx.io/data-ny/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{}}}'Response shape
Full JSON Schema
{
"type": "array",
"description": "Array of rows returned from SoQL query",
"items": {
"type": "object",
"description": "Row object with column values"
}
}Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"data-ny": {
"url": "https://gateway.pipeworx.io/data-ny/mcp"
}
}
}See Getting Started for client-specific install steps.