QueryLens is a full-stack web app that helps SQL developers visualize and understand MySQL query execution plans using EXPLAIN .
Built with React, Express.js, MongoDB, and D3.js.
- 🔐 User login & signup system
- 📄 Input any valid MySQL query
- ⚙ Runs EXPLAIN and parses output
- 🌳 Interactive tree view of the execution plan using D3
- 🧾 Clean, readable JSON preview
- 🗂 Query history per user
- 🔄 Runs frontend and backend concurrently using npm run both
| JSON Preview | Tree View |
|---|---|
 |
|
|
| Layer | Tech |
|---|---|
| Frontend | React, TailwindCSS, D3.js |
| Backend | Express.js |
| Auth | JWT or session-based |
| Database | MongoDB (Auth, History), MySQL (Query Execution) |
| Utilities | concurrently, dotenv |
cd frontend
npm run both