Text-to-SQL AI (FastAPI)

Backend (Windows / PowerShell)

From the repo root:

cd .\text-to-sql-ai-app\backend
.\venv\Scripts\activate
pip install -r .\requirements.txt
python .\run.py

Then open http://127.0.0.1:8000/ (API routes are under /api).

Notes:

• If you run backend\app\main.py directly, you may get ModuleNotFoundError: No module named 'app'. Use python .\run.py (or python -m uvicorn app.main:app --reload) from backend\.

Free AI option (Ollama local)

1. Install Ollama for Windows, then in a terminal:

ollama pull qwen2.5:3b-instruct

2. In text-to-sql-ai-app\.env set:

LLM_PROVIDER=ollama
OLLAMA_MODEL=qwen2.5:3b-instruct

3. Restart the backend and call POST /api/ask with only a question.