CASE 1 · TEXT + VECTOR SEARCH + SQL
Brazilian public procurement, searched three ways
Every notice published on PNCP up to 2026-07-31, in one Postgres. Search by words, search by meaning with pgvector embeddings, or read the aggregate dashboard below. Values are shown as published.
POSTGRES FULL-TEXT
Text search
Matches the words of your query in the notice text, using Portuguese stemming.
PGVECTOR · 768-DIMENSION EMBEDDINGS
Semantic search
Finds notices with a similar meaning, even when they use different words. Ask in English or Portuguese.
Aggregate dashboard
Want to build your own questions? Open the full Metabase (opens in a new tab) with your account.
Where this comes from
- brazil-public-data-map (opens in a new tab)
Release contracts, the privacy gate, the pipelines and the ingestion notebook for the PNCP API.
- rag-chat (opens in a new tab)
The search interface and the retrieval backend used above.
- Data map: PNCP
Every table and field of the PNCP datasets, with lineage and join keys.
- Kaggle: PNCP analytics (opens in a new tab)
The published semantic tables, with a SHA-256 manifest.