PostgreSQL and SQLx

Kafka is the stream; Postgres is the system of record for dashboard queries.

Schema

PostgresSchemaDiagram mirrors infra/docker/init-db.sql:

Table	Purpose
team_events	Enriched events with sentiment, risk_score
team_metrics	Rolled-up KPIs for cards

SQLx in analyzer

Queries are checked at compile time against the schema — typos fail CI, not production.

INSERT INTO team_events (id, source, payload_json, sentiment, risk_score)
VALUES ($1, $2, $3, $4, $5);

Teach-back prompt

Why not query Kafka directly from the dashboard?