A side-by-side look at the Data Ny and Data Oakland MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Data Ny for data platforms work as a local process; choose Data Oakland for data platforms as a local process. You can also run both side by side in one mcpServers block.
datasets, query, metadata.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Data Platforms | Data Platforms |
| Quality signal | 41/100 · Fair | 52/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | Not declared |
| Pricing | Not declared | Not declared |
| Required env vars | None listed | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 1 | 0 |
| Directory activity | 3 views 0 installs 0 upvotes | 0 views 0 installs 0 upvotes |
| Tools | Not listed | 3 |
| Full listing | View Data Ny | View Data Oakland |
No tool names declared yet. Check the project README from the listing page.
datasetsSearch 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.queryRun 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.metadataGet a Oakland Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "ym6k-rx7a".Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
{
"mcpServers": {
"data-ny": {
"command": "npx",
"args": [
"-y",
"@pipeworx/mcp-data-ny"
]
}
}
}
{
"mcpServers": {
"data-oakland": {
"command": "npx",
"args": [
"-y",
"@pipeworx/mcp-data-oakland"
]
}
}
}