datastore_query
Pack: jersey-opendata · Endpoint: https://gateway.pipeworx.io/jersey-opendata/mcp
Read actual table rows from a Jersey resource via CKAN datastore_search. Works only for resources with datastore_active=true (get the resource_id from dataset_details). Returns parsed records plus field definitions — e.g. population projections by Year/Age/Sex.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
resource_id | string | yes | Resource UUID from dataset_details, e.g. “6e222cd7-d296-429a-abea-09001dcc45f6”. |
q | string | no | Full-text filter across the table. |
filters | object | no | Exact-match column filters, e.g. {“Sex”:“F”,“Year”:2025}. |
limit | number | no | Max rows, 1-32000 (default 100). |
offset | number | no | 0-based row offset for paging. |
Example call
curl -X POST https://gateway.pipeworx.io/jersey-opendata/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"datastore_query","arguments":{}}}'Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"jersey-opendata": {
"url": "https://gateway.pipeworx.io/jersey-opendata/mcp"
}
}
}See Getting Started for client-specific install steps.