Dhanraj-N-Banglurkar/nlp-to-sql ? reverse-engineered prompt

Reverse engineered prompt

Build me a simple Streamlit app that lets someone type normal English questions and turns them into SQL queries against a small SQLite cities database.

I want it to feel easy to use, with a clean input box, a button to run the query, and the results shown in a nice table. It should understand common things like filtering, counting, averaging, sorting, top N results, and simple comparisons, like asking for cities in a country, the biggest city, or the average population.

Please keep it safe and read only, so it only runs SELECT queries and blocks anything risky. I also want a query history panel so I can see past questions and run them again.

Use the existing Python setup, NLTK for the language parsing, and the SQLite database already in the project. If you need to check current Streamlit or NLTK docs online, go ahead.

Are you gonna build this?

make sure you review the code using coderabbit

Try freeSponsored — opens CodeRabbit in a new tab