WrenAI

WrenAI

🚀 Open-source SQL AI Agent for Text-to-SQL. Supporting PostgreSQL, DuckDB, MySQL, MS SQL, ClickHouse, Trino, JSON, CSV, Parquet data sources, and more! 🚀

Stars: 1885

Visit
 screenshot

WrenAI is a data assistant tool that helps users get results and insights faster by asking questions in natural language, without writing SQL. It leverages Large Language Models (LLM) with Retrieval-Augmented Generation (RAG) technology to enhance comprehension of internal data. Key benefits include fast onboarding, secure design, and open-source availability. WrenAI consists of three core services: Wren UI (intuitive user interface), Wren AI Service (processes queries using a vector database), and Wren Engine (platform backbone). It is currently in alpha version, with new releases planned biweekly.

README:

Wren AI

Wren AI @ Hacktoberfest 2024 - Oct 1 till Oct 31

Hacktoberfest 2024 is here, and we're inviting developers of all levels to join our open-source community. Together, we'll build Wren AI as a friendly community for all.

👉 Learn how to win a Wren AI Exclusive Swag Pack & Holopin from DigitalOcean Rewards!

image


Wren AI is a SQL AI Agent for data teams to get results and insights faster by asking business questions without writing SQL.

wrenai_overview

🕶 Try it yourself!

https://github.com/user-attachments/assets/737bbf1f-f9f0-483b-afb3-2c622c9b91ba

👉 Try with your data!

🎯 Our Vision & Mission

Wren AI’s mission is to democratize data by bringing AI agents with SQL ability to any data source.

🤩 About our Vision

🙌 About our Mission

🤖 SQL AI Agent on your data

1. Indexing With Semantics

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.

2. Generate SQL Queries With Context

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.

3. Get Insights Without Writing Code

When starting a new conversation in Wren AI, your question is used to find the most relevant tables. From these, LLM generates three relevant questions for the user to choose from. You can also ask follow-up questions to get deeper insights.

4. Self-Learning Feedback Loop (Coming Soon)

The AI self-learning feedback loop refines SQL augmentation and generation by collecting data from various sources. These include user query history, revision intentions, feedback, schema patterns, semantic enhancements, and query frequency.

🤔 Why Wren AI?

We focus on providing an open, secure, and reliable 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 By Design

Your database content will never be transmitted to the LLM. Only metadata, like schemas, documentation, and queries, will be used in semantic search.

3. Open-Source

Deploy Wren AI anywhere you like on your own data, LLM APIs, and environment, it's free.

🤖 Wren AI 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.

wrenai_works

❤️ 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!

📚 Documentation

Visit Wren AI documentation to view the full documentation.

🛠️ Contribution

Want to contribute to Wren AI? Check out our Contribution Guidelines.

⭐️ Community

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.

🎉 Our Contributors

cyyeh
cyyeh
onlyjackfrost
onlyjackfrost
wwwy3y3
wwwy3y3
andreashimin
andreashimin
paopa
paopa
chilijung
chilijung
fredalai
fredalai
imAsterSun
imAsterSun
Ayushjhawar8
Ayush Jhawar
qdrddr
qdrddr
kushal34712
kushal34712
goldmedal
goldmedal
eltociear
eltociear
himanshu634
himanshu634
AryanK1511
AryanK1511
kpman
kpman
grieve54706
grieve54706
RoacherM
RoacherM
Innovatorcloudy
Innovatorcloudy
NishantRana07
Nishant Rana
sahil9001
sahil9001
yb-sid
yb-sid
Prototype4988
Prototype4988
iamawanishmaurya
iamawanishmaurya

For Tasks:

Click tags to check more tools for each tasks

For Jobs:

Alternative AI tools for WrenAI

Similar Open Source Tools

For similar tasks

For similar jobs