MCP server exposing 3 tools for data-pa.
This URL is a JSON-RPC 2.0 endpoint over HTTP. Issue POST requests with a JSON-RPC body. Browsers and search crawlers land here on GET.
POST https://gateway.pipeworx.io/data-pa/mcp
Content-Type: application/json
{"jsonrpc":"2.0","id":1,"method":"tools/list"}
datasets — Search the Pennsylvania Open Data catalog of open datasets by keyword. Returns each dataset's resource_id, name, description, category and update date — pass the resource_id to query/metadata.query — Run a Socrata SoQL query against a Pennsylvania Open Data dataset by resource_id (e.g. "mcba-yywm"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.metadata — Get a Pennsylvania Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "mcba-yywm".Code samples (curl / TypeScript / one-click client install), schemas, and the live playground are on the pack page:
https://pipeworx.io/packs/data-pa/
Pipeworx is an open MCP gateway connecting AI agents to live data. pipeworx.io