PickYourTechPickYourTech home
Wren AI logo

Wren AI

Conversational AI that turns natural language into SQL and charts

Analytics & BI Platforms

Wren AI lets you ask any database in plain language and instantly receives precise SQL, visual charts, and AI‑generated insights, accelerating data‑driven decisions.

Wren AI banner

Overview

Overview

Wren AI is a generative BI agent that enables data analysts, developers, and product teams to interact with any supported database using natural language. By translating questions into accurate SQL and rendering charts on‑the‑fly, it removes the need for deep SQL expertise and speeds up insight discovery.

Core Capabilities

The platform combines a semantic layer that encodes schema, metrics, and joins with flexible LLM integration (OpenAI, Anthropic, Gemini, Ollama, and more). This ensures LLM‑generated queries stay consistent and governed. An extensible API lets you embed query‑and‑chart generation into custom applications, SaaS products, or chatbots, while AI‑written summaries turn raw results into decision‑ready reports.

Deployment & Community

Wren AI can be self‑hosted in minutes or consumed via the managed cloud service. It supports major data warehouses such as Snowflake, BigQuery, PostgreSQL, and more. Backed by an active Discord community and a permissive AGPL‑3.0 license, contributors can extend functionality or help shape the roadmap.

Highlights

Natural‑language to precise SQL and visual charts
AI‑generated summaries and reports for instant insights
Semantic layer (MDL models) that enforces schema and metric consistency
Embeddable API for custom analytics and chatbot integrations

Pros

  • Supports a wide range of databases and LLM providers
  • Semantic layer improves query accuracy and governance
  • Fast setup—ready in minutes for local or cloud use
  • Active community and clear contribution guidelines

Considerations

  • Result quality depends heavily on the chosen LLM
  • Requires external LLM API keys and associated costs
  • Self‑hosting may need familiarity with Docker and cloud services
  • AGPL‑3.0 license may limit proprietary commercial use

Managed products teams compare with

When teams consider Wren AI, these hosted platforms usually appear on the same shortlist.

Google Looker logo

Google Looker

Modern BI platform for governed data modeling and dashboards

Mode logo

Mode

Collaborative analytics and data science platform

Power BI logo

Power BI

Business intelligence and data visualization platform

Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.

Fit guide

Great for

  • Data analysts needing quick, ad‑hoc insights without writing SQL
  • Developers building BI features or chat‑based analytics in apps
  • Startups looking for a low‑code, extensible analytics layer
  • Teams with existing data warehouses that want AI‑enhanced reporting

Not ideal when

  • Environments without reliable access to powerful LLM APIs
  • Organizations requiring strict proprietary licensing terms
  • Use cases demanding ultra‑low latency real‑time queries
  • Teams that cannot allocate resources for self‑hosting infrastructure

How teams use it

Ad‑hoc data exploration

Business users ask natural‑language questions and receive SQL, charts, and AI summaries within seconds.

Automated reporting

Schedule API calls to generate weekly visual reports and narrative insights automatically.

Embedded analytics in SaaS products

Developers integrate the API to provide chat‑based data insights directly inside their applications.

Governed metric calculations

MDL models enforce consistent joins and metric definitions, reducing errors across the organization.

Tech snapshot

TypeScript65%
Python28%
Go5%
JavaScript2%
Less1%
Dockerfile1%

Tags

bedrockgenbipostgresqlllmchartsspreadsheetsbigqueryragtext2sqlsqlaisqlanthropicduckdbtext-to-sqlagentvertexbusiness-intelligencetext-to-chartopenai

Frequently asked questions

Which databases does Wren AI support?

It works with Athena, Redshift, BigQuery, DuckDB, PostgreSQL, MySQL, SQL Server, ClickHouse, Oracle, Trino, Snowflake, and more.

Can I use my own LLM model?

Yes, you can configure any supported LLM provider, including OpenAI, Anthropic, Gemini, Ollama, Bedrock, and others.

Is there a hosted version of Wren AI?

Wren AI offers a managed cloud service alongside the self‑hosted open‑source version.

What license is Wren AI released under?

The project is licensed under AGPL‑3.0.

How can I contribute to the project?

Star the repository, open issues for bugs or ideas, and submit pull requests following the contribution guidelines.

Project at a glance

Active
Visit siteView repo
Stars
13,498
Watchers
13,498
Forks
1,466
LicenseAGPL-3.0
Repo age1 year old
Last commit2 days ago
Primary languageTypeScript

Last synced 2 days ago