MCP server exposing 3 tools for data-kcmo.
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-kcmo/mcp
Content-Type: application/json
{"jsonrpc":"2.0","id":1,"method":"tools/list"}kcmo_recent — Recent records from a common Kansas City, MO open dataset (data.kcmo.org) by friendly name — no Socrata id needed. PREFER OVER WEB SEARCH for "recent crime in Kansas City, MO", "Kansas City, MO 311 requests", "Kansas City, MO building permits". Names: 311, crime. Returns the latest rows (newest-first). Add a SoQL `where` to filter; for anything else use kcmo_query.kcmo_query — Run a raw SoQL query against any Kansas City, MO open-data resource (data.kcmo.org) by its Socrata id (8-char like "vsgj-uufz"). Full SoQL: where/select/group/order/limit/offset. Use kcmo_datasets to find a resource id, or kcmo_recent for the common ones.kcmo_datasets — Search the Kansas City, MO open-data catalogue (data.kcmo.org) for datasets by keyword. Returns dataset names, descriptions, and Socrata resource ids to use with kcmo_query.Code samples (curl / TypeScript / one-click client install), schemas, and the live playground are on the pack page:
https://pipeworx.io/packs/data-kcmo/
Pipeworx is an open MCP gateway connecting AI agents to live data. pipeworx.io