feat: require live infrastructure for event store and inference, removing offline mode

fix: auto-load .env (Python) + normalize Neon postgres scheme for live mode

feat: env-gated Postgres event store via SQLAlchemy (layered)