canner/wrenai ? reverse-engineered prompt

Build me an open source AI powered business intelligence tool that can connect to a database and let users ask plain English questions to get trusted SQL answers, charts, and shareable dashboards.

I want it to feel safe and governed, so the app should use a semantic context layer for business definitions, approved joins, examples, and notes from docs or internal knowledge, instead of just guessing from the schema. It should support common warehouses and databases, at least Postgres and DuckDB to start, and be designed so more sources can be added later.

Make it usable from an agent or CLI first, with a smooth setup flow, then generate the SQL, validate it, and show the result clearly. If it makes sense, include a simple way to deploy dashboards that were generated from an answer. Look up current docs online if you need to, and build it in a clean, production ready way with good defaults and helpful error messages.