LibreAI / Dev Tools / WrenAI
// devtools · Canner/WrenAI

WrenAI

GenBI for AI agents - governed text-to-SQL and dashboards through an open context layer

★ 17.8k stars⑂ 2.0k forksNOASSERTIONupdated 2026-10
▦ visual — this project's README ships no embeddable screenshot,
so here's a placeholder. The guide below is complete regardless.
// project facts

Project facts

WrenAI is an open-source dev tools project by Canner (Canner/WrenAI on GitHub). It has 17,823 GitHub stars and 2,040 forks, is released under the NOASSERTION license, and was last updated on GitHub on 8 October 2026.

Repository
Canner/WrenAI
GitHub stars
17,823
Forks
2,040
License
NOASSERTION
Last updated on GitHub
8 October 2026
Category
Dev Tools
Listing
Full install guide
Official site
Official site
// how it works

How it works

  1. Model your context

    Decide which tables and business definitions belong in the semantic (MDL) layer.

  2. Get WrenAI

    Install the wrenai Python package, or add the agent skills with npx.

  3. Connect a data source

    Connect your warehouse or database and author the context with the included skills.

  4. Ask your first question

    Pose a natural-language question and inspect the governed SQL and chart it produces.

// features

Why people love it

Governed text-to-SQL

Questions are answered through a curated semantic layer, so generated SQL respects defined models and rules.

20+ data sources

Works across BigQuery, Snowflake, PostgreSQL, ClickHouse, Redshift, Databricks, DuckDB and more.

GenBI dashboards

Produces dashboards and charts, including browser-side apps powered by the WASM build of the engine.

Knowledge and memory

Keeps version-controlled instructions and saved queries, plus a local LanceDB memory index with hybrid retrieval.

Agent SDKs

Integrates with LangChain/LangGraph and Pydantic AI, with agent skills for context authoring.

Git-based workflow

Bind a directory once, then git push deploys to Wren Cloud - git is the interface.

Advertisement
// run it

Run it yourself

  1. Clone the repository

    Get the source code from GitHub and enter the project directory.

    git clone https://github.com/Canner/WrenAI.git
    cd WrenAI
  2. Install the SDK

    The Python SDK and CLI install from PyPI.

    pip install wrenai
  3. Or add the agent skills

    Give your coding agent the WrenAI skills for context authoring.

    npx skills add Canner/WrenAI
// use cases

What you can build

Advertisement
// faq

Questions, answered

Who maintains this project?

It is maintained by Canner (the Wren AI team) on GitHub.

Is it free to use?

The open-source core is free - the README's License section states Apache 2.0, while Wren Cloud and some enterprise features are commercial under the project's open-core model.

Does it need a paid API key?

You need credentials for your own data warehouse/database and an LLM for question answering; WrenAI itself does not sell query tokens.

How does it compare to alternatives?

Compared with raw LLM text-to-SQL, WrenAI's semantic layer and governed execution primitives (dry-plan validation, row limits, structured errors) are designed to make agent-generated SQL trustworthy.

How do I get started?

Run pip install wrenai, connect a database, author a small context, and ask your first question.

// keep exploring

Similar tools

Dev Tools

context-mode

Context optimization for coding agents: sandbox tool output, keep sessions lean, remember more

★ 25.7k starsElastic License 2.0
View guide →
Dev Tools

potpie

A context graph for the AI-native SDLC — so agents and humans share one map of the codebase.

★ 5.7k starsApache-2.0
View guide →
Dev Tools

OpenContext

Personal context store for AI coding agents — your skills, always loaded.

★ 1.3k starsMIT
View guide →
Dev Tools

ripwire

The ripgrep of AI context — a zero-dependency C++23 CLI + MCP server that maps your repo for coding agents

★ 2.4k starsApache-2.0
View guide →
Dev Tools

repo2txt

Turn any GitHub repo into one formatted text file — perfect context for AI.

★ 1.8k starsCustom
View guide →
Dev Tools

postgresml

PostgresML — machine learning inside PostgreSQL with GPU acceleration: train, embed and run LLMs in SQL.

★ 6.8k starsMIT
View guide →
// alternatives

Alternatives in Dev Tools

The most-starred other Dev Tools projects in the LibreAI catalogue — the realistic shortlist if WrenAI is not the right fit.

Get WrenAI

Free and open — grab the source, star the repo, and start creating.