Dwitee&Dhanraj
Our project is an AI-powered Business Insights Copilot that connects to a live SQL Server database and lets users ask natural-language questions without writing SQL.
Core trick
Gemini translates natural-language questions into SQL run against a live SQL Server, then auto-selects charts for the results.
Description
Our project is an AI-powered Business Insights Copilot that connects to a live SQL Server database and lets users ask natural-language questions without writing SQL. Powered by Google Gemini 2.5 Flash through Google AI Studio, it converts queries into accurate SQL, executes them, and returns clear insights with visualisations.
The system offers an overview dashboard, a conversational SQL copilot, automatic charts, and a Schema Explorer to understand table relationships. Built with Streamlit and the Gemini API, it turns raw business data into an interactive, analyst-friendly insights platform.
README excerpt
# enterprise-ai-hack Smart AI assistant to get insights from the DB # Business SQL Insights Copilot Smart AI assistant to get insights from the DB. Our project is an **AI-powered Business Insights Copilot** that connects directly to a live SQL Server database and allows users to ask natural‑language questions about the business—no SQL knowledge required. Using **Google Gemini 2.5 Flash** through **Google AI Studio**, the system interprets user queries, generates accurate SQL, executes it on the database, and transforms the results into clear insights and visualisations. ## Key Features - **Automated overview dashboard** showing revenue, orders, customers, and top stock groups - **Conversational AI copilot** that answers business questions using Gemini‑generated SQL - **Automatic charts and tables** for every query result - **Schema Explorer** that shows tables and their relationships for better understanding of the data model ## Technology Stack - **Streamlit** for the interactive UI - **Google Gemini 2.5 Flash API** for natural‑language interpretation and SQL generation - **SQL Server (WideWorldImporters)** as the live transactional database Built with Streamlit and Gemini’s API, the solution turns raw SQL data into an interactive, intelligent, analyst‑friendly platform—ideal for business stakeholders who want fast insights without technical barriers.