Project ◆ Hidden gem

WrenAI

Canner/WrenAI · Python · Apache-2.0

Ask your database questions in plain English; it clarifies, then writes the SQL.

WrenAI sits on top of your warehouse, builds a semantic model of the schema, asks follow-up questions to disambiguate, and returns SQL plus a chart you can trust.

76.5 / 100 · Score
★ 18k Stars
+50 30-day growth
20 min Time to first run
Needs a paid API key API key

Score

Trend 48
Activity 90
Quality 100
Community 80
Relevance 63

Setup at a glance

DeployDocker
GPUNo GPU needed
API keyNeeds a paid API key
UI languagesen, zh
Doc languagesen, zh
Install
docker compose up -d

Deep dive

WrenAI is an open-source GenBI stack: ask a question in natural language and get a governed answer plus a deployable dashboard — not just a SQL snippet.

Correctness is the design centre — schema-aware retrieval, MDL (semantic-layer) planning and dry-run validation run before anything executes, so the system can correct itself instead of confidently returning wrong numbers. Business meaning lives in Git: metric definitions, enums, approved joins and prompts are versioned like code.

It works through the agents you already run — Claude Code, Cursor, Cline, Codex, MCP — and sits on your existing warehouse and transformation stack rather than demanding a new one.

Use cases

Let non-engineers query the company data warehouse
Turn ad-hoc questions into reviewed SQL
Add a natural-language layer over existing BI

Good for / Not ideal for

Good for

Data teams drowning in 'can you pull a number' requests
Startups without a dedicated analytics eng
Tools that already live on Postgres / BigQuery / Snowflake

Not ideal for

Tiny SQLite side projects (overkill)
Teams that refuse any cloud component

Trend · 30d