Now liveThe Skillselion MCP - thousands of ranked skills, loaded into your agent mid-task. No install.Get it →
canner avatar

Wren

  • 679 installs
  • 16.8k repo stars
  • Updated August 5, 2026
  • canner/wrenai

A Wren CLI discovery stub that provides a semantic SQL layer over 22+ databases and exposes workflow guides for querying and setup.

About

Acts as a discovery stub for the Wren CLI, a semantic SQL layer over 22+ databases whose workflow guides live inside the CLI. A developer uses it to answer data questions, connect databases or SaaS sources, and scaffold or query MDL projects.

  • Semantic SQL over Postgres, BigQuery, Snowflake, Spark, and more
  • Fetches onboarding, usage, MDL, and dlt workflow guides from the CLI

Wren by the numbers

  • 679 all-time installs (skills.sh)
  • Ranked #107 of 911 Databases skills by installs in the Skillselion catalog
  • Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/canner/wrenai --skill wren

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

Listed on Skillselion
Installs679
repo stars16.8k
Last updatedAugust 5, 2026
Repositorycanner/wrenai

What it does

A Wren CLI discovery stub that provides a semantic SQL layer over 22+ databases and exposes workflow guides for querying and setup.

Files

SKILL.mdMarkdownGitHub ↗

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 wren-engine 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.

Related skills

Databasesdatabasesanalytics

This week in AI coding

Five minutes, every Monday - the tools, releases and tactics for developers.

unsubscribe anytime.