🔎 InsightSQL

Natural Language to SQL Analytics Agent

InsightSQL is an AI-powered analytics application that enables users to query a relational e-commerce database using natural language.

Instead of manually writing SQL queries, users can ask questions such as:

"What are the top 5 product categories by revenue?"

The system uses Google Gemini to interpret the user's question, generate a SQL query based on the database schema, execute the query through a controlled read-only SQL tool, and convert the resulting data into a concise natural-language response.

The project demonstrates the integration of Generative AI, Natural Language Interfaces, SQL, Relational Databases, Data Analytics, and SQL execution security in an agent-based architecture.

---

Overview

Traditional database analytics requires users to understand SQL and the underlying database schema.

InsightSQL provides a natural-language interface over a relational database:

Natural Language Question
          │
          ▼
   Google Gemini
          │
          ▼
    SQL Generation
          │
          ▼
   SQL Safety Layer
          │
          ▼
    SQLite Database
          │
          ▼
     Query Result
          │
          ▼
   Gemini Interpretation
          │
          ▼
   Natural Language Answer