{"data":{"slug":"canner-wrenai","name":"WrenAI","tagline":"GenBI for AI agents, turns natural-language questions into trusted dashboards and SQL","github_url":"https://github.com/Canner/WrenAI","owner":"Canner","repo":"WrenAI","owner_avatar_url":"https://avatars.githubusercontent.com/u/7250217?v=4","primary_language":"Python","stars":17295,"forks":1955,"topics":["ai-agents","bigquery","business-intelligence","charts","clickhouse","context-engineering","dashboard","databricks","duckdb","genbi","generative-ai","llm","mcp","postgresql","rag","semantic-layer","snowflake","sql","text-to-sql","text2sql"],"archived":false,"github_pushed_at":"2026-08-18T05:19:19+00:00","maintenance_label":"Very active","stars_delta_30d":1328,"url":"https://www.graphcanon.com/tools/canner-wrenai","markdown_url":"https://www.graphcanon.com/tools/canner-wrenai.md","api_url":"https://www.graphcanon.com/api/graphcanon/tools/canner-wrenai","graph_url":"https://www.graphcanon.com/api/graphcanon/graph?tool=canner-wrenai","description":"GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data sources, such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks and more.","homepage_url":"https://www.getwren.ai/en/open-core","license":"Other","open_issues":327,"watchers":102,"ai_summary":"Open-source tool that translates natural language inputs into SQL queries and generates visualizations (charts and dashboards) from over twenty supported data sources.","readme_excerpt":"### 1. Install the CLI\n\n```bash\npip install wrenai                      # core (DuckDB included)\npip install \"wrenai[postgres,memory]\"   # add per-datasource and memory extras as needed\n```\n\n> **Tip for users in mainland China:** If `pip install` is slow or fails, use the Tsinghua mirror:\n> ```bash\n> pip install wrenai -i https://pypi.tuna.tsinghua.edu.cn/simple\n> ```\n> If HuggingFace model downloads time out, add `export HF_ENDPOINT=https://hf-mirror.com` before running the CLI.\n\n---\n\n### 2. Install the discovery stub for your AI client\n\n```bash\nnpx skills add Canner/WrenAI            # auto-detects Claude Code, Cursor, Cline, Codex, …\n```\n\nThe stub is ~50 lines. It teaches your agent to fetch workflow guides via\n`wren skills get <name>` and shaped prompts via\n`wren ask \"<question>\" --guided|--direct`, and everything else lives in the CLI.\n\n---\n\n## License\n\nApache 2.0. See [LICENSE](./LICENSE).\n\n---\n\n<div align=\"center\">\n\n*Come build open GenBI with us.*\n\n**If WrenAI helps you, drop a ⭐, it genuinely helps us grow!**\n\n<p><a href=\"#top\">⬆️ Back to top</a></p>\n\n</div>","github_created_at":"2024-03-13T06:18:20+00:00","created_at":"2026-07-07T17:36:45.889825+00:00","updated_at":"2026-08-18T06:02:07.620005+00:00","categories":[{"slug":"ai-agents","name":"AI Agents","url":"https://www.graphcanon.com/categories/ai-agents","markdown_url":"https://www.graphcanon.com/categories/ai-agents.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/ai-agents"},{"slug":"data-retrieval","name":"Data & Retrieval","url":"https://www.graphcanon.com/categories/data-retrieval","markdown_url":"https://www.graphcanon.com/categories/data-retrieval.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/data-retrieval"}],"tags":[{"slug":"agent","name":"agent"},{"slug":"bigquery","name":"bigquery"},{"slug":"context-engineering","name":"context-engineering"},{"slug":"duckdb","name":"duckdb"},{"slug":"genbi","name":"genbi"},{"slug":"postgres","name":"postgres"},{"slug":"sqlai","name":"sqlai"},{"slug":"text-to-sql","name":"text-to-sql"}],"trust":{"provenance":{"is_fork":false,"github_id":771350543,"owner_type":"Organization","methodology":"github_public_v1","parent_repo":null,"near_duplicate_slugs":[]},"computed_at":"2026-08-18T06:02:06.747Z","maintenance":{"label":"Very active","score":96,"methodology":"github_public_v1","releases_90d":30,"days_since_push":0,"last_release_at":"2026-08-18T05:19:19Z","stars_delta_30d":1328,"open_issues_delta_30d":-41},"security_summary":{"status":"no_lockfile","scanner":null,"low_count":0,"high_count":0,"last_scan_at":"2026-07-11T11:08:02.453Z","medium_count":0,"scan_profile":"none","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-08-18T06:02:07.353Z"},"languages":{"value":["python"],"source":"github.language","observed_at":"2026-08-18T06:02:07.353Z"},"license_spdx":{"value":"Other","source":"github.license","observed_at":"2026-08-18T06:02:07.353Z"}},"decision_facts":{"hosting":null,"pricing":{"model":"freemium","summary":"Free to use with self-hosting capabilities; commercial support available."},"requirements":{"notes":["Install the CLI using pip (e.g., `pip install wrenai`). Consider regional mirrors like Tsinghua for faster installation in mainland China."]},"constraints":{"pricing_model":"freemium"},"when_to_use":["When you require a tool that can generate trusted dashboards, charts, and SQL queries directly from natural language inputs.","If your project involves integrating with multiple databases such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks, and others, thereby benefiting from a versatile data-to-視"],"when_not_to_use":["For environments where the specific installation instructions for regions like mainland China might be problematic or where direct dependency on certain mirrors could cause operational challenges.","When a project strictly requires proprietary tools or has licensing constraints that do not align with the Apache 2.0 license of WrenAI."],"source":"enrich:decision_facts","observed_at":"2026-07-11T14:51:17.004Z"},"constraint_facets":{"pricing_model":"freemium"},"decision_summary":[{"label":"Pricing","value":"freemium - Free to use with self-hosting capabilities; commercial support available."},{"label":"Requirements","value":"Install the CLI using pip (e.g., `pip install wrenai`). Consider regional mirrors like Tsinghua for faster installation in mainland China."},{"label":"Adopt for","value":"WrenAI transforms natural-language queries into SQL and produces visual reports from over twenty supported data sources using an open context layer."},{"label":"License detail","value":"WrenAI is distributed under an open-source Apache 2.0 license, allowing for broad use, modification, and distribution."}]}}