GitHub

Free

FreeFree tier

Type

Open Source

Company

Canner

Visit Website GitHub (40 stars)

About GitHub

WrenAI is an open-source GenBI (Generative Business Intelligence) engine designed for AI agents. It enables agents to generate, deploy, and govern business intelligence outputs—from SQL answers to shareable dashboards—directly from natural language questions. The system is built on an open context layer that provides business semantics, approved definitions, examples, memory, and governance, ensuring trustworthy and governed text-to-SQL generation. WrenAI supports over 20 data sources including BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, and Databricks. Key technical features include schema-aware retrieval, MDL (model definition language) planning, dry-plan validation, structured error handling, and browser-side dashboard rendering using Wren Core WASM. The project is Apache-2.0 licensed and provides an SDK, skills, and a CLI for deployment to Vercel or Cloudflare Pages.

Key Features

Open-source GenBI engine for AI agents

Governed text-to-SQL with natural language input

Open context layer with business semantics, definitions, examples, memory, and governance

Support for 22+ data sources including BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks

Browser-side dashboard rendering using Wren Core WASM

Schema-aware retrieval and MDL planning

Dry-plan validation and structured error handling

Deployment to Vercel or Cloudflare Pages with one command

Versionable, git-friendly knowledge management via MDL files and definitions

SDK and skills for agent integration

Pros & Cons

Pros

Open-source and Apache-2.0 licensed, allowing customization and self-hosting
Governed output with built-in knowledge management for correctness
Supports a wide range of popular databases and data warehouses
Provides dry-run validation and structured errors to reduce mistakes
Easy deployment options via Vercel or Cloudflare Pages

Cons

Requires initial setup of the context layer with business semantics and definitions
Effectiveness depends on the quality and completeness of the provided context
Primarily targeted at developers and agent builders, may not suit non-technical users directly
Dashboard functionality is browser-based and may have limitations compared to dedicated BI tools

Best For

Building AI agents that answer business questions with governed SQL queriesGenerating dashboards and charts from natural language questionsEmbedding governed BI capabilities into existing agent workflowsEnabling non-technical users to query databases via natural languageCreating a knowledge layer of business definitions for consistent reporting

FAQ

What is WrenAI?

WrenAI is an open-source GenBI engine that lets AI agents generate, deploy, and govern business intelligence from natural language questions. It uses an open context layer to ensure trustworthy and governed text-to-SQL and dashboard generation.

How does WrenAI ensure correctness?

It uses schema-aware retrieval, MDL planning, dry-plan validation, and structured error handling to reduce hallucination and produce accurate SQL and charts.

What data sources does WrenAI support?

WrenAI supports 22+ data sources including BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, and Databricks.

Is WrenAI free to use?

Yes, WrenAI is open-source and available under the Apache-2.0 license. The code can be used, modified, and deployed freely.

How do I deploy a dashboard created with WrenAI?

You can deploy browser-side dashboards built with Wren Core WASM to your own Vercel or Cloudflare Pages account with a single command.