Back to Browse
About
Oakland Open Data (data.oaklandca.gov) Socrata MCP.
Remote endpoints: streamable-http: https://gateway.pipeworx.io/data-oakland/mcp
Security Report
10.0
Low Risk10.0Low RiskValid MCP server (1 strong, 0 medium validity signals). No known CVEs in dependencies. Imported from the Official MCP Registry. Trust signals: trusted author (1012/1015 approved). 1 finding(s) downgraded by scanner intelligence.
33 tools verified · Open access · 1 issue found
Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.
Permissions Required
This plugin requests these system permissions. Most are normal for its category.
How to Connect
Remote Plugin
No local installation needed. Your AI client connects to the remote endpoint directly.
Add this to your MCP configuration to connect:
{
"mcpServers": {
"io-github-pipeworx-io-data-oakland": {
"url": "https://gateway.pipeworx.io/data-oakland/mcp"
}
}
}Documentation
View on GitHubFrom the project's GitHub README.
mcp-data-oakland
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.
More
License
MIT
Reviews
No reviews yet
Be the first to review this server!
More Developer Tools MCP Servers
Git
Freeby Modelcontextprotocol · Developer Tools
Read, search, and manipulate Git repositories programmatically
80.0K
Stars
6
Installs
6.5
Security
No ratings yet
Local
Fetch
Freeby Modelcontextprotocol · Developer Tools
Web content fetching and conversion for efficient LLM usage
80.0K
Stars
4
Installs
5.3
Security
No ratings yet
Local
Toleno
Freeby Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
137
Stars
523
Installs
8.0
Security
4.8
Local