WrenAI, an open source Generative Business Intelligence agent (GenBI), developed by Canner is designed to allow seamless natural language interaction with structured information. This tool targets non-technical as well as technical teams. It allows them to visualize, query and analyze data without needing SQL. It is verified that all integrations and capabilities are in line with the latest release and documentation.
Key Capabilities
- SQL to Natural Language:
WrenAI can translate plain-language data queries (in multiple languages) into production-grade SQL. The data is accessible to non-technical people.. - Multi-Modal Output:
The platform generates SQL, charts, summary reports, dashboards, and spreadsheets. Both textual and visual outputs (e.g., charts, tables) are available for immediate data presentation or operational reporting. - GenBI Insights:
WrenAI provides AI-generated summaries, reports, and context-aware visualizations, enabling quick, decision-ready analysis. - LLM Flexibility:
WrenAI supports a range of large language models, including:- OpenAI GPT series
- Azure OpenAI
- Google Gemini, Vertex AI
- DeepSeek
- Databricks
- AWS Bedrock (Anthropic Claude, Cohere, etc.)
- Groq
- Ollama (for deploying local or custom LLMs)
- Other OpenAI API-compatible and user-defined models.
- Semantic Layer & Indexing:
Uses a Modeling Definition Language (MDL) for encoding schema, metrics, joins, and definitions, giving LLMs precise context and reducing hallucinations. The semantic engine ensures context-rich queries, schema embeddings, and relevance-based retrieval for accurate SQL. - Export & Collaboration:
Results can be exported to Excel, Google Sheets, or APIs for further analysis or team sharing. - API Embeddability:
Query and visualization capabilities are accessible via API, enabling seamless embedding in custom apps and frontends.
Architecture Overview
WrenAI’s architecture is modular and highly extensible for robust deployment and integration:
| Component | Description |
|---|---|
| User Interface | Web-based or CLI UI for natural language queries and data visualization. |
| Orchestration Layer | Handles input parsing, manages LLM selection, and coordinates query execution. |
| Semantic Indexing | Embeds database schema and metadata, providing crucial context for the LLM. |
| LLM Abstraction | Unified API for integrating multiple LLM providers, both cloud and local. |
| Query Engine | Executes generated SQL on supported databases/data warehouses. |
| Visualization | Renders tables, charts, dashboards, and exports results as needed. |
| Plugins/Extensibility | Allows custom connectors, templates, prompt logic, and integrations for domain-specific needs. |
Semantic Engine Details
- Schema Embeddings:
Dense vector representations capture schema and business context, powering relevance-based retrieval. - Few-Shot Prompting & Metadata Injection:
Schema samples, joins, and business logic are injected into LLM prompts for better reasoning and accuracy. - Context Compression:
The engine adapts schema representation size according to token limits, preserving critical detail for each model. - Retriever-Augmented Generation:
Relevant schema and metadata are gathered via vector search and added to prompts for context alignment. - Model-Agnostic:
Wren Engine works across LLMs via protocol-based abstraction, ensuring consistent context regardless of backend.
Supported Integrations
- Databases and Warehouses:
Out-of-the-box support for BigQuery, PostgreSQL, MySQL, Microsoft SQL Server, ClickHouse, Trino, Snowflake, DuckDB, Amazon Athena, and Amazon Redshift, among others. - Deployment Modes:
Can be run self-hosted, in the cloud, or as a managed service. - API and Embedding:
Easily integrates into other applications and platforms via API.
Typical Use Cases
- Marketing/Sales:
Rapid generation of performance charts, funnel analyses, or region-based summaries from natural language prompts. - Product/Operations:
Analyze product usage, customer churn, or operational metrics with follow-up questions and visual summaries. - Executives/Analysts:
Automated, up-to-date business dashboards and KPI tracking, delivered in minutes.
Conclusion
WrenAI is a verified, open-source GenBI solution that bridges the gap between business teams and databases through conversational, context-aware, AI-powered analytics. It is extensible, multi-LLM compatible, secure, and engineered with a strong semantic backbone to ensure trustworthy, explainable, and easily integrated business intelligence.
Check out the GitHub Page. This research is the work of researchers.
Asif Razzaq serves as the CEO at Marktechpost Media Inc. As an entrepreneur, Asif has a passion for harnessing Artificial Intelligence to benefit society. Marktechpost was his most recent venture. This platform, which focuses on machine learning and deep-learning news, is both technical and understandable to a broad audience. This platform has over 2,000,000 monthly views which shows its popularity.
