How elouansalaun/seao_mcp works
This repository provides an MCP server for asking sourced questions about Quebec security-service procurement, backed by a cleaned SQLite dataset. The data workflow fetches weekly SEAO records, filters them, and normalizes them; the analyst workflow sends questions through an LLM to flexible or curated tools and returns tabular answers. The README documents the major tools and pipeline; source excerpts confirm key filtering, database construction, and server behavior, but not every tool implementation.
Main entry points: seao_mcp_server.py Curated analyses · fetch_seao_opendata.py Weekly fetcher · DATA Weekly OCDS files · build_raw_json_db.py Security filter
Components 22
Data ingestion
- Weekly fetcher
fetch_seao_opendata.py - Weekly OCDS files
DATA - Security filter
build_raw_json_db.py
Procurement data
- Filtered records
DATA - OCDS normalizer
build_work_sqlite_db.py - SEAO SQLite
DATA
MCP server
- MCP server
seao_mcp_server.py
Analysis tools
- Flexible tools
seao_mcp_server.py - Schema lookup
seao_mcp_server.py - Process search
seao_mcp_server.py - Read-only SQL
seao_mcp_server.py - Curated analyses
seao_mcp_server.py - Incumbent
seao_mcp_server.py - Price benchmark
seao_mcp_server.py - Supplier profile
seao_mcp_server.py - Head to head
seao_mcp_server.py - Buyer profile
seao_mcp_server.py - Market overview
seao_mcp_server.py
Other components
- Analyst
- LLM assistant
- SEAO open data
- Sourced answer
Connections 22
- Analyst → LLM assistant: asks question
README.md - LLM assistant → MCP server: calls tools
README.md - LLM assistant → Sourced answer: presents answer
README.md - SEAO open data → Weekly fetcher: provides feed
fetch_seao_opendata.py - Weekly fetcher → Weekly OCDS files: downloads files
fetch_seao_opendata.py - Weekly OCDS files → Security filter: reads files
build_raw_json_db.py - Security filter → Filtered records: writes records
build_raw_json_db.py - Filtered records → OCDS normalizer: reads records
build_work_sqlite_db.py - OCDS normalizer → SEAO SQLite: builds database
build_work_sqlite_db.py - MCP server → SEAO SQLite: queries read-only
seao_mcp_server.py - MCP server → Flexible tools: offers tools
README.md - Flexible tools → Schema lookup: includes
README.md - Flexible tools → Process search: includes
README.md - Flexible tools → Read-only SQL: includes
README.md - MCP server → Curated analyses: offers analyses
README.md - Curated analyses → Incumbent: includes
README.md - Curated analyses → Price benchmark: includes
README.md - Curated analyses → Supplier profile: includes
README.md - Curated analyses → Head to head: includes
README.md - Curated analyses → Buyer profile: includes
README.md - Curated analyses → Market overview: includes
README.md - MCP server → Sourced answer: formats tables
README.md