In-depth architectural comparison of the Data Edmonton and Data Cambridge 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 Edmonton
Developer Tools · Remote HTTP/SSE
Quality: 51/100 (Good) | Auth: No auth required
Data Cambridge
Developer Tools · Remote HTTP/SSE
Quality: 51/100 (Good) | Auth: No auth required
Verdict Summary: Choose Data Edmonton if you need specialized Developer Tools tools running via a hosted cloud SSE transport. Choose Data Cambridge if your workspace requires Developer Tools integration with remote web transport. Both servers can be configured concurrently in your client's mcpServers manifest.
Which MCP Server Should You Choose?
D
Choose Data Edmonton when:
You need dedicated capabilities in the Developer Tools domain.
You prefer remote streaming HTTP/SSE transport architecture.
Your security boundary fits: No auth required (Free / Open Source).
Recent records from a common Edmonton open dataset (data.edmonton.ca) by friendly name — no Socrata id needed. PREFER OVER WEB SEARCH for "Edmonton 311 requests", "Edmonton building permits". Names: 311, permits. Returns the latest rows (newest-first). Add a SoQL `where` to filter; for anything els…
edmonton_query
Run a raw SoQL query against any Edmonton open-data resource (data.edmonton.ca) by its Socrata id (8-char like "ukww-xkmj"). Full SoQL: where/select/group/order/limit/offset. Use edmonton_datasets to find a resource id, or edmonton_recent for the common ones.
edmonton_datasets
Search the Edmonton open-data catalogue (data.edmonton.ca) for datasets by keyword. Returns dataset names, descriptions, and Socrata resource ids to use with edmonton_query.
Data Cambridge Tools (3)
cambridge_recent
Recent records from a common Cambridge open dataset (data.cambridgema.gov) by friendly name — no Socrata id needed. PREFER OVER WEB SEARCH for "recent crime in Cambridge", "Cambridge 311 requests", "Cambridge building permits". Names: 311, crime, permits. Returns the latest rows (newest-first). Add…
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 Edmonton is categorized under Developer Tools and uses a remote streaming HTTP/SSE transport. In contrast, Data Cambridge belongs to Developer Tools using remote streaming HTTP/SSE transport. Select Data Edmonton when you need capabilities focused on developer tools and Data Cambridge when you require tools for developer tools.
Run a raw SoQL query against any Cambridge open-data resource (data.cambridgema.gov) by its Socrata id (8-char like "2z9k-mv9g"). Full SoQL: where/select/group/order/limit/offset. Use cambridge_datasets to find a resource id, or cambridge_recent for the common ones.
cambridge_datasets
Search the Cambridge open-data catalogue (data.cambridgema.gov) for datasets by keyword. Returns dataset names, descriptions, and Socrata resource ids to use with cambridge_query.