`records`

Pack: opendatasoft · Endpoint: https://gateway.pipeworx.io/opendatasoft/mcp

Query records from an Opendatasoft dataset with optional keyword search, ODSQL WHERE/SELECT/GROUP BY/ORDER BY clauses, pagination, and projection; returns matching rows as JSON.

Parameters

Name	Type	Required
`dataset_id`	string	yes
`q`	string	no
`where`	string	no
`select`	string	no
`group_by`	string	no
`order_by`	string	no
`limit`	number	no
`offset`	number	no
`instance`	string	no

Example call

Arguments

{
  "dataset_id": "world-cities",
  "limit": 20
}

curl

curl -X POST https://gateway.pipeworx.io/opendatasoft/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"records","arguments":{"dataset_id":"world-cities","limit":20}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('records', {
  "dataset_id": "world-cities",
  "limit": 20
});

More examples

{
  "dataset_id": "us-census-data",
  "where": "population > 100000",
  "select": "name,population",
  "order_by": "population DESC",
  "limit": 50,
  "offset": 0
}

Response shape

Field	Type	Description
`results`	array	Array of record objects
`total_count`	number	Total count of matching records

Full JSON Schema

{
  "type": "object",
  "description": "Records from a dataset",
  "properties": {
    "results": {
      "type": "array",
      "description": "Array of record objects",
      "items": {
        "type": "object"
      }
    },
    "total_count": {
      "type": "number",
      "description": "Total count of matching records"
    }
  }
}

Connect

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

{
  "mcpServers": {
    "opendatasoft": {
      "url": "https://gateway.pipeworx.io/opendatasoft/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

records