Analytics
NukeAnalytics
A SQL workbench over the PRIS reactor database — write real queries in the browser, then turn the result into charts and dashboards without exporting to a spreadsheet.
- Role
- Creator & maintainer
- Period
- 2023 — present
The problem
Database access is a privilege, not a default. The questions people actually wanted to ask about reactor fleets required either a database client, credentials, or a request to whoever held them — and most of those questions were never asked at all.
The approach
NukeAnalytics gives the browser a SQL Lab with a read-only, sandboxed connection to PRIS. The constraint is the feature: you can explore freely, but you cannot mutate the source.
A result set is not a dead end. Any query can be promoted into a chart or a dashboard panel, which is how an exploratory query becomes a shared artefact instead of a screenshot in a chat message.
Dashboards compose saved queries, so the recurring questions are answered by the system rather than by the person who happened to write the SQL first.
Engineering highlights
Read-only by construction
The SQL Lab runs against a restricted role. Exploration is encouraged; the source data is never in reach.
Query to dashboard in one step
Promoting a result into a chart keeps the query attached to it, so a dashboard panel can always be traced back to the SQL that produced it.
At a glance
- Data source
- PRIS
- Access
- Read-only sandbox
Stack
- TypeScript
- Python
- SQL
- PostgreSQL