Canner/WrenAI
WrenAI
GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data sources, such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks and more.
Usage guide
WrenAI is an open-source project around agent, anthropic, bigquery with 15,661 GitHub stars. This guide focuses on when to use it, how to install it, how to run the first example, and what to verify before adopting it.
Key features
- Implemented mainly in Python, useful for judging integration effort in a similar stack.
- GitHub did not detect a repository license, so commercial permission is unconfirmed. Review the repository terms and any model weights, datasets, dependencies, or external services before commercial adoption.
- The project has a homepage, so cross-check docs, examples, and release information beyond GitHub.
Best for
- Evaluating WrenAI for Python AI workflows.
- Comparing a GitHub project with 15,661 stars and current repository activity.
Pros
- WrenAI has visible GitHub traction with 15,661 stars. Topics: agent, anthropic, bigquery.
- The project provides an external homepage for deeper evaluation.
Cons
- Production fit still depends on documentation depth, issue activity, and release cadence.
- No license was detected, so usage risk needs manual review.
Production readiness
WrenAI should be validated with its README, release history, open issues, and integration requirements before production use.
License risk
GitHub did not report a license, which usually requires manual legal review before production use.
WrenAI architecture preview
WrenAI's main path starts at the entry surface, runs through Agent orchestration runtime, combines OpenAI / Claude, PostgreSQL, External tool adapters, and returns Grounded answers / search results.
Entry
CLI / terminal entry
WrenAI is primarily entered through a developer command or terminal workflow.
pip install wrenai
Runtime
Agent orchestration runtime
The orchestration layer plans tasks, calls tools, manages context, and decides the next action.
agent workflow
Model
OpenAI / Claude
Model calls are likely routed through OpenAI, Claude based on README and topic signals.
OpenAI, Claude
Context
PostgreSQL
Context comes from PostgreSQL, which constrains what the model or runtime can use.
PostgreSQL
Tools
External tool adapters
Tool adapters let the runtime act outside the model through External tool adapters.
tool signal
Output
Grounded answers / search results
The final result is an answer or ranked result grounded in retrieved context.
answer output
Featured video
Simone Rizzo
Agente AI per le Business Intelligence si chiama WrenAI e spazza via PowerBI e Tableaux.
4,776 views · 2025-11-05
Install tutorial
Before you install
- Python runtime and an isolated virtual environment
- Node.js and the package manager used by the project
- A clean working directory for the first test run
Check the runtime environment
WrenAI depends on a Python-style environment. Use venv, conda, or a container to keep dependencies isolated.
Get the project files
Start from the official repository or package so the first run matches the documented behavior.
$ git clone https://github.com/Canner/WrenAI.gitInstall or build dependencies
Run the next setup command detected from the project documentation.
$ pip install wrenaiAdoption guidance and sources
Practical use cases
Agent workflow prototype
Use it to validate task decomposition, tool calling, memory, tool permissions, and result review loops.
Knowledge-base assistant
Use it for document-grounded AI workflows where retrieval quality matters.
GenBI (Generative BI) for AI agents, an open-source, governed text-to-
This is one of the documented reasons to evaluate WrenAI before choosing a stack.
Focus area: agent
This is one of the documented reasons to evaluate WrenAI before choosing a stack.
AI Agents project comparison
Compare WrenAI with similar projects before committing to a stack.
Before adopting
- Complete one clean-environment verification using the official WrenAI setup path.
- Review repository license, model weights, external services, and dependency terms for your use case.
- Check recent commits, release cadence, issue response, and documentation depth.
- Evaluate output quality, latency, resource usage, and recovery behavior with a small dataset.
Configuration notes
- Review README configuration notes before using production data.
Sources checked
These links are used to verify repository, documentation, or tutorial details. Review the source pages before adopting the project.
Troubleshooting
- If installation fails, first confirm the command is being run from the README-specified directory.
- If dependencies conflict, retry in a fresh virtual environment, container, or working directory.
- If output looks wrong, return to the smallest documented WrenAI example before adding complex data.
- For keys, model files, or external services, verify environment variables, local paths, and permissions one by one.
- Before production use, review recent updates, open issues, license terms, and safety boundaries.
What is WrenAI?
WrenAI is an open-source ai agents project. GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data sources, such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks and more.
How do I install WrenAI?
Start with the official README. The first detected setup step is: git clone https://github.com/Canner/WrenAI.git.
Is WrenAI beginner-friendly?
If you already know the Python ecosystem, start with the smallest example. Otherwise test it in an isolated environment first.
Can WrenAI be used commercially?
GitHub did not detect a repository license, so commercial permission is unconfirmed. Review the repository terms and any model weights, datasets, dependencies, or external services before commercial adoption.
Does WrenAI need a GPU?
GPU requirements depend on the workload, model, and dataset size. Start with the smallest README example before scaling up.
How should I decide whether to adopt WrenAI?
Evaluate setup cost, maintenance activity, issue health, license terms, and fit with your real workflow.