context-mode
Context optimization for coding agents: sandbox tool output, keep sessions lean, remember more
GenBI for AI agents - governed text-to-SQL and dashboards through an open context layer
WrenAI is an open-source dev tools project by Canner (Canner/WrenAI on GitHub). It has 17,823 GitHub stars and 2,040 forks, is released under the NOASSERTION license, and was last updated on GitHub on 8 October 2026.
Decide which tables and business definitions belong in the semantic (MDL) layer.
Install the wrenai Python package, or add the agent skills with npx.
Connect your warehouse or database and author the context with the included skills.
Pose a natural-language question and inspect the governed SQL and chart it produces.
Questions are answered through a curated semantic layer, so generated SQL respects defined models and rules.
Works across BigQuery, Snowflake, PostgreSQL, ClickHouse, Redshift, Databricks, DuckDB and more.
Produces dashboards and charts, including browser-side apps powered by the WASM build of the engine.
Keeps version-controlled instructions and saved queries, plus a local LanceDB memory index with hybrid retrieval.
Integrates with LangChain/LangGraph and Pydantic AI, with agent skills for context authoring.
Bind a directory once, then git push deploys to Wren Cloud - git is the interface.
Get the source code from GitHub and enter the project directory.
git clone https://github.com/Canner/WrenAI.git
cd WrenAIThe Python SDK and CLI install from PyPI.
pip install wrenaiGive your coding agent the WrenAI skills for context authoring.
npx skills add Canner/WrenAIIt is maintained by Canner (the Wren AI team) on GitHub.
The open-source core is free - the README's License section states Apache 2.0, while Wren Cloud and some enterprise features are commercial under the project's open-core model.
You need credentials for your own data warehouse/database and an LLM for question answering; WrenAI itself does not sell query tokens.
Compared with raw LLM text-to-SQL, WrenAI's semantic layer and governed execution primitives (dry-plan validation, row limits, structured errors) are designed to make agent-generated SQL trustworthy.
Run pip install wrenai, connect a database, author a small context, and ask your first question.
Context optimization for coding agents: sandbox tool output, keep sessions lean, remember more
A context graph for the AI-native SDLC — so agents and humans share one map of the codebase.
Personal context store for AI coding agents — your skills, always loaded.
The ripgrep of AI context — a zero-dependency C++23 CLI + MCP server that maps your repo for coding agents
Turn any GitHub repo into one formatted text file — perfect context for AI.
PostgresML — machine learning inside PostgreSQL with GPU acceleration: train, embed and run LLMs in SQL.
The most-starred other Dev Tools projects in the LibreAI catalogue — the realistic shortlist if WrenAI is not the right fit.
The open source coding agent
The model-definition framework behind modern AI — thousands of pretrained transformers for text, vision, and audio.
Anthropic's agentic coding tool that lives in your terminal and works across your whole codebase
Cross-platform desktop all-in-one manager for Claude Code, Codex, OpenCode and other coding agents
OpenAI's lightweight coding agent that runs locally in your terminal
Free and open — grab the source, star the repo, and start creating.