What Happens When You Create a Project?

1. The system saves your project name and reads the uploaded Excel file.
2. It extracts the table and column structure from the uploaded file.
3. Internally, it uses the following SQL query to understand your database structure:

   
   SELECT 
       table_name,
       GROUP_CONCAT(column_name ORDER BY ordinal_position SEPARATOR ',') AS columns
   FROM information_schema.columns
   WHERE table_schema = 'YourDatabaseName'
   GROUP BY table_name;
                   

   This helps AI understand how to generate accurate SQL queries for your data.
4. Your schema is saved securely in the system and used later when you ask questions like: “Show item name and quantity from item history”
5. Then, AI generates the appropriate SQL based on your prompt and the uploaded schema.