CMHUSSAINX/ARL-Internship ? reverse-engineered prompt

Build me an AI assistant for a refinery that can answer two kinds of questions, one for documents like SOPs, manuals, and safety guides, and one for Oracle database data like production, inventory, suppliers, and staff info.

I want it to grow from a simple chat app into a hybrid assistant that can decide whether a question should use documents, the database, both, or just normal chat. It should give grounded answers, show the SQL it uses when it queries the database, and only allow safe read only queries. If a query fails, try to fix it and run it again.

Make the final version a clean web app with a dark industrial style, session memory, and clear visual feedback for whether it is using documents or the database. Use Python, FastAPI for the backend, and a simple browser interface. If you need current setup details for the libraries or models, look them up online first.