krishnaniaakash2468/ai_sql_analyst ? reverse-engineered prompt

Build me a local AI data analyst app that lets me ask questions in plain English about a SQL Server database and get back the answer in a chat style interface.

I want it to connect to my local SQL Server instance, inspect the schema, turn my questions into SQL, run the query, and then explain the results in simple language. A Streamlit front end would be great, and if it makes sense, also keep a small command line version for testing the same workflow. Use Gemini through its API for the LLM part, and keep everything set up so I can fill in my own database and API details through an env file.

The app should work well for a tourism style database with a few tables, and it should show the returned rows clearly so I can trust what it found. If you need to check current docs or best practices online while building it, go ahead.