QueryLens

From Questions to Queries in Seconds!

Comment

🔍 QueryLens: See Data Clearly, Act Smartly!

🚀 Inspiration

Data analysis is often tedious and complex, requiring technical expertise in SQL and data visualization tools. We wanted to bridge the gap between data and insights by creating a complete data analytics suite that enables data scientists to query, analyze, and visualize data effortlessly.

⚡ What It Does

QueryLens is a comprehensive data analytics suite that offers:
✅ AI-powered NLP-to-SQL conversion – Ask questions in plain English, get SQL queries instantly.
✅ Advanced analytics & visualization – Generate insights, trends, and financial models.
✅ Regression & forecasting tools – Predict trends and make data-driven decisions.
✅ Decision Log feature – Track how queries are generated for better transparency.
✅ Interactive, professional UI – A sleek, dark-themed interface with collapsible widgets.

🛠 How We Built It

  • AI-Powered Query Generation: Uses Fine tuned GPT-4o-Mini to convert natural language into SQL. .
  • Streamlit-Based UI: Custom styling with SCSS, collapsible widgets, and smooth scrolling.
  • Database Support: Optimized for SQL-based databases like MySQL and PostgreSQL.

⚠️ Challenges We Ran Into

🔹 Handling ambiguous queries and refining NLP accuracy.
🔹 Optimizing SQL execution speed for large datasets.
🔹 Designing a scalable UI that balances functionality and simplicity.
🔹 Ensuring query transparency with the Decision Log feature.

🏆 Accomplishments That We're Proud Of

✅ Successfully integrated AI for accurate SQL generation.
✅ Designed a professional and intuitive UI.
✅ Developed a complete analytics suite with data visualization.
✅ Created an **efficient and transparent query processing system.

📖 What We Learned

📌 The importance of NLP fine-tuning for better query accuracy.
📌 How to optimize database performance using ORA Semantics for real-time analytics.
📌 Designing user-friendly data science tools that balance simplicity and power.
📌 How AI can bridge the gap between technical and non-technical users.

🚀 What's Next for QueryLens

🔹 Expanding AI capabilities – Improve query intent recognition.
🔹 Support for NoSQL databases – Expand beyond SQL-based systems.
🔹 Custom dashboards – Let users build and save visualizations.
🔹 Automated reports – Generate periodic insights and send them via email.
🔹 More ML-driven insights – Integrate anomaly detection and clustering models.

Built With

Share this project:

Updates