Upload spreadsheets, ask questions about your data in plain English, and get AI-generated charts, tables, and insights — no SQL knowledge required.
Overview
A conversational data analysis tool that turns spreadsheets into insights with natural language.
MetricMind is an AI-powered data and metrics assistant. Upload any CSV or Excel file, ask questions in plain English, and get instant answers with auto-generated charts, sortable data tables, and the SQL query behind each result.
Under the hood, your question is sent to an LLM (Google Gemini by default, with OpenAI and Anthropic also supported) along with the dataset schema. The LLM generates a SQL query, which is executed against an in-memory DuckDB analytical engine for blazing-fast results. It also picks the best chart type automatically — line charts for trends, bar charts for comparisons, pie charts for distributions, and scatter plots for correlations.
The app comes pre-loaded with three sample datasets — sales transactions, website analytics, and an employee survey — so you can start asking questions immediately without uploading anything.
Architecture
Two pipelines power MetricMind — one for data ingestion, one for querying.
Data Ingestion Pipeline
Query Pipeline (SSE Streaming)
Testing Walkthrough
Follow these 6 steps to explore every feature of MetricMind.
MetricMind comes with 3 seed datasets already loaded and ready to query. You'll see them in the sidebar when you open the app.
Select a dataset from the sidebar, then type a natural-language question in the chat input. MetricMind will generate a SQL query, run it, and display the results with a chart, table, and the generated SQL.
Each answer appears with three tabs you can switch between — Chart, Table, and Query. The chart is auto-selected for the best visualization. The table lets you sort and filter rows. The query tab shows exactly what SQL was generated.
The AI picks the best chart type based on your question. Try different questions to see bar charts, line charts, pie charts, and scatter plots.
After each answer, MetricMind suggests follow-up questions you can click to dive deeper into the data. This creates a natural conversation flow for data exploration.
Click the upload button in the sidebar and drag & drop a CSV or Excel file (up to 50 MB). It will be parsed, loaded into DuckDB, and ready to query immediately.
Features
Everything built into MetricMind.
Ask questions about your data in plain English. The AI converts your question to SQL and returns results instantly.
The AI automatically picks the best chart type — line for trends, bar for comparisons, pie for distributions, scatter for correlations.
Hover for tooltips, click legends to toggle series, and explore results across Chart, Table, and Query tabs.
In-memory analytical database for blazing-fast query execution. Supports window functions, CTEs, aggregations, and date formatting.
Server-Sent Events stream each processing step live — "Analyzing...", SQL generated, results rendered — for instant feedback.
Drag & drop CSV or Excel files up to 50 MB. Data is parsed, types inferred, and loaded into DuckDB instantly.
After each answer, the AI suggests relevant follow-up questions to help you explore your data deeper with one click.
Supports Google Gemini, OpenAI GPT-4o, and Anthropic Claude. Switch providers without changing any code.