Data Kingcounty

What Data Kingcounty does

Data Kingcounty exposes King County Open Data through MCP. The underlying catalog is hosted at data.kingcounty.gov and uses Socrata datasets. Agents can find datasets by keyword, inspect a dataset’s structure, and retrieve rows using a dataset resource ID.

The integration is independent and unofficial. It is delivered through Pipeworx, which provides both a scoped endpoint for this pack and a broader gateway endpoint covering additional data sources.

How it works

The hosted MCP endpoint is https://gateway.pipeworx.io/data-kingcounty/mcp. An MCP client connects to that URL and can call the pack’s three data tools. The datasets result supplies resource IDs, which are then used with metadata or query.

For clients without MCP support, Pipeworx also exposes HTTP tool endpoints. The dataset search tool can be called at https://gateway.pipeworx.io/v1/tools/data_kingcounty_datasets with a JSON POST request.

A local npm package, @pipeworx/mcp-data-kingcounty, acts as a stdio bridge. The client launches it with npx, and the bridge forwards requests to the hosted gateway, so it still needs network access and has no offline mode.

Setup and configuration

Add the hosted URL to an MCP client’s server configuration:

{
  "mcpServers": {
    "data-kingcounty": {
      "url": "https://gateway.pipeworx.io/data-kingcounty/mcp"
    }
  }
}

The local alternative uses:

{
  "mcpServers": {
    "data-kingcounty": {
      "command": "npx",
      "args": ["-y", "@pipeworx/mcp-data-kingcounty"]
    }
  }
}

Anonymous calls are limited to 50 per day. Setting PIPEWORX_API_KEY adds a Pipeworx account key and raises the allowance to 200 calls per day. The key is sent as a Bearer token. Set PIPEWORX_META_TOOLS=1 when the local bridge should also list Pipeworx gateway tools such as cross-catalog routing tools.

Tools and capabilities

• datasets searches the King County Open Data catalog by keyword and returns each matching dataset’s resource ID, name, description, category, and update date.
• metadata returns schema and catalog details for a resource ID, including columns, data types, row count, category, and last-updated information.
• query runs a Socrata SoQL query for a resource ID and returns matching rows as JSON. It accepts where, select, group, and order clauses without the leading $, along with limit and offset.
• ask_pipeworx and other shared gateway tools may appear on the hosted pack endpoint, in addition to the three Data Kingcounty tools. The local bridge lists only the pack tools unless meta-tools are enabled.

Limitations and notes

The service depends on network connectivity to the Pipeworx gateway and the King County data service. The npm bridge does not provide local or offline data access.

The pack endpoint includes shared Pipeworx meta-tools alongside its own tools, so an MCP client may report more tools than the three listed here. The connection’s initialization response determines the exact tool scope at connection time.

The integration is not affiliated with, endorsed by, or published by the upstream King County Open Data provider. When using an HTTPS proxy with the npm bridge, Node’s built-in fetch may require NODE_USE_ENV_PROXY=1 on supported Node versions to read proxy settings.