WrenAI

by Canner

Ask a business question and your AI agent writes correct SQL thanks to a semantic layer versioned in Git.

17.8 k stars GitHub Apache-2.0 / AGPL-3.0 (multi-licence) FreeOpen sourceLocal

View on GitHub →

What it does

Metric definitions, joins and examples stored as YAML/Markdown in your repo
Connects to 22+ data sources
Works with the agents you already use (Claude Code, Cursor, MCP clients)

Install it

Requirements: Python, Node.js (for npx) and an AI coding agent

Install the CLI

pip install wrenai

Teach your agent about Wren

npx skills add Canner/WrenAI

The prompt for your agent

Paste it into your coding agent: it checks the requirements and installs it for you.

Claude CodeCodexCursorGemini CLIopencode

Prompt

Install WrenAI (https://getwren.ai) on my machine.
1. Check the requirements: Python, Node.js (for npx) and an AI coding agent. If anything is missing, tell me before installing anything.
2. Follow the official method:
- Install the CLI: pip install wrenai
- Teach your agent about Wren: npx skills add Canner/WrenAI
3. Check that it works, then explain how to launch it and where to start.

Always review what your agent is about to run, especially install commands.