munther-hasan/scprs-warehouse-chat

SCPRS Warehouse Chat

Ask California's SCPRS procurement warehouse questions in plain English and get a short answer, the SQL behind it, and the underlying rows. Read-only, public data — no login. The natural-language→SQL step uses a free-tier LLM (Google Gemini); every query runs through a hardened read-only guard (single SELECT/WITH, connection opened ?mode=ro).

This Space is generated — do not edit here. Source lives in `scprs-analysis`; it's pushed via deploy/hf-chat/deploy.py. See docs/REMOTE_MCP.md there.

Configuration

Set one secret in Settings → Variables and secrets:

• —GEMINI_API_KEY — a free key from <https://aistudio.google.com/apikey>. With no billing account attached, the free tier rate-limits rather than charges.

Optional: GEMINI_MODEL to pin a specific model; otherwise the app asks the API which models the key can call and auto-selects a current flash model.