open-source · since 2026-09-15
E-commerce Analytics Copilot
kejunli-mi
MIT-licensed, Olist-specific analytics stack combining DuckDB views, a metric semantic layer, dashboards and a deterministic natural-language router that selects allowlisted SQL templates rather than generating arbitrary SQL.
Verified 2026-09-15. Repository includes implementation, semantic-layer config, DuckDB views, dashboard, 14 tests and a committed 50-question offline evaluation. Reported results: 98.0% intent accuracy, 97.8% answer/SQL execution accuracy and 100% blocking on five destructive requests, versus 24.4% answer accuracy for a keyword baseline. Important boundary: deterministic semantic routing over fixed SQL templates, not a general-purpose LLM or unconstrained text-to-SQL system; evaluation questions and routing rules are managed together, so scores are regression evidence rather than generalization evidence. Olist data is not redistributed. At verification: 0 stars, 0 forks, no tagged release.