Data Oakland

Name: Data Oakland
Author: pipeworx-io

by pipeworx-iocommunityv0.1.0

An MCP server for Oakland Open Data (data.oaklandca.gov) that lets clients search the dataset catalog, run Socrata SoQL queries, and fetch dataset metadata. It connects through the Pipeworx gateway to access Oakland open data resources.

From the registry: Oakland Open Data (data.oaklandca.gov) Socrata MCP.

GitHub Repository Website

Install & configure

Install in your client

Paste into the AI you're chatting with — it will figure out the rest

Please install the `data-oakland` MCP server into my current AI client (that's you).

Canonical MCP server config (HTTP transport):
- url: `https://gateway.pipeworx.io/data-oakland/mcp`

Note: README also mentions an alternative broader gateway at https://gateway.pipeworx.io/mcp for access to all Pipeworx data sources, but the server-specific endpoint is the canonical config for Data Oakland.

Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.

Note: README also mentions an alternative broader gateway at https://gateway.pipeworx.io/mcp for access to all Pipeworx data sources, but the server-specific endpoint is the canonical config for Data Oakland.

Tools (3)

datasets

Search the Oakland Open Data catalog of open datasets by keyword and return dataset resource_id, name, description, category, and update date.

query

Run a Socrata SoQL query against an Oakland Open Data dataset by resource_id and return matching rows as JSON.

metadata

Get a dataset's schema and metadata, including columns, types, row count, category, and last-updated time, by resource_id.

Remote Endpoints

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

type: streamable-http

Details

Language: TypeScript
License: MIT
Released: Jun 26, 2026
Last commit: Jun 26, 2026
Registry name: io.github.pipeworx-io/data-oakland

Related Servers

Labelhead Artist Momentum

Trending hip-hop artist momentum scores across four cultural dimensions.

74.7k

PostHog MCP Server

Official PostHog MCP Server for product analytics, feature flags, experiments, and more.

37.3k

Openmetadata Mcp

Official OpenMetadata MCP: governed context and business semantics for AI assistants and agents.

14.6k