# canner/wrenai

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/canner-wrenai).**

14,437 stars · 1,543 forks · TypeScript · agpl-3.0

## Links

- GitHub: https://github.com/Canner/WrenAI
- Homepage: https://getwren.ai/oss
- awesome-repositories: https://awesome-repositories.com/repository/canner-wrenai.md

## Topics

`agent` `anthropic` `bedrock` `bigquery` `business-intelligence` `charts` `duckdb` `genbi` `llm` `openai` `postgresql` `rag` `spreadsheets` `sql` `sqlai` `text-to-chart` `text-to-sql` `text2sql` `vertex`

## Description

WrenAI is a platform designed to enable natural language interaction with relational and analytical databases. By combining a text-to-SQL engine with semantic data modeling, it allows users to explore structured data through plain language questions, removing the requirement for manual code generation.

The system functions by grounding natural language requests in a predefined business logic layer rather than raw database schemas. This semantic approach, supported by context-aware prompt engineering, ensures that generated queries remain consistent and accurate across an organization. The platform includes a modular connector interface to interface with diverse storage environments and provides automated visualization tools to transform query results into interactive reports.

Beyond standalone querying, the platform serves as an embedded business intelligence tool. It provides a conversational interface that can be integrated directly into custom software applications, internal dashboards, and business workflows to facilitate automated data analysis and exploration.

## Tags

### Artificial Intelligence & ML

- [Text-to-SQL Translators](https://awesome-repositories.com/f/artificial-intelligence-ml/text-to-sql-translators.md) — Translates natural language questions into accurate SQL queries using a semantic business logic layer.
- [Natural Language Query Generators](https://awesome-repositories.com/f/artificial-intelligence-ml/natural-language-query-generators.md) — Translates plain English questions into accurate SQL queries for independent data exploration.
- [Natural Language Querying Interfaces](https://awesome-repositories.com/f/artificial-intelligence-ml/natural-language-querying-interfaces.md) — Provides a conversational interface for integrating natural language data exploration into custom applications.
- [Context Injection](https://awesome-repositories.com/f/artificial-intelligence-ml/context-injection.md) — Structures database schema and business logic into prompts to improve query accuracy.
- [Language Model Integrations](https://awesome-repositories.com/f/artificial-intelligence-ml/language-model-integrations.md) — Connects to external language models to automate database query generation and data analysis. ([source](https://cdn.jsdelivr.net/gh/Canner/WrenAI@main/README.md))

### Data & Databases

- [Semantic Data Models](https://awesome-repositories.com/f/data-databases/semantic-data-models.md) — Maps complex database schemas into business-friendly terms to ensure consistent data interpretation across the organization. ([source](https://cdn.jsdelivr.net/gh/Canner/WrenAI@main/README.md))
- [Data Querying](https://awesome-repositories.com/f/data-databases/data-querying.md) — Connects language models to databases to automate the generation of precise, context-aware queries.
- [Database Interaction Tools](https://awesome-repositories.com/f/data-databases/database-interaction-tools.md) — Enables large language models to interact with relational databases for automated data analysis.
- [Data Visualization](https://awesome-repositories.com/f/data-databases/data-analysis-visualization/visualization-frameworks-libraries/data-visualization.md) — Automatically transforms query results into interactive charts and reports for immediate business insights. ([source](https://cdn.jsdelivr.net/gh/Canner/WrenAI@main/README.md))
- [Database Schema Mapping](https://awesome-repositories.com/f/data-databases/database-schema-mapping.md) — Maps complex relational database structures into business-friendly definitions for consistent data interpretation.
- [Query Orchestrators](https://awesome-repositories.com/f/data-databases/query-orchestrators.md) — Orchestrates the interpretation of user intent and construction of database queries using language models.
- [Unified Data Provider Interfaces](https://awesome-repositories.com/f/data-databases/unified-data-provider-interfaces.md) — Offers a standardized abstraction layer to connect and query diverse relational and analytical database systems.
- [Database Connectivity](https://awesome-repositories.com/f/data-databases/database-connectivity.md) — Connects to diverse relational and analytical database systems to facilitate natural language querying. ([source](https://docs.getwren.ai/oss/guide/connect/overview))

### Business & Productivity Software

- [Business Intelligence Tools](https://awesome-repositories.com/f/business-productivity-software/business-intelligence-tools.md) — Provides embedded conversational data exploration and visualization tools for custom applications and dashboards. ([source](https://cdn.jsdelivr.net/gh/Canner/WrenAI@main/README.md))

### Part of an Awesome List

- [Data Science Agents](https://awesome-repositories.com/f/awesome-lists/ai/data-science-agents.md) — Open-source agent for natural language to SQL database querying.
- [LLM Development Frameworks](https://awesome-repositories.com/f/awesome-lists/ai/llm-development-frameworks.md) — Text-to-SQL and generative BI agent with semantic layer.
- [Task Automation Agents](https://awesome-repositories.com/f/awesome-lists/ai/task-automation-agents.md) — Natural language interface for querying and retrieving data insights.
- [Databases and RAG](https://awesome-repositories.com/f/awesome-lists/data/databases-and-rag.md) — AI agent for Text-to-SQL and BI.
- [SQL Enhancement](https://awesome-repositories.com/f/awesome-lists/data/sql-enhancement.md) — Efficient tool for converting natural language to SQL across databases.