5 Commits

Author SHA1 Message Date
afc182292a feat: Media Agent Blocco A+B + Calendar Agent fix
Blocco A — Jellyfin Playback Agent (AyrKWvboPldzZPsM):
- Webhook PlaybackStart/Stop → behavioral_context + agent_messages
- Fix: JSON.parse Jellyfin body, SSL Patroni, Postgres queryParams inline

Blocco B1 — Media Library Sync (o3uM1xDLTAKw4D6E):
- Weekly cron: Radarr+Sonarr → GPT-4.1 → memory_facts + Qdrant
- Qdrant collection media_preferences creata (768-dim nomic-embed-text)

Blocco B2 — Jellyfin Watch History Sync (K07e4PPANXDkmQsr):
- Daily cron: Jellyfin history (90d) → GPT-4.1 → memory_facts
- Jellyfin API token Pompeo creato via admin auth

Calendar Agent fix (4ZIEGck9n4l5qaDt):
- Cleanup: filter(i=>i.json.uid) per evitare undefined non quotato in SQL
- Salva Evento: rimosso updated_at=NOW() (colonna non esistente)

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-03-21 18:51:11 +00:00
90d9faacca feat: Calendar Agent + IoT Agent design + DB migration
- Deployed Calendar Agent (n8n ID: 4ZIEGck9n4l5qaDt)
  - 12 Google Calendars via HA proxy, cron 06:30
  - GPT-4.1 batch classification -> memory_facts
  - Telegram daily briefing
- DB: added source_ref column + dedup index on memory_facts
- DB: created ha_sensor_config table (IoT Agent sensor allowlist)
  - 9 seed entries (Pixel 10, Pixel Watch, EY HP, Spotify, GPS)
- README: full IoT Agent design documentation
  - Sensor allowlist (regex), LLM-based activity inference
  - Three-layer data flow, confidence-gated clarification
- README: Calendar Agent design + workflow diagram
- README: updated infra table, ADR broker, credentials
- CHANGELOG: Calendar Agent milestone

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-03-21 13:45:12 +00:00
841d3a93f6 Add Actual Budget import + reminder workflows to README
- 💰 Actual — Import Estratto Conto [Telegram] (qtvB3r0cgejyCxUp)
-  Actual — Reminder Estratto Conto [Schedule] (w0oJ1i6sESvaB5W1)
- 📄 Paperless — Upload Documento [Multi] (GBPFFq8rmbdFrNn9)
- Retired Upload Bolletta [Email] and Upload Documento [Telegram]
- Added Google Calendar credential to table (ZIVFNgI3esCKuYXc)

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-03-21 12:22:39 +00:00
adb36c0c48 feat: Phase 0 bootstrap — Qdrant deploy e schema PostgreSQL
- README.md: contesto ALPHA_PROJECT, architettura multi-agent, stack infrastrutturale
- CHANGELOG.md: documenta deploy Qdrant v1.17.0 e creazione database pompeo
- db/postgres.sql: schema DDL database pompeo (user_profile, memory_facts,
  finance_documents, behavioral_context, agent_messages) con multi-tenancy user_id
- db/qdrant.sh: script per creazione/ripristino collections Qdrant
  (episodes, knowledge, preferences) con payload indexes

Design decisions:
- Multi-tenancy via user_id su Qdrant e PostgreSQL (estendibile a nuovi utenti
  senza modifiche infrastrutturali)
- agent_messages come blackboard persistente per il Proactive Arbiter

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-03-21 10:55:39 +00:00
e257a6795f docs: add ALPHA_PROJECT system context 2026-03-21 00:10:52 +01:00