In-depth architectural comparison of the Data Cityofchicago and Data Norfolk MCP servers. Compare execution transports, security boundaries, tool capabilities, quality scores, and ready-to-paste client installation snippets for Claude, Cursor, Windsurf, and VS Code.
At a Glance & Executive Verdict
Data Cityofchicago
Data Platforms · Local stdio
Quality: 40/100 (Fair) | Auth: No auth required
Data Norfolk
Data Platforms · Local stdio
Quality: 52/100 (Good) | Auth: No auth required
Verdict Summary: Choose Data Cityofchicago if you need specialized Data Platforms tools running via a local process. Choose Data Norfolk if your workspace requires Data Platforms integration with local subprocess execution. Both servers can be configured concurrently in your client's mcpServers manifest.
Which MCP Server Should You Choose?
Choose Data Cityofchicago when:
You need dedicated capabilities in the Data Platforms domain.
You prefer local stdio subprocess transport architecture.
Your security boundary fits: No auth required (Free / Open Source).
Primary tools included: Dataset catalogue search, SoQL queries with filtering and pagination, Resource metadata lookup.
Search the Norfolk 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.
Ready-to-Paste Client Configurations
Paste either (or both) of these JSON server blocks into your client config file (e.g. claude_desktop_config.json or ~/.cursor/mcp.json).
Data Cityofchicago is categorized under Data Platforms and uses a local stdio subprocess. In contrast, Data Norfolk belongs to Data Platforms using local stdio subprocess. Select Data Cityofchicago when you need capabilities focused on data platforms and Data Norfolk when you require tools for data platforms.
Run a Socrata SoQL query against a Norfolk Open Data dataset by resource_id (e.g. "cab7-wvn5"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.
metadata
Get a Norfolk Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "cab7-wvn5".