Colombia Secop MCP server

@pipeworx/colombia-secop

Colombia SECOP MCP — Colombian government procurement (tenders and awarded contracts) from the keyless Socrata API at datos.gov.co.

Part of Pipeworx — an MCP gateway connecting AI agents to 1679+ live data sources.

Tools

• colombiasearchcontracts(query, entity, supplier, suppliernit, contracttype, include_unsigned, limit) — awarded contracts (SECOP II "Contratos electrónicos", dataset jbjy-vk9h). Returns contract id, object, entity + entity NIT, supplier + supplier NIT, SME flag, city, UNSPSC category, value and amount paid (COP), type, modality, status, signing date.
• colombiasearchprocesses(query, entity, contracttype, includeunpublished, limit) — tenders (SECOP II "Procesos de Contratación", dataset p6dx-8zbt). Returns process id, name, entity + entity NIT, base price, award value, awarded supplier, type, modality, status, publication date.

Auth

Keyless. _apiKey is optional — pass your own Socrata app token only if you want higher rate limits. There is no platform key and none is needed; a call with no token works.

Gotchas

Drafts share the table with real contracts, and they sort first. 424,153 contract rows have a NULL fechadefirma, and Socrata orders NULLs first on ORDER BY ... DESC. An unguarded "most recent" search therefore returns nothing but unsigned Borrador / enviado Proveedor rows. Both tools require the sort column to be non-NULL by default; includeunsigned / includeunpublished opt back in.

Use contracttype, not query, for a contract category. tipodecontrato is a clean 24-value facet (Obra ≈ 52k contracts against ≈ 5.1M Prestación de servicios). Passing "obra" as free text LIKE-matches service contracts that merely mention the word. The argument accepts the Spanish facet values and maps common English ones (works/construction → Obra, consulting → Consultoría, supplies → Suministros); an unrecognised value returns unknowncontract_type listing the valid set rather than a silent zero.

Text is published in Spanish. An English query matches nothing even when the data is present, so a zero-result response carries a hint saying so.

Socrata reports a throttle as 403 "Invalid apptoken specified". With no token sent that is the rate limit, not a credential problem — space the calls out and retry. If the caller did pass apiKey, the pack instead reports invalidapikey and tells them to drop the token, since the endpoint is keyless and retrying a bad token never succeeds.

documentoproveedor (supplier NIT) is the durable supplier key.** Names vary across filings; the NIT pins one company across every contract it holds. It reads "No Definido" on rows where SECOP has no value.

Data sources

• Contratos electrónicos: https://www.datos.gov.co/resource/jbjy-vk9h.json
• Procesos de Contratación: https://www.datos.gov.co/resource/p6dx-8zbt.json
• Portal: https://www.colombiacompra.gov.co/secop/secop-ii

Quick Start

Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):

{
  "mcpServers": {
    "colombia-secop": {
      "url": "https://gateway.pipeworx.io/colombia-secop/mcp"
    }
  }
}

What this endpoint actually serves

tools/list at https://gateway.pipeworx.io/colombia-secop/mcp returns the tools in the table above plus the shared Pipeworx meta-tools — askpipeworx, discovertools, search_within, remember/recall and the rest of the gateway-wide set. So the tool count you see is larger than this table: a single-pack endpoint currently lists roughly 30 shared tools alongside the pack's own. The connection's initialize response states its exact scope, and is the authoritative answer for a given day.

Shortened. The full README is on GitHub.