mcpField
W
wren

wren

github.com/cannerData & databases18.0k1.5k installsUpdated 1d ago
Repository

About wren

wren is a discovery skill for the wren CLI; its workflow guides and prompt helpers are fetched from the installed CLI version. It serves users building data workflows, with commands for SQL, MDL, connections, and semantic memory.

Key features

  1. 01List and retrieve workflow guides
  2. 02Fetch reference documentation
  3. 03Wrap questions for agents in guided or direct mode
  4. 04Run SQL through the MDL layer
  5. 05Manage context and connection profiles
  6. 06Use semantic memory commands

Use cases

  1. 01Follow Wren onboarding and querying guides
  2. 02Generate MDL from a database schema
  3. 03Connect SaaS sources with dlt
  4. 04Add business context or deploy a GenBI app

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/canner/wrenai --skill wren

After installing, type/wrenin Claude Code to confirm it loaded.

Details

From the project README

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.

Comments

Markdown supported