Problem
The ErikAI analysis engine (analyze_server, get_analysis_facts, compare_analysis, audit_config, etc.) only exists in Lite. Dashboard users get 57 MCP tools for raw data access but no inference engine, no scored findings, no drill-down analysis.
What's Needed
Port the analysis pipeline to the Dashboard's SQL Server backend:
DuckDbFactCollector → SqlServerFactCollector (query collect.* tables instead of DuckDB v_* views)
FactScorer, RelationshipGraph, InferenceEngine — portable as-is (no DuckDB dependency)
DrillDownCollector → SQL Server version querying collect.* and report.* views
FindingStore → SQL Server persistence (new table in config schema)
McpAnalysisTools → register in Dashboard McpHostService
Design Reference
See erikai-dashboard-port.md memory file for detailed port plan.
Dependencies
Problem
The ErikAI analysis engine (
analyze_server,get_analysis_facts,compare_analysis,audit_config, etc.) only exists in Lite. Dashboard users get 57 MCP tools for raw data access but no inference engine, no scored findings, no drill-down analysis.What's Needed
Port the analysis pipeline to the Dashboard's SQL Server backend:
DuckDbFactCollector→SqlServerFactCollector(querycollect.*tables instead of DuckDBv_*views)FactScorer,RelationshipGraph,InferenceEngine— portable as-is (no DuckDB dependency)DrillDownCollector→ SQL Server version queryingcollect.*andreport.*viewsFindingStore→ SQL Server persistence (new table inconfigschema)McpAnalysisTools→ register in DashboardMcpHostServiceDesign Reference
See
erikai-dashboard-port.mdmemory file for detailed port plan.Dependencies