← Directory

WrenAI

Open Source
★ 17,210 • Updated Aug 10, 2026, 09:08 PM

WrenAI is an open-source Generative BI (GenBI) tool designed for AI agents.

Use Cases ▼
01

Ad-hoc business intelligence queries using natural language

02

Building AI agents that autonomously generate SQL for data analysis

03

Creating dynamic dashboards and charts from conversational questions

04

Governed self-service analytics for teams without SQL expertise

05

Cross-database querying and federation across multiple data sources

06

Embedding text-to-SQL capabilities into internal tools and apps

What Problem It Solves ▼

WrenAI solves the challenge of bridging the gap between non-technical users and complex SQL databases by providing an accurate, governed natural-language interface. It eliminates the need for manual SQL writing and reduces errors in data retrieval, enabling faster and more reliable data-driven decisions across organizations.

Key Features ▼
✓

Open-source and free to use

✓

Governed text-to-SQL ensures high accuracy and trustworthiness

✓

Supports 20+ data sources, enabling broad integration

✓

Natural language interface democratizes data access

✓

Generates visualizations (dashboards, charts) automatically

Overview

WrenAI is an open-source Generative BI (GenBI) tool designed for AI agents. It provides a governed text-to-SQL experience through an open context layer, allowing users to ask natural-language questions and receive trusted dashboards, charts, and SQL queries. The platform connects to over 20 data sources including BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, and Databricks, making it versatile for multi-database environments.

Full Description ▼

WrenAI emphasizes data accuracy and governance, ensuring that generated SQL aligns with business rules and metadata definitions. By decoupling the query generation from the underlying data models, it allows non-technical users to explore data securely without writing code. The tool is self-hosted and can be integrated into AI agent workflows, enabling autonomous analytics.

Pros & Cons

Pros

+

Open-source and free to use

+

Governed text-to-SQL ensures high accuracy and trustworthiness

+

Supports 20+ data sources, enabling broad integration

+

Natural language interface democratizes data access

+

Generates visualizations (dashboards, charts) automatically

Cons

−

Requires self-hosting and maintenance effort

−

Initial setup and metadata configuration can be complex

−

Limited to supported SQL-based data sources

−

Generated SQL quality depends on the underlying LLM model

−

Community-based support may lack enterprise-grade SLAs

Similar Tools

Vanna AI Dataherald SQLAI AskCSV Quills Datalogz

More in AI Agents