WrenAI

Visit Tool

WrenAI is an open-source GenBI agent that transforms natural language questions into accurate SQL, charts, and BI insights. It features a semantic layer for trustworthy outputs and supports 12+ data sources and any LLM.

Claim this tool

10Views

At a glance

Pricing

Open Source · Freemium

Free tier

Yes

API

Yes

Skill level

Technical

About

What is WrenAI?

WrenAI is an open-source Generative Business Intelligence (GenBI) agent designed to help users ask database questions in plain English and receive accurate SQL, charts, and BI insights. A key differentiator is its semantic layer (MDL), which encodes business definitions to ensure LLM outputs are grounded and trustworthy, preventing misinterpretations of metrics like "revenue" or "active user." It supports over 12 data sources, including PostgreSQL, BigQuery, Snowflake, and MySQL, and is compatible with any LLM provider, from OpenAI and Claude to self-hosted Ollama. WrenAI can be self-hosted via Docker or accessed through Wren AI Cloud, offering flexibility for different user needs. It also provides an API for embedding query and chart generation into custom applications.

Best used for

Ideal for data scientists who need to quickly query databases using natural language, generate accurate SQL and charts, and obtain reliable business intelligence insights. Especially valuable for ensuring LLM outputs are grounded in precise business definitions through its semantic layer, reducing misinterpretations.

Common actions

query databases

generate SQL

create charts

analyze business data

gain BI insights

open-sourcecollaborationdeepfakeworkflowsautomated workflowlow-code/no-codegithub copilot"AI Agents"face swapping

Capabilities

Key features

Text-to-SQL generation
Text-to-chart generation
Semantic layer (MDL)
Supports 12+ data sources
Integrates any LLM
API for embedding
AI-written summaries

Target Audience

data scientist

Integrations

postgresqlbigquerysnowflakemysqlredshiftmicrosoft-sql-serveroracleopenai+ 8 more

Pricing & Plans

Open Source · Freemium

Free

FAQs

What is the purpose of WrenAI's semantic layer?

The semantic layer (MDL) in WrenAI encodes your business definitions, ensuring that generated SQL and insights are accurate and trustworthy. It prevents LLMs from guessing metric meanings, grounding every query in a shared understanding of terms like "revenue" or "active user" across your data sources.

What data sources and LLMs does WrenAI support?

WrenAI supports over 12 data sources, including popular cloud warehouses and databases like PostgreSQL, BigQuery, Snowflake, and MySQL. It is also compatible with any LLM provider, such as OpenAI, Claude, Gemini, Ollama, and various self-hosted models, offering broad flexibility.

Can WrenAI be integrated into existing applications?

Yes, WrenAI provides an API that allows users to embed its query and chart generation capabilities directly into their applications. This enables the creation of custom agents, SaaS features, and chatbots that leverage WrenAI's GenBI functionalities.

Trending

Subcategories trending in Data & Analytics

Predictive Analytics Data Labeling & Annotation Real-Time Analytics Market Research Data Cleaning & Prep Data Pipelines & Integration

Trending

Also listed in

This tool also appears in

AI Agents & Automation › General-Purpose Agents Coding & Development › Open Source & Models

Explore

Browse AI tools by category

Content & Design Productivity & Business Coding & Development AI Agents & Automation Research & Education Wellness & Lifestyle Career Development Marketing & Growth Data & Analytics Customer Support & CX Finance E-commerce