`ofgem_dataset_rows`

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

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/ofgem_dataset_rows for the schema, then POST the same URL with its arguments for the data.

Return the full underlying table for one Ofgem Data Portal dataset as rows and columns — the numbers behind the published chart, not an image. Get the dataset id from ofgem_datasets. Use for “give me the monthly GB day-ahead gas price series”, “Ofgem supplier market share by year”. Sourced from Ofgem’s Data Portal. Example: ofgem_dataset_rows({ dataset_id: “qRvAxIgho”, limit: 12, latest_first: true })

Parameters

Name	Type	Required	Description
`dataset_id`	string	yes	Dataset id from ofgem_datasets, e.g. “qRvAxIgho”
`limit`	number	no	Maximum rows to return (default 50, max 1000; 0 returns every row)
`latest_first`	boolean	no	Return the last rows of the table first — these series run oldest-first (default false)

Example call

Arguments

{
  "dataset_id": "qRvAxIgho",
  "limit": 3,
  "latest_first": true
}

curl

curl -X POST https://gateway.pipeworx.io/ofgem/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ofgem_dataset_rows","arguments":{"dataset_id":"qRvAxIgho","limit":3,"latest_first":true}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('ofgem_dataset_rows', {
  "dataset_id": "qRvAxIgho",
  "limit": 3,
  "latest_first": true
});

Connect

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

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

See Getting Started for client-specific install steps.

ofgem_dataset_rows