Canner/WrenAI ? reverse-engineered prompt

I want to build a generative BI tool that lets my team ask questions about our databases in plain English. The idea is that anyone, even non-technical folks, can just type a question like "show me our top 10 customers by revenue last quarter" and get back an accurate answer with a chart.

The most important part is that the AI's answers have to be trustworthy. We need a way to define our business logic—like what counts as "revenue" or an "active user"—so the generated SQL is always correct and isn't just a guess. The tool should be able to connect to multiple data sources like PostgreSQL, Snowflake, and BigQuery. It also needs to be flexible, letting us plug in different LLMs from OpenAI, Anthropic, or even a local one using Ollama.

Please build it with a clean web UI for asking questions and viewing the charts and insights. It should be fully self-hostable, so package the whole thing to run with Docker.