# elouansalaun/seao_mcp architecture

> Architecture diagram of the GitHub repository elouansalaun/seao_mcp, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-01). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/elouansalaun/seao_mcp
- Repository: https://github.com/elouansalaun/seao_mcp

## Overview

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`](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py) (Curated analyses), [`fetch_seao_opendata.py`](https://github.com/elouansalaun/seao_mcp/blob/main/fetch_seao_opendata.py) (Weekly fetcher), [`DATA`](https://github.com/elouansalaun/seao_mcp/tree/main/DATA) (Weekly OCDS files), [`build_raw_json_db.py`](https://github.com/elouansalaun/seao_mcp/blob/main/build_raw_json_db.py) (Security filter)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Data ingestion"]
  node_fetcher["Weekly fetcher"]
  node_weekly["Weekly OCDS files"]
  node_filter["Security filter"]
end

subgraph group_storage["Procurement data"]
  node_filtered["Filtered records"]
  node_normalizer["OCDS normalizer"]
  node_database[("SEAO SQLite")]
end

subgraph group_server["MCP server"]
  node_mcpserver["MCP server<br/>[seao_mcp_server.py]"]
end

subgraph group_analysis["Analysis tools"]
  node_flexible["Flexible tools<br/>[seao_mcp_server.py]"]
  node_schema["Schema lookup<br/>[seao_mcp_server.py]"]
  node_processsearch["Process search<br/>[seao_mcp_server.py]"]
  node_readonlysql["Read-only SQL<br/>[seao_mcp_server.py]"]
  node_curated["Curated analyses<br/>[seao_mcp_server.py]"]
  node_incumbent["Incumbent<br/>[seao_mcp_server.py]"]
  node_benchmark["Price benchmark<br/>[seao_mcp_server.py]"]
  node_supplier["Supplier profile<br/>[seao_mcp_server.py]"]
  node_headtohead["Head to head<br/>[seao_mcp_server.py]"]
  node_buyer["Buyer profile<br/>[seao_mcp_server.py]"]
  node_market["Market overview<br/>[seao_mcp_server.py]"]
end

node_analyst(("Analyst"))
node_llm(("LLM assistant"))
node_seao{{"SEAO open data"}}
node_answer["Sourced answer"]

node_analyst -->|"asks question"| node_llm
node_llm -->|"calls tools"| node_mcpserver
node_llm -->|"presents answer"| node_answer
node_seao -->|"provides feed"| node_fetcher
node_fetcher -->|"downloads files"| node_weekly
node_weekly -->|"reads files"| node_filter
node_filter -->|"writes records"| node_filtered
node_filtered -->|"reads records"| node_normalizer
node_normalizer -->|"builds database"| node_database
node_mcpserver -->|"queries read-only"| node_database
node_mcpserver -->|"offers tools"| node_flexible
node_flexible -->|"includes"| node_schema
node_flexible -->|"includes"| node_processsearch
node_flexible -->|"includes"| node_readonlysql
node_mcpserver -->|"offers analyses"| node_curated
node_curated -->|"includes"| node_incumbent
node_curated -->|"includes"| node_benchmark
node_curated -->|"includes"| node_supplier
node_curated -->|"includes"| node_headtohead
node_curated -->|"includes"| node_buyer
node_curated -->|"includes"| node_market
node_mcpserver -->|"formats tables"| node_answer

click node_fetcher "https://github.com/elouansalaun/seao_mcp/blob/main/fetch_seao_opendata.py"
click node_weekly "https://github.com/elouansalaun/seao_mcp/tree/main/DATA"
click node_filter "https://github.com/elouansalaun/seao_mcp/blob/main/build_raw_json_db.py"
click node_filtered "https://github.com/elouansalaun/seao_mcp/tree/main/DATA"
click node_normalizer "https://github.com/elouansalaun/seao_mcp/blob/main/build_work_sqlite_db.py"
click node_database "https://github.com/elouansalaun/seao_mcp/tree/main/DATA"
click node_mcpserver "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_flexible "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_schema "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_processsearch "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_readonlysql "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_curated "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_incumbent "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_benchmark "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_supplier "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_headtohead "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_buyer "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"
click node_market "https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_fetcher,node_weekly,node_filter toneBlue
class node_filtered,node_normalizer,node_database toneAmber
class node_mcpserver toneMint
class node_flexible,node_schema,node_processsearch,node_readonlysql,node_curated,node_incumbent,node_benchmark,node_supplier,node_headtohead,node_buyer,node_market toneRose
class node_analyst,node_llm,node_seao,node_answer toneIndigo
```

## Components

### Data ingestion

- [Weekly fetcher](https://github.com/elouansalaun/seao_mcp/blob/main/fetch_seao_opendata.py): `fetch_seao_opendata.py`
- [Weekly OCDS files](https://github.com/elouansalaun/seao_mcp/tree/main/DATA): `DATA`
- [Security filter](https://github.com/elouansalaun/seao_mcp/blob/main/build_raw_json_db.py): `build_raw_json_db.py`

### Procurement data

- [Filtered records](https://github.com/elouansalaun/seao_mcp/tree/main/DATA): `DATA`
- [OCDS normalizer](https://github.com/elouansalaun/seao_mcp/blob/main/build_work_sqlite_db.py): `build_work_sqlite_db.py`
- [SEAO SQLite](https://github.com/elouansalaun/seao_mcp/tree/main/DATA): `DATA`

### MCP server

- [MCP server](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`

### Analysis tools

- [Flexible tools](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Schema lookup](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Process search](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Read-only SQL](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Curated analyses](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Incumbent](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Price benchmark](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Supplier profile](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Head to head](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Buyer profile](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`
- [Market overview](https://github.com/elouansalaun/seao_mcp/blob/main/seao_mcp_server.py): `seao_mcp_server.py`

### Other components

- **Analyst**
- **LLM assistant**
- **SEAO open data**
- **Sourced answer**

## Connections

- Analyst → LLM assistant: asks question (evidence: `README.md`)
- LLM assistant → MCP server: calls tools (evidence: `README.md`)
- LLM assistant → Sourced answer: presents answer (evidence: `README.md`)
- SEAO open data → Weekly fetcher: provides feed (evidence: `fetch_seao_opendata.py`)
- Weekly fetcher → Weekly OCDS files: downloads files (evidence: `fetch_seao_opendata.py`)
- Weekly OCDS files → Security filter: reads files (evidence: `build_raw_json_db.py`)
- Security filter → Filtered records: writes records (evidence: `build_raw_json_db.py`)
- Filtered records → OCDS normalizer: reads records (evidence: `build_work_sqlite_db.py`)
- OCDS normalizer → SEAO SQLite: builds database (evidence: `build_work_sqlite_db.py`)
- MCP server → SEAO SQLite: queries read-only (evidence: `seao_mcp_server.py`)
- MCP server → Flexible tools: offers tools (evidence: `README.md`)
- Flexible tools → Schema lookup: includes (evidence: `README.md`)
- Flexible tools → Process search: includes (evidence: `README.md`)
- Flexible tools → Read-only SQL: includes (evidence: `README.md`)
- MCP server → Curated analyses: offers analyses (evidence: `README.md`)
- Curated analyses → Incumbent: includes (evidence: `README.md`)
- Curated analyses → Price benchmark: includes (evidence: `README.md`)
- Curated analyses → Supplier profile: includes (evidence: `README.md`)
- Curated analyses → Head to head: includes (evidence: `README.md`)
- Curated analyses → Buyer profile: includes (evidence: `README.md`)
- Curated analyses → Market overview: includes (evidence: `README.md`)
- MCP server → Sourced answer: formats tables (evidence: `README.md`)
