mohammadreza-mohammadi94/Text2SQL-Gemini ? reverse-engineered prompt

Build me a simple web app where I can type normal English questions and it turns them into SQL using Google Gemini, then runs that query on a small SQLite student database and shows me the answer on the page.

I want a clean Streamlit interface with a text box, a button to generate the query, and a results area that can show either a table or a single number like count or average. It should work with the student.db file, and if needed it can use the setup script to create or seed the database.

Please make it easy to run locally with a .env file for the Gemini API key and database path. If you need to check the latest Gemini or Streamlit docs, go ahead and look them up online. Also make sure the app handles basic errors nicely, like when the question can’t be converted or the SQL fails.