WrenAI

Active
GitHub Python NOASSERTION

Description

Open-source text-to-SQL and text-to-chart GenBI agent with a semantic layer. Ask your database questions in natural language and get accurate SQL, charts, and BI insights. Supports 12+ data sources and any LLM.

Key Features

  • Open context layer providing business semantics, examples, and governance for AI agents
  • Agent-driven design with CLI-embedded workflow guides loaded on demand
  • Modeling Definition Language (MDL) for models, relationships, cubes, metrics, and RLAC/CLAC
  • Supports 22+ data sources powered by Apache DataFusion engine
  • Agent SDK integration with LangChain/LangGraph and Pydantic AI
  • Reviewable, reproducible context with Git-friendly versioning for all definitions

Use Cases

💡 Natural language database queries generating SQL and visualizations
💡 Building business data semantic layers for AI agents
💡 Unified querying across multiple data sources for BI analysis
💡 Agent-driven data exploration and report generation
💡 Enterprise data governance and access control

Quick Start

```bash
pip install wrenai
npx skills add Canner/WrenAI
```

After installing the CLI and discovery stub, tell your agent in a project directory: 'Use Wren to set up my Postgres database.' The agent runs `wren skills get onboarding` and follows the guide step-by-step. Supports the bundled `jaffle_shop` sample dataset for quick experimentation.

Related Projects