Skip to content
forked from Canner/WrenAI

πŸš€ Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! πŸ™Œ

License

Notifications You must be signed in to change notification settings

wwwxdragon/WrenAI

Β 
Β 

Repository files navigation

Wren AI

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 Our Demo!

Wren-ask_1080.mp4

πŸ‘‰ Play around with Wren AI yourself!

🎯 Our Vision & Mission

Wren AI’s mission is to democratize data by bringing AI Agent 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 is designed to refine SQL augmentation and generation by collecting data from various sources. These include user query history, revision intentions, feedback, schema patterns, semantics enhancement, 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 contents 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 within Wren AI's framework.

  • 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!

Trends

Architecture

Tutorials

🚧 Project Status

Wren AI is currently in Beta Version. The project team is actively working on progress and aiming to release new versions at least biweekly.

πŸš€ Getting Started

Using Wren AI is super simple, you can setup within 3 minutes, and start to interact with your own data!

πŸ“š Documentation

Visit Wren AI documentation to view the full documentation.

⭐️ Community

Do 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.

About

πŸš€ Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! πŸ™Œ

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • TypeScript 65.9%
  • Python 29.2%
  • JavaScript 1.9%
  • Go 1.8%
  • Less 0.7%
  • Shell 0.2%
  • Other 0.3%