@pipeworx/idb

Connect: https://gateway.pipeworx.io/idb/mcp · Install: one-click buttons

Tools: 4

Inter-American Development Bank (IDB) project procurement — live bidding notices, contract awards, and a 5-multilateral-development-bank cross-debarment check, all sourced from IDB’s keyless CKAN open-data portal.

Tools

• idb_search_notices(...) — search live IDB procurement notices (bids, expressions of interest, general/specific notices, award notifications) across 26 LAC countries; defaults to open (deadline not passed) notices.
• idb_get_notice(notice_id) — full record for one notice.
• idb_search_awards(...) — search ~159k awarded IDB project contracts by country, firm, sector, or year.
• idb_check_mdb_debarment(name, ...) — check a name against IDB’s own debarment list plus the cross-debarment lists of the World Bank Group, Asian Development Bank, African Development Bank, and EBRD (one shared feed answering “is this vendor debarred” across five banks).

Auth

Keyless.

Data sources

• https://data.iadb.org/dataset/project-procurement-bidding-notices-and-notification-of-contract-awards — bidding notices + award notifications (~37,000 rows).
• https://data.iadb.org/dataset/idb-project-procurement-contract-awards-data — award-level contract detail (~159,000 rows; the dataset page offers a ~70MB CSV, but the same data is exposed via CKAN’s Datastore, so every tool here queries it live with server-side SQL rather than downloading the file).
• https://data.iadb.org/dataset/dataset-of-sanctioned-firms-and-individuals — IDB debarment + WBG/ADB/AfDB/EBRD cross-debarment (~1,300 rows).

All three are queried through data.iadb.org/api/3/action/datastore_search_sql (CKAN Datastore, keyless, no auth). Notes for anyone touching this pack:

• Every resource here is CKAN Datastore-active — package_show on each dataset reports datastore_active: true, which is what makes live SQL querying possible instead of downloading and caching the 70MB awards file ourselves. Check datastore_active before assuming a new IDB dataset needs downloading.
• The plain /files/download/<id> URLs sit behind an AWS WAF bot challenge (HTTP 202, x-amzn-waf-action: challenge, on a bare request) — irrelevant here since nothing calls them, but don’t reach for them if extending this pack; the Datastore API is unaffected.
• The upstream’s own full-text search (q= on datastore_search) is accent-SENSITIVE. q=Gonzalez (unaccented) returns zero rows against a debarment table full of “González” (with the accent) — verified live. idb_check_mdb_debarment never uses q=; it fetches the whole (small, ~1,300-row) debarment table and matches client-side with NFD-normalized, diacritic-stripped, token-substring comparison.
• type in the notices table has inconsistent trailing whitespace — SELECT DISTINCT "type" returns "AWARD", "AWARD ", and "AWARD " as three separate values. Always TRIM() before comparing, and match with a prefix ILIKE, never =.
• datastore_search_sql has no bind-parameter support — every string argument is quote-escaped (' → '') before interpolation. CKAN’s SQL endpoint itself only accepts SELECT statements against a read replica.
• Many idb-project-procurement-contract-awards-data rows record awarded_firm_name as "Not Available" — this is by design for individual-consultant selections (contract_type: "Individual Consultants"), not a data gap.

Tools

• idb_search_notices — Search Inter-American Development Bank (IDB) project procurement notices — live bidding notices, expressions of interest, general/specific procurement notices, and contract-award notifications for IDB
• idb_get_notice — Fetch one IDB procurement notice by its notice id (from idb_search_notices results). Returns the full record: project, loan number, sector, procurement method, publication date, deadline, and the docu
• idb_search_awards — Search Inter-American Development Bank (IDB) contract award data — which firms and individual consultants were awarded contracts under IDB-financed projects, with contract amount, sector, borrower cou
• idb_check_mdb_debarment — Check whether a person or firm name appears on the multilateral development bank cross-debarment list — IDB’s own debarment/sanctions list PLUS the cross-debarred lists of the World Bank Group, Asian