README.md

---
title: CSH2 DELPHI — Pump Analytics
emoji: ⚙️
colorFrom: yellow
colorTo: gray
sdk: docker
app_file: app.py
pinned: false
---

# CSH2 DELPHI -- Pump Analytics Dashboard

Interactive Streamlit dashboard for the CSH2 cryogenic hydrogen pump test platform.
Connects to TimescaleDB for real-time and historical sensor analytics across 74 sensors,
with LLM-powered diagnostic analysis via Claude API.

## Pages

1. **Data Explorer** -- Browse sensor time-series with NL query support (ask in plain English)
2. **Testing Cycles** -- Browse pre-computed pump test cycles with summary metrics
3. **Cycle Detail** -- Deep-dive into a single cycle with multi-sensor overlay plots
4. **Variation Analysis** -- LLM-powered analysis of within-cycle stabilizations and variations
5. **Cycle Comparison** -- Side-by-side comparison of two cycles with LLM diagnostic commentary
6. **Advanced Data Explorer** -- NL-to-SQL analytical pipeline with structured operation execution

## Secrets (Required)

Set these as Space Secrets in the HuggingFace Space settings:

| Secret | Description |
|--------|-------------|
| `DB_HOST` | TimescaleDB hostname |
| `DB_PORT` | Connection port |
| `DB_NAME` | Database name |
| `DB_USER` | Read-only database user |
| `DB_PASSWORD` | Database password |
| `ANTHROPIC_API_KEY` | Claude API key (optional -- pages 1-3 work without it) |

Without `ANTHROPIC_API_KEY`, the NL query parser (page 1), variation analysis (page 4),
cycle comparison (page 5), and advanced explorer interpretation (page 6) will show a
graceful fallback message. All data browsing and charting works without it.

## Architecture

- `core/config.py` -- Reads secrets from `st.secrets` (Streamlit Cloud / HF Spaces) first, falls back to `os.environ` / `.env`
- `core/db_connector.py` -- Singleton PostgreSQL connector with smart table routing (raw / 1sec / 15sec aggregates)
- `analysis/` -- LLM analyzer, NL-to-SQL parser, domain knowledge YAML retriever, cycle detection
- `ui/` -- Custom HUD-themed components, Plotly chart builders, CSS injection
- `pages/` -- Streamlit multi-page app (6 pages)

Built for Clear Skies Hydrogen (CSH2).