`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

Arguments

{
  "resource_id": "6e222cd7-d296-429a-abea-09001dcc45f6",
  "limit": 100
}

curl

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":{"resource_id":"6e222cd7-d296-429a-abea-09001dcc45f6","limit":100}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('datastore_query', {
  "resource_id": "6e222cd7-d296-429a-abea-09001dcc45f6",
  "limit": 100
});

More examples

{
  "resource_id": "6e222cd7-d296-429a-abea-09001dcc45f6",
  "filters": {
    "Year": 2025,
    "Sex": "F"
  },
  "limit": 50
}

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.

datastore_query