MCP server

Data Oakland

io.github.pipeworx-io/data-oakland

Checked 26 Oct 2026, 08:29 UTC · Connected to it and listed its tools

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

Website Source

At a glance

Type

MCP server

Publisher

pipeworx.io (verified by the MCP Registry)

Status

Working at last check

Tools

45

Token cost

About 26,856 tokens per request

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code, Antigravity, ChatGPT, OpenAI API, Grok

Last checked

26 Oct 2026, 08:29 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. For other apps, copy the setup below.

Claude Code

claude mcp add --transport http data-oakland https://gateway.pipeworx.io/data-oakland/mcp

Claude Desktop

Settings → Connectors → Add custom connector, and paste the URL.

Codex (config.toml)

[mcp_servers.data-oakland]
url = "https://gateway.pipeworx.io/data-oakland/mcp"

Gemini CLI

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

Cursor

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

VS Code

{"servers":{"data-oakland":{"type":"http","url":"https://gateway.pipeworx.io/data-oakland/mcp"}}}

Antigravity

agy mcp add data-oakland https://gateway.pipeworx.io/data-oakland/mcp

ChatGPT

Settings → Apps & Connectors → Advanced settings: turn on Developer mode, then Create a connector and paste the URL. Which plans can do this varies.

OpenAI API (Responses tools)

{"type":"mcp","server_label":"data-oakland","server_url":"https://gateway.pipeworx.io/data-oakland/mcp","require_approval":"always"}

Grok (xAI API tools)

{"type":"mcp","server_label":"data-oakland","server_url":"https://gateway.pipeworx.io/data-oakland/mcp"}

Tools

• datasets ~175 tokens
  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.
• metadata ~106 tokens
  Get a Oakland Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "ym6k-rx7a".
• query ~272 tokens
  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.

Browse

• GitHub tools
• GitHub and code hosting
• Government and public data

Related MCP servers

• Socrata
  Search and query government open-data portals (Socrata SODA API).
• Dayplay
  Verified real-time places, events & walkable itineraries for AI agents nationwide. 40 tools.
• Data Calgary
  DataCalgary MCP — Calgary open data (data.calgary.ca, Socrata SODA API).
• Data Cambridge
  DataCambridge MCP — Cambridge open data (data.cambridgema.gov, Socrata SODA API).
• Data Dallas
  DataDallas MCP — Dallas open data (www.dallasopendata.com, Socrata SODA API).
• Data Edmonton
  DataEdmonton MCP — Edmonton open data (data.edmonton.ca, Socrata SODA API).
• Data Seattle
  DataSeattle MCP — Seattle open data (data.seattle.gov, Socrata SODA API).
• Data Austin
  DataAustin MCP — Austin, TX open data (data.austintexas.gov, Socrata SODA API).

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.pipeworx-io/data-oakland.svg)](https://aptlynx.net/servers/io.github.pipeworx-io/data-oakland)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents