Architecture

One question, end to end

Interface saved chatsquestion box Agent Claude, OpenAI failover schema docs cached 6 retry loop repo Querybackend SQL validationread only rolerate limit, timeout postgres raw verbatim feeds core standardized tables semantic agent reads here app users, billing repo ELT extract load transform source 1 source 2 source 3 third party feeds

A question enters on the left. The agent writes SQL, the backend validates it and runs it under a read only role, and the only schema it can read is semantic. The ELT pipeline feeds the same database from the right, so new data reaches the agent without anyone touching it.