Awesome
<p align="center" id="top"> <a href="https://getwren.ai/?utm_source=github&utm_medium=title&utm_campaign=readme"> <picture> <source media="(prefers-color-scheme: light)" srcset="./misc/wrenai_logo.png"> <img src="./misc/wrenai_logo_white.png" width="300px"> </picture> <h1 align="center">Wren AI</h1> </a> </p> <p align="center"> <a aria-label="Follow us on X" href="https://x.com/getwrenai"> <img alt="" src="https://img.shields.io/badge/-@getwrenai-blue?style=for-the-badge&logo=x&logoColor=white&labelColor=gray&logoWidth=20"> </a> <a aria-label="Releases" href="https://github.com/canner/WrenAI/releases"> <img alt="" src="https://img.shields.io/github/v/release/canner/WrenAI?logo=github&label=GitHub%20Release&color=blue&style=for-the-badge"> </a> <a aria-label="License" href="https://github.com/Canner/WrenAI/blob/main/LICENSE"> <img alt="" src="https://img.shields.io/github/license/canner/WrenAI?color=blue&style=for-the-badge"> </a> <a aria-label="Join the community on GitHub" href="https://discord.gg/5DvshJqG8Z"> <img alt="" src="https://img.shields.io/badge/-JOIN%20THE%20COMMUNITY-blue?style=for-the-badge&logo=discord&logoColor=white&labelColor=grey&logoWidth=20"> </a> <a aria-label="Canner" href="https://cannerdata.com/?utm_source=github&utm_medium=badge&utm_campaign=readme"> <img src="https://img.shields.io/badge/%F0%9F%A7%A1-Made%20by%20Canner-blue?style=for-the-badge"> </a> </p><p align="center"> <img src="./misc/wrenai_view.png"> </p>Wren AI is an open-source SQL AI Agent that empowers data, product, and business teams to access insights through chat, built-in well designed intuitive UI and UX, integrating seamlessly with tools like Excel and Google Sheets.
🕶 Try it yourself!
https://github.com/user-attachments/assets/e4e78006-0088-4094-b58f-8868689bf787
👉 Try with your data on Wren AI Cloud or Install in your local environment
🎯 Our Vision & Mission
Wren AI’s mission is to democratize data by bringing AI agents with SQL ability to any data source.
🤩 Learn more about Wren AI and our Mission
🤖 A User-Centric, End-to-End Open-source SQL AI Agent - Text-to-SQL Total Solution
1. Talk to Your Data in Any Language
<p align="center"> <img src="./misc/wren-lang.png" style="max-width: 700px"/> </p>Wren AI speaks your language, such as English, German, Spanish, French, Japanese, Korean, Portuguese, Chinese, and more. Unlock valuable insights by asking your business questions to Wren AI. It goes beyond surface-level data analysis to reveal meaningful information and simplifies obtaining answers from lead scoring templates to customer segmentation.
2. AI-powered Data Exploration Features
<p align="center"> <img src="./misc/AI-generated-understanding_recommend_questions.png" style="max-width: 700px"/> </p>Beyond just retrieving data from your databases, Wren AI now answers exploratory questions like “What data do I have?” or “What are the columns in my customer tables?” Additionally, our AI dynamically generates recommended questions and intelligent follow-up queries tailored to your context, making data exploration smarter, faster, and more intuitive. Empower your team to unlock deeper insights effortlessly with AI.
3. Semantic Indexing with a Well-Crafted UI/UX
<p align="center"> <img src="./misc/wren-modeling.png" style="max-width: 700px"/> </p>Wren AI has implemented a semantic engine architecture to provide the LLM context of your business; you can easily establish a logical presentation layer on your data schema that helps LLM learn more about your business context.
4. Generate SQL Queries with Context
<p align="center"> <img src="./misc/wren-context.png" style="max-width: 700px"/> </p>With Wren AI, you can process metadata, schema, terminology, data relationships, and the logic behind calculations and aggregations with “Modeling Definition Language”, reducing duplicate coding and simplifying data joins.
5. Get Insights without Writing Code
<p align="center"> <img src="./misc/wren-insight.png" style="max-width: 700px"/> </p>When starting a new conversation in Wren AI, your question is used to find the most relevant tables. From these, LLM generates the most relevant question for the user. You can also ask follow-up questions to get deeper insights.
6. AI-Powered Insights & Visuals
<p align="center"> <img src="./misc/wren-visual.png" style="max-width: 700px"/> </p>AI-generated summaries that deliver key insights alongside SQL queries, making complex data easier to understand. Instantly transform results into AI-generated charts, turning raw data into clear, actionable visuals – empowering faster, smarter decisions.
7. Easily Export and Visualize Your Data
<p align="center"> <img src="./misc/wren-excel.png" style="max-width: 700px"/> </p>Wren AI provides a seamless end-to-end workflow, enabling you to connect your data effortlessly with popular analysis tools such as Excel and Google Sheets. This way, your insights remain accessible, allowing for further analysis using the tools you know best.
🤔 Why Wren AI?
We focus on providing an open, secure, and accurate SQL AI Agent for everyone.
1. Turnkey Solution
Wren AI makes it easy to onboard your data. Discover and analyze your data with our user interface. Effortlessly generate results without needing to code.
2. Secure SQL Generation
We use RAG architecture to leverage your schema and context, generating SQL queries without requiring you to expose or upload your data to LLM models.
3. Open-source End-to-end Solution
Deploy Wren AI anywhere you like on your own data, LLM APIs, and environment, it's free.
🤖 Wren AI Text-to-SQL Agentic Architecture
Wren AI consists of three core services:
-
Wren UI: An intuitive user interface for asking questions, defining data relationships, and integrating data sources.
-
Wren AI Service: Processes queries using a vector database for context retrieval, guiding LLMs to produce precise SQL outputs.
-
Wren Engine: Serves as the semantic engine, mapping business terms to data sources, defining relationships, and incorporating predefined calculations and aggregations.
❤️ Knowledge Sharing From Wren AI
Want to get our latest sharing? Follow our blog!
🚀 Getting Started
Using Wren AI is super simple, you can set it up within 3 minutes, and start to interact with your data!
- Visit our Installation Guide of Wren AI.
- Visit the Usage Guides to learn more about how to use Wren AI.
📚 Documentation
Visit Wren AI documentation to view the full documentation.
🛠️ Contribution
Want to contribute to Wren AI? Check out our Contribution Guidelines.
⭐️ Community
- Welcome to our Discord server to give us feedback!
- If there are any issues, please visit GitHub Issues.
- Explore our public roadmap to stay updated on upcoming features and improvements!
Please note that our Code of Conduct applies to all Wren AI community channels. Users are highly encouraged to read and adhere to them to avoid repercussions.