wren-usage

wren-usage is a skill for Claude Code from Canner/wren-engine. It costs 126 tokens per session (1,581 once invoked), scanned A, original, Apache-2.0.

A general usage guide for Wren Engine, a semantic SQL layer that helps AI agents query more than 22 kinds of data sources. It directs setup, SQL writing, data modeling, project management, and MCP server tasks to focused guides.

In plain words
What is it for?
Use it for day-to-day Wren work, including installing related guides, generating models, managing projects, writing SQL, and setting up connections or an MCP server.
Why use it?
It provides one starting point for choosing the right Wren workflow instead of searching through separate instructions for each task.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin. Also seen: reads .claude/ paths; mentions Claude Code.

Part of the wren plugin — 8 skills shipped together

Good fit Use it for day-to-day Wren work, including installing related guides, generating models, managing projects, writing SQL, and setting up connections or an MCP server.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/canner/wren-engine/wren-usage
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add Canner/wren-engine --skill wren-usage
Clone the repo
git clone --depth 1 https://github.com/Canner/wren-engine

Made for: Claude Code.

Or install wren, the plugin that ships this one along with the rest of its 8 skills.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for wren-usage

README.md
[![agentmods](https://agentmods.dev/badge/skills/canner/wren-engine/wren-usage/github.svg)](https://agentmods.dev/skills/canner/wren-engine/wren-usage)
Your own site
<a href="https://agentmods.dev/skills/canner/wren-engine/wren-usage"><img src="https://agentmods.dev/badge/skills/canner/wren-engine/wren-usage/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for wren-usage

Your own site · 80×15
<a href="https://agentmods.dev/skills/canner/wren-engine/wren-usage"><img src="https://agentmods.dev/badge/skills/canner/wren-engine/wren-usage.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 126 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,581 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00126 $0.01581
Opus 5.5 $0.00050 $0.00632
Sonnet 5.5 $0.00025 $0.00316
Haiku 4.5 $0.00013 $0.00158

Measured 1mo ago against content hash 6117d6c9e798, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

wren-usage scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills-archive/wren-usage/SKILL.md · 169 lines

How it starts

The opening of the file, as written. The whole thing — 169 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Wren Engine — Usage Guide

Version check

Silently fetch https://raw.githubusercontent.com/Canner/wren-engine/main/skills/versions.json. Compare the wren-usage key with this skill's version (from the frontmatter above). If the remote version is newer, notify the user before proceeding:

A newer version of the wren-usage skill is available. Update with:

npx skills add Canner/wren-engine --skill wren-usage --agent claude-code

Then continue with the workflow below regardless of update status.


This skill is your day-to-day reference for working with Wren Engine. It delegates to focused sub-skills for each task.


Step 0 — Install dependent skills (first time only)

Check whether the required skills are already installed in ~/.claude/skills/. If any are missing, tell the user to run:

# Option A — npx skills (works with Claude Code, Cursor, and 30+ agents)
npx skills add Canner/wren-engine --skill '*' --agent claude-code

# Option B — Clawhub (if installed via clawhub)
clawhub install wren-usage

This installs wren-usage and its dependent skills (wren-connection-info, wren-generate-mdl, wren-project, wren-sql, wren-mcp-setup, wren-http-api) into ~/.claude/skills/.

After installation, the user must start a new session for the new skills to be loaded.

If the user only wants the MCP server set up (no Docker yet), use /wren-quickstart for a guided end-to-end walkthrough instead.


What do you want to do?

Identify the user's intent and delegate to the appropriate skill:

Task Skill
Write or debug a SQL query @wren-sql
Connect to a new database / change credentials @wren-connection-info
Generate MDL from an existing database @wren-generate-mdl
Save MDL to YAML files (version control) @wren-project
Load a saved YAML project / rebuild target/mdl.json @wren-project
Add a new model or column to the MDL @wren-project
Start, reset, or reconfigure the MCP server @wren-mcp-setup
Call Wren tools via HTTP JSON-RPC (no MCP SDK) @wren-http-api
First-time setup from scratch @wren-quickstart

Read the full file on GitHub · 169 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 1mo ago First seen · 169 lines · 126 tokens per session scan A 6117d6c9e798

Subscribe to this mod's changes

wren-usage is a skill published in the GitHub repository Canner/wren-engine (660 stars, last pushed 5mo ago), licensed Apache-2.0. It adds 126 tokens to every session and 1,581 once invoked, about $0.0005 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

effective-dbt-sql

Use when writing or modifying dbt model SQL — deciding whether to add a subquery or reuse an existing dimension/metric, structuring a query, joining models, or refactoring a metric's SQL. Encodes SQL semantic-correctness rules: reuse existing fields, prefer CTEs over correlated subqueries, and make joins and column…

lightdash/lightdash · 0 tokens

alibabacloud-data-agent-mcp-skill

Alibaba Cloud Data Agent MCP skill (alibabacloud-data-agent-mcp-skill, data-agent MCP) for enterprise database/file analysis. Use when the user asks (in any language, including Chinese) to query/analyze DMS-managed databases, run SQL/data analysis, start quick-query (lite) or deep-analysis (pro/ultra) sessions…

aliyun/data-agent-skill · 199 tokens

malloy-model

Build Malloy semantic models with base source and joined source files. Use when creating or modifying .malloy files, user asks to "create a malloy model", "add dimensions", "add measures", "create a source", or any Malloy model authoring task.

malloydata/publisher · 59 tokens

eval-import

Turn a list of questions into an eval set, whatever shape it arrived in: a JSONL a customer sent, a CSV, a spreadsheet export, a markdown doc, an email thread, or a pull from production logs. Classify each item by what came WITH the question (a query, a number, prose criteria, or nothing), write cases.jsonl and…

malloydata/publisher · 142 tokens

malloy-model-as-you-go

After answering a data question, write down what the answer assumed so the next reader can trust the number. A field with a #(doc) in the model when you can edit it, an extend in the notebook when you can only author reports, or a stated assumption plus a Malloy snippet when you can only chat. Use after every answered…

malloydata/publisher · 97 tokens

malloy-define

Propose scope, a source plan and field definitions for a Malloy model. Which tables and questions, which sources at what grain, then renames, dimensions and measures, each backed by querying data.

malloydata/publisher · 46 tokens