● Live on Vercel

Ask Questions.
Get Dashboards.

PyroBI is a next-generation Conversational BI platform. Drop a CSV, ask in plain English, and receive production-grade SQL, interactive visualizations, and AI executive summaries—instantly.

8
AI Agents
in the pipeline
< 3s
Response
avg query time
100%
No-Code
pure natural language

The Command Center

Drag, resize, and pin charts into your own custom analytical workspace—all from a single conversational prompt.

1. DATA (Schema)
2. QUERY (Chat)
3. DASHBOARD
CLAIMS BY REGION
MONTHLY TREND
SECTOR SPLIT
Total Claims
₹ 14.8B
+12.4% YoY
v1.0 — NLP Pipeline & Core Architecturev1.1 — Detailed Analysis & Report Builderv1.2 — RapidFuzz Normalization Enginev1.3 — CAGR SQL Accuracy & Prompt Tuningv1.4 — WRatio Fuzzy Logic Overhaulv1.5 — PDF Report Presentation Enginev1.6 — Premium Data Onboardingv1.7 — Cloud Hardening & Multi-User Authv1.8 — Drag-and-Drop Dashboard Gridv1.0 — NLP Pipeline & Core Architecturev1.1 — Detailed Analysis & Report Builderv1.2 — RapidFuzz Normalization Enginev1.3 — CAGR SQL Accuracy & Prompt Tuningv1.4 — WRatio Fuzzy Logic Overhaulv1.5 — PDF Report Presentation Enginev1.6 — Premium Data Onboardingv1.7 — Cloud Hardening & Multi-User Authv1.8 — Drag-and-Drop Dashboard Grid

Eight features.
One platform.

Every feature is engineered for a specific pain point in the enterprise BI workflow—from data onboarding to executive reporting.

Conversational Agent Pipeline

A multi-agent MoE: Router → SQL Generator → Chart Configurator. Powered by Groq's llama-3.3-70b with automatic model cascade fallback.

Interactive Dashboard Grid

Built on react-grid-layout. Drag, resize, and pin charts into a fully custom analytical workspace with contextual AI sidebar.

DuckDB Analytical Engine

Lightning-fast in-memory SQL execution over uploaded CSVs. Zero setup, zero servers—just pure analytical horsepower.

Fuzzy Data Normalization

RapidFuzz WRatio algorithm + custom acronym detector merges dirty entities automatically. 'Met Life' == 'Metlife' with 96% confidence.

Multi-User Cloud Security

Anonymous browser fingerprinting (X-User-ID) with UUID-namespaced DuckDB tables. Complete tenant isolation—zero data leakage.

Board-Ready PDF Export

Redis-persisted sessions survive cloud restarts. One-click export generates proportionally scaled charts + AI summaries across pages.

Premium Data Onboarding

Animated 3-step onboarding: Uploading → Analyzing → Profiling. Interactive schema editor for real-time data type casting.

Zero-LLM Anomaly Detection

Native DuckDB SQL profiling flags missing data, outliers, and type mismatches (>20% null). Protects analysis before it starts.

CSV to Dashboard
in 4 Steps.

01

Drop Your CSV

Drag and drop any dataset. PyroBI instantly profiles schema, auto-casts types, and runs fuzzy normalization on dirty entity names.

02

Ask in Plain English

Type any analytical question. The Router Agent classifies intent, the SQL Generator writes DuckDB-dialect SQL, and executes it against your data.

03

Get Instant Insights

Apache ECharts renders the optimal visualization. A dedicated Summarizer Agent writes the executive insight in one sentence.

04

Build & Export

Pin charts to your dashboard, drag them into position, continue the conversation, then export a board-ready PDF with one click.

Mixture-of-Experts
Agent Pipeline.

Six specialized AI agents, each owning a discrete responsibility in the pipeline. No monolith. No prompt bloat. Pure signal.

Router Agent
Classifies intent: KPI, Trend, Comparison, or Filter.
SQL Generator
Writes precise DuckDB SQL incl. CAGR, window functions.
Chart Configurator
Dynamically generates optimal Apache ECharts config.
Insight Summarizer
Writes 1-sentence executive summaries from raw data.
Detailed Analyzer
Deep textual analysis behind charts for report decks.
Dashboard Chat
Contextual memory — follow-up filters across all widgets.
Model Cascade Strategy
llama-3.3-70b
Primary — Best Quality
llama-3.1-70b
Fallback 1 — Rate Limit Hit
mixtral-8x7b
Fallback 2 — Always Available
CLOUD DEPLOYMENT
Vercel
Frontend CDN
Render
FastAPI Backend
Upstash Redis
Session Storage
Groq API
LLM Inference
— Technology Stack

Best-in-class
tools, assembled.

Every library was chosen deliberately—no npm bloat, no overhead. Pure signal from CSV to PDF.

Frontend
React 18 + Vite
State
Zustand
Viz
Apache ECharts
UI
react-grid-layout
Export
jsPDF + html2canvas
Styling
Tailwind CSS
Backend
FastAPI
Database
DuckDB
Data Eng.
Pandas
NLP
RapidFuzz
Cache
Redis (Upstash)
LLM
Groq AI
— Ready to Analyze?

From CSV.
To Dashboard.
In Seconds.

No SQL knowledge required. No dashboarding skills needed. Just ask your data a question and let PyroBI handle the rest.