Oakland Open Data

БесплатноНе проверен

Enables searching the Oakland Open Data catalog and querying datasets with Socrata SoQL. Provides access to metadata and rows from over 1000 live data sources v

автор: pipeworx-io

GitHub Embed

Описание

Enables searching the Oakland Open Data catalog and querying datasets with Socrata SoQL. Provides access to metadata and rows from over 1000 live data sources via Pipeworx.

README

Oakland Open Data (data.oaklandca.gov) Socrata MCP.

Part of Pipeworx — an MCP gateway connecting AI agents to 1000+ live data sources.

Tools

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

Quick Start

Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):

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

Or connect to the full Pipeworx gateway for access to all 1000+ data sources:

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

Using with ask_pipeworx

Instead of calling tools directly, you can ask questions in plain English:

ask_pipeworx({ question: "your question about Data Oakland data" })

The gateway picks the right tool and fills the arguments automatically.

License

MIT

from github.com/pipeworx-io/mcp-data-oakland

Установка Oakland Open Data

У этого сервера нет опубликованного пакета — он собирается из исходников. Открой репозиторий и следуй инструкции в README.

▸ github.com/pipeworx-io/mcp-data-oakland

FAQ