跳到正文
cccskills
免费在 GitHub 公开

wren

Find the Wren CLI workflow for answering data questions, connecting databases or SaaS sources, generating model definitions, adding business metrics, or building a shareable analytics app. Guides are retrieved from the installed CLI version.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

Wren CLI for AI agents — a semantic SQL layer over 22+ databases (Postgres, MySQL, BigQuery, Snowflake, Spark, …). The actual workflow guides live inside the `wren` CLI itself; this is just a discovery stub. Use whenever the user asks a data question (how many, show me, top N, compare, trend, breakdown, metric, revenue, customers, orders), wants to install / set up Wren Engine, connect a new database, connect SaaS data via dlt (HubSpot, Stripe, Salesforce, GitHub, Slack), generate or regenerate an MDL project from a database schema, enrich a project with business context (enum meanings, units, cubes like ARR / DAU / churn), or turn a project's context layer into a shareable GenBI web app / dashboard and deploy it to Vercel or Cloudflare. Triggers: 'install wren', 'set up wren engine', 'connect database to wren', 'connect SaaS to wren', 'load hubspot / stripe / salesforce data', 'generate mdl', 'scaffold wren project', 'enrich wren context', 'augment my project', 'add cubes', 'build a dashboard', 'make a shareable analytics app', 'deploy my context layer as a web app', 'genbi app', 'wren onboarding', 'wren usage', 'wren generate mdl', 'wren dlt connector', 'wren enrich context', 'wren genbi'.

查看安装方法

适用场景

  • Set up Wren and connect a database
  • Load HubSpot or Stripe data through dlt
  • Generate model definitions and add business metrics
  • Build and deploy a shareable analytics app

包含的文件(1)

  • SKILL.md3.2 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Wren CLI

This is a discovery stub. The actual workflow guides and prompt helpers live inside the wren CLI itself, so they always match the installed wrenai version (no skill cache, no version drift).

Install: pip install wrenai.

Workflow guides

wren skills list                        # all available workflow guides
wren skills get onboarding              # set up Wren end-to-end
wren skills get usage                   # day-to-day querying
wren skills get generate-mdl            # generate MDL from a database schema
wren skills get dlt-connector           # connect SaaS sources via dlt
wren skills get enrich-context          # add business context (units, enums, cubes)
wren skills get genbi                   # build & deploy a shareable GenBI web app
# add --full to include the skill's reference docs
# add --script <name> to fetch a bundled script (e.g. dlt-connector / introspect_dlt)

Reference docs

Full reference docs live on the web: https://github.com/Canner/WrenAI/tree/main/docs/core

wren docs connection-info <ds>          # required + optional connection fields for a data source

Prompt enhancement (wraps a user question for an agent)

wren ask "<question>" --guided          # for weaker LLMs (strict task flow)
wren ask "<question>" --direct          # for stronger LLMs (minimal wrapping)

Day-to-day data commands (not a sub-app — top-level)

wren --sql '...'                        # execute SQL through the MDL layer
wren query --sql '...'                  # same, explicit
wren dry-plan --sql '...'               # transpile only, no DB hit
wren context show / build / validate    # project / MDL lifecycle
wren profile add / list / switch        # named connection profiles
wren memory index / recall / store      # semantic memory (needs `[memory]` extra)

Run wren --help for the full surface; load the matching wren skills get <name> guide before driving any multi-step workflow.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Import SaaS data into DuckDB using dlt, a data loading tool, then generate a Wren project with table definitions and relationships. Verify the setup with real SQL queries, or start from an existing DuckDB file.

中文简介正在准备中。当前显示英语简介。

  • Importing HubSpot or Stripe data for SQL analysis
  • Creating a Wren project from an existing dlt DuckDB file
  • Generating table definitions and parent-child relationships
Canner/WrenAI1.8万2026年10月16日 更新

Add business knowledge missing from a Wren project's database definitions. Compare source documents with existing context, then add explanations, rules, SQL examples, and proposed metrics through guided questions or an automatic mode with an audit report.

中文简介正在准备中。当前显示英语简介。

  • Documenting status codes, units, and NULL meanings
  • Adding business knowledge from handbooks and glossaries
  • Defining aggregation metrics such as ARR or DAU
Canner/WrenAI1.8万2026年10月16日 更新

genbi

免费

Build an analytics web app from a Wren project's data definitions and business context. Create charts and tables, validate the app, and deploy to Vercel or Cloudflare with a checked URL for sharing.

中文简介正在准备中。当前显示英语简介。

  • Building a sales dashboard from a Wren project
  • Sharing a report with bundled data
  • Creating an analytics app that fetches current data
Canner/WrenAI1.8万2026年10月16日 更新

Create a Wren MDL project, a model layer for database queries, from an existing database. Discover tables and relationships, normalize column types, generate YAML files, and validate and build the project before indexing its schema.

中文简介正在准备中。当前显示英语简介。

  • Create a Wren project from an existing database
  • Add selected schemas and tables as a new data source
  • Define model relationships from database constraints
Canner/WrenAI1.8万2026年10月16日 更新

Set up Wren Engine through guided steps covering environment checks, installation, database connection, and project creation. Prepare data definitions and validate the setup, then suggest initial questions to help the user begin exploring their data.

中文简介正在准备中。当前显示英语简介。

  • Installing Wren Engine for the first time
  • Connecting a new database to Wren
  • Creating a project and preparing data definitions
Canner/WrenAI1.8万2026年10月16日 更新

usage

免费

Answer business data questions with Wren CLI by checking model definitions, reusing past queries, and executing SQL or predefined aggregations. The workflow also covers query verification, error diagnosis, and saving successful queries for future use.

中文简介正在准备中。当前显示英语简介。

  • Analyze monthly revenue trends
  • Rank customers by purchase value
  • Compare metrics across plans or regions
Canner/WrenAI1.8万2026年10月16日 更新

查看 Canner 的全部技能

报告此技能的问题