# Data Kingcounty [Health: Active]

**Category:** 💻 Developer Tools  
**Repository:** https://github.com/pipeworx-io/mcp-data-kingcounty  
**GitHub Stars:** 0  
**npm Downloads (last month):** 1183  
**Views:** 1  
**Installs:** 0  
**Upvotes:** 0  
**Directory Page:** https://allmcps.com/mcp/data-kingcounty

## Description
King County Open Data (data.kingcounty.gov) Socrata MCP.

## Tools
Capabilities this server exposes over MCP:

- **datasets** — Search the King County 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 King County Open Data dataset by resource_id (e.g. "j56h-zgnm"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.
- **metadata** — Get a King County Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "j56h-zgnm".

## Claude Desktop Quick Installation
Install path detected from listing signals. Uses `npx` (confidence: high):

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

## Documentation

## 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:

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

The local alternative uses:

```json
{
  "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.

_Full upstream README: https://allmcps.com/mcp/data-kingcounty/readme_