PrismAnalyst

Key Features:

• Multi-Agent AI Chat: Specialized agents for sales analysis, inventory/assortment insights, and deep statistical analysis — routed automatically by a supervisor agent that understands your intent
• Natural Language Queries: Ask questions like "What are my top 10 SKUs by revenue this quarter?" and get instant, SQL-verified answers with interactive charts
• Excel Add-In: Use PrismAnalyst directly inside Microsoft Excel — select a data range, push it as a dataset, chat with the AI, and pull results back into your spreadsheet. Supports SSO via Azure AD for enterprise deployment
• SQL-First Architecture: Every insight is backed by a real DuckDB SQL query you can inspect, audit, and reproduce. No hallucinated numbers — only verifiable, traceable analysis
• Privacy-Preserving Protocol: Raw data never leaves your infrastructure. The AI receives only table schemas and aggregated query results — not individual rows. Full audit trail for every insight generated
• Multi-Format Ingestion: Upload CSV, Excel (.xlsx/.xls), JSON, or Parquet files. LLM-guided header/footer detection handles messy enterprise spreadsheets with merged cells and inconsistent formatting
• Advanced Analytics: Regression forecasting, anomaly detection via IQR, Pareto analysis, statistical correlation, and window-function segmentation — all executed as native SQL
• Interactive Charts: Auto-generated bar, line, and pie charts from query results with null-value handling for sparse datasets and projected vs. actual visualizations
• Streaming Responses: Server-sent events deliver sub-3-second responses with real-time routing decisions and SQL query transparency before results

Architecture:

• LangGraph multi-agent orchestration with StateGraph and Command pattern
• DuckDB in-memory analytics engine (per-tenant isolation)
• Multi-LLM support: OpenAI, Anthropic Claude, Azure OpenAI, and Ollama for on-premises deployment
• NestJS 11 backend with PostgreSQL (schema-per-tenant) and Redis/BullMQ
• Next.js 15 frontend with React 19 and Recharts visualization
• Safety guardrails: SELECT-only queries, automatic LIMIT injection, PII detection, and query timeout enforcement

Best for: Sales teams, retail operations, finance departments, and any organization that needs instant, trustworthy answers from their data without hiring dedicated analysts or SQL engineers.