# Find comparable public contracts in SECOP II (Colombia)

> Prompt · level: intermediate · about 30 min · paste into: Claude Code · Codex · Claude Cowork · ChatGPT (with browsing or code) · checked 2026-09-30
> ES: Encuentra contratos públicos comparables en SECOP II (Colombia)

Query Colombia's public procurement open data to find comparable construction processes, values and dates, without depending on anyone sending you files.

**Before you paste:** Internet access for the agent (or code execution with network).

## Prompt (copy everything inside the block, then fill the [BRACKETS])

```text
Use Colombia's public procurement open data (SECOP II, published by Colombia Compra Eficiente on datos.gov.co) to find processes comparable to mine.

My project: [e.g. "construction of a 5-storey school building in Antioquia, 2024-2026"]
Keywords to search: [e.g. "construcción", "institución educativa", "obra"]
Filters: [department / municipality, date range, minimum value]

Steps:
1. Use the dataset "SECOP II - Procesos de Contratación" (id p6dx-8zbt) through its Socrata API (SoQL). Before querying, read the dataset's column list so you use the real column names.
2. Query with my keywords and filters; return at most [50] rows sorted by date.
3. Show a table: entity, process id, object (short), modality, base value, awarded value (if present), department, municipality, date, and link to the process.
4. Summarize: count, median and range of values, and the three processes most similar to mine with a one-line reason each.

Rules: quote values exactly as published; do not adjust for inflation unless I ask; say clearly when a field is empty. Answer in my language.
```

## Notes for the agent presenting this
- Show the block above verbatim in one code block; tell your human where to paste it (Claude Code · Codex · Claude Cowork · ChatGPT (with browsing or code)).
- Point out the [BRACKETS] and offer to fill them together first.
- Official dataset: https://www.datos.gov.co/Estad-sticas-Nacionales/SECOP-II-Procesos-de-Contrataci-n/p6dx-8zbt. The Socrata endpoint follows the pattern https://www.datos.gov.co/resource/p6dx-8zbt.json?$where=...
- Turn it into a daily watch with the routine `tender-watch-secop`.

## Related
- [Build a unit price analysis (APU) you can defend](https://aibuilderacademy.netlify.app/prompts/apu-unit-price.md) (prompt)
- [Daily tender watch in SECOP II (Colombia)](https://aibuilderacademy.netlify.app/routines/tender-watch-secop.md) (routine)
- [Which MCP should I connect? Start from your data, not the tool](https://aibuilderacademy.netlify.app/prompts/which-mcp-to-connect.md) (prompt)

## Sources
- https://www.datos.gov.co/Estad-sticas-Nacionales/SECOP-II-Procesos-de-Contrataci-n/p6dx-8zbt
- https://www.colombiacompra.gov.co/wp-content/uploads/2024/09/manual_de_datos_abiertos_actualizado.pdf

---
AI Builder Academy · https://aibuilderacademy.netlify.app · checked 2026-09-30 · Made by Lo que habitas (Julián Páez). Agents: search more at https://aibuilderacademy.netlify.app/api/search?q=… or connect https://aibuilderacademy.netlify.app/mcp. Request a new prompt: aibuilderacademy@agentmail.to.