In-depth architectural comparison of the Data Providence and Datos Co 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 Providence
Data Platforms · Remote HTTP/SSE
Quality: 49/100 (Fair) | Auth: No auth required
Datos Co
Data Platforms · Remote HTTP/SSE
Quality: 51/100 (Good) | Auth: No auth required
Verdict Summary: Choose Data Providence if you need specialized Data Platforms tools running via a hosted cloud SSE transport. Choose Datos Co if your workspace requires Data Platforms integration with remote web transport. Both servers can be configured concurrently in your client's mcpServers manifest.
Which MCP Server Should You Choose?
Choose Data Providence when:
You need dedicated capabilities in the Data Platforms domain.
You prefer remote streaming HTTP/SSE transport architecture.
Your security boundary fits: No auth required (Free / Open Source).
Search the Providence 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 Providence Open Data dataset by resource_id (e.g. "vank-fyx9"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.
metadata
Get a Providence Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "vank-fyx9".
Datos Co Tools (3)
search_datasets
Search datasets published on Colombia's open-data portal datos.gov.co. Returns each dataset's Socrata 4x4 id (e.g. "gt2j-8ykr"), name, and description (Spanish). Use the id with dataset_columns and query_dataset. Query terms can be Spanish or English (e.g. "covid", "presupuesto", "contratos").
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 Providence is categorized under Data Platforms and uses a remote streaming HTTP/SSE transport. In contrast, Datos Co belongs to Data Platforms using remote streaming HTTP/SSE transport. Select Data Providence when you need capabilities focused on data platforms and Datos Co when you require tools for data platforms.
List the columns of a datos.gov.co dataset: field name (used in SoQL $select/$where), human label, and data type. Call this before query_dataset so you know which fields exist. datasetId is the Socrata 4x4 code from search_datasets.
query_dataset
Query rows from a datos.gov.co dataset using SoQL. datasetId is the Socrata 4x4 code from search_datasets. SoQL clauses: $select (columns / aggregates like "count(*)"), $where (SQL-like filter, e.g. "departamento_nom='BOGOTA' AND edad > 60"), $order ("count desc"), $group, $q (full-text across the…