AI Analytics Dashboard
Natural language → SQL query engine
// overview
About this project
Write questions in plain English and get instant SQL queries with chart visualizations. Claude API converts NL to SQL, executes against MySQL, and renders interactive Chart.js graphs.
📊 91%
Query Accuracy
📊 8+
Chart Types
📊 <2s
Avg Query Time
// tech_stack
Technologies used
React
Claude API
MySQL
Node.js// features
What it does
- 01
Plain-English query input converted to SQL via Claude API
- 02
Schema-aware context: tables, columns, and relationships auto-injected
- 03
Interactive charts: bar, line, pie, scatter with Chart.js
- 04
Query history with one-click re-run and version comparison
- 05
Multi-source support: MySQL and PostgreSQL connection strings
- 06
Export results to CSV and charts to PNG
// challenges_and_solutions
Challenges & Solutions
SQL Injection Prevention
Sandboxed all generated queries through a whitelist validator and parameterized runner — zero injection incidents across 10,000+ queries in production.
Schema-aware Query Accuracy
Dynamically fetched table schemas at session start and injected them as structured context in the Claude prompt — raising accuracy from 71% to 91%.
// screenshots
Visuals
// links
Project links
// related_projects
You might also like
Virtual Meeting Software
Real-time video conferencing & telemedicine platform
Next Project
ResumeIQ
AI-powered resume analyzer & optimizer