wren

Generates governed SQL and deployable dashboards through a semantic layer over 22+ databases.

17.7k|2.0k|Updated Mar 13, 2024
One-click install
npx skills add https://github.com/Canner/WrenAI --skill wren-canner
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wren
Source: https://github.com/Canner/WrenAI/tree/main/skills/wren
Command: npx skills add https://github.com/Canner/WrenAI --skill wren-canner

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires wrenai.

What problem does it solve? AI agents often generate incorrect SQL because they lack business context such as metric definitions, units, and join rules. This Skill connects agents to the Wren CLI, a semantic SQL layer that turns business questions into governed SQL and shareable dashboards across 22+ data sources. ## Core Features & Use Cases - Semantic SQL querying: Execute SQL through the MDL layer with wren --sql, transpile without hitting the database via wren dry-plan, and manage project context with wren context. - Project scaffolding and enrichment: Generate an MDL project from a database schema, connect SaaS sources like HubSpot, Stripe, and Salesforce via dlt, and enrich the context layer with enums, units, and cubes such as ARR, DAU, and churn. - GenBI app deployment: Turn a project's context layer into a shareable analytics web app and deploy it to Vercel or Cloudflare. - Use Case: A user asks "show me top 10 customers by revenue this quarter"; the agent loads the usage workflow guide, runs the query through the governed MDL layer, and returns correct SQL results aligned with approved metric definitions. ## Quick Start Install the CLI with pip install wrenai, then ask your agent to set up Wren and answer a data question using the wren skill.

Frequently Asked Questions about wren

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up Wren for my AI agent?▼

Install the CLI with pip install wrenai, then run npx skills add Canner/WrenAI to install the discovery stub. The agent fetches full workflow guides from the CLI with wren skills get onboarding, so instructions always match the installed version.

How do I generate an MDL project from a database schema?▼

Run wren skills get generate-mdl to load the workflow guide, which walks through generating an MDL project from your database schema. Wren supports 22+ data sources including Postgres, MySQL, BigQuery, Snowflake, and Spark.

Can Wren connect SaaS data like HubSpot or Stripe?▼

Yes, Wren connects SaaS sources via dlt connectors for HubSpot, Stripe, Salesforce, GitHub, and Slack. Load the guide with wren skills get dlt-connector, which also bundles helper scripts such as introspect_dlt.

What databases does Wren support?▼

Wren supports 22+ data sources including Postgres, MySQL, BigQuery, Snowflake, and Spark. Run wren docs connection-info <ds> to see the required and optional connection fields for a specific data source.

How do I run SQL through the Wren semantic layer?▼

Use wren --sql '...' or wren query --sql '...' to execute SQL through the MDL layer. Use wren dry-plan --sql '...' to transpile only without hitting the database, and manage connections with wren profile add, list, and switch.

What are the limitations of the wren skill stub?▼

The skill itself is only a discovery stub containing no workflow logic; all guides live inside the wren CLI. You must install the wrenai package first, and optional features like semantic memory require the [memory] extra.