Turn plain English into safe SQL in one flow

01 Hook

Analysts shouldn't need to remember JOIN syntax just to answer a simple question.

02 Context

Upgraded stack: React 19 + Vite + TypeScript frontend, FastAPI + Gemini SQL generation, Postgres with connection pooling.

03 Problem

Natural-language data access is useless if the model writes destructive SQL or the UI hides the query before it hits the database.

04 Insight

Trust comes from a visible, editable SQL step plus hard read-only enforcement — not from hiding the model behind a chat bubble.

05 Exploration

Added schema explorer, structured logging, /health (DB + Gemini), optional API key, Docker Compose, statement timeouts and row truncation.

06 Decision

Constrained the model to analytics/read-only queries and kept generation separate from execution so every query is inspectable.

07 Solution

Shipped Query-mint: prompt → SQL preview/edit → execute → table + history + CSV, with demo mode when no backend is wired.

08 Impact

Open repo with production-like local run path and safety rails recruiters can verify in the code.