rill-metrics-view

rill-metrics-view is a skill for Claude Code from rilldata/agent-skills. It costs 18 tokens per session (7,506 once invoked), scanned A, original, Apache-2.0.

Instructions for building metrics views in Rill. A metrics view is a queryable layer that defines business measurements on top of an analytical database table and feeds dashboards, alerts, reports, and APIs.

In plain words
What is it for?
Creating and validating Rill metrics-view resources, choosing their table source, and preparing metrics for exploration dashboards, canvas dashboards, alerts, reports, or custom APIs.
Why use it?
It explains how to connect metrics to project models or external tables and how those metrics are used by Rill features. This reduces mistakes when defining the data layer behind charts and reports.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin. Also seen: positional $N argument.

Part of the rill plugin — 9 skills, 1 MCP server shipped together

Good fit Creating and validating Rill metrics-view resources, choosing their table source, and preparing metrics for exploration dashboards, canvas dashboards, alerts, reports, or custom APIs.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/rilldata/agent-skills/rill-metrics-view
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 rilldata/agent-skills --skill rill-metrics-view
Clone the repo
git clone --depth 1 https://github.com/rilldata/agent-skills

Made for: Claude Code.

Or install rill, the plugin that ships this one along with the rest of its 9 skills, 1 MCP server.

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 rill-metrics-view

README.md
[![agentmods](https://agentmods.dev/badge/skills/rilldata/agent-skills/rill-metrics-view.svg)](https://agentmods.dev/skills/rilldata/agent-skills/rill-metrics-view)
Your own site
<a href="https://agentmods.dev/skills/rilldata/agent-skills/rill-metrics-view"><img src="https://agentmods.dev/badge/skills/rilldata/agent-skills/rill-metrics-view.svg" alt="Measured on agentmods" height="20"></a>
Per session 18 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 7,506 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.00018 $0.07506
Opus 5 $0.00009 $0.03753
Sonnet 5 $0.00004 $0.01501
Haiku 4.5 $0.00002 $0.00751

Measured 8d ago against content hash fba63e563760, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

rill-metrics-view 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 8d 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/rill-metrics-view/SKILL.md · 772 lines

How it starts

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

Instructions for developing a metrics view in Rill

Introduction

Metrics views are resources that define queryable business metrics on top of a table in an OLAP database. They implement what other business intelligence tools call a "semantic layer" or "metrics layer".

Metrics views are lightweight resources that only perform validation when reconciled. They are typically found downstream of connectors and models in the project's DAG. They power many user-facing features:

  • Explore dashboards: Interactive drill-down interfaces for data exploration
  • Canvas dashboards: Custom chart and table components
  • Alerts: Notifications when data meets certain criteria
  • Reports: Scheduled data exports and summaries
  • Custom APIs: Programmatic access to metrics

Core Concepts

Table source

The model: property specifies the underlying table that powers the metrics view. It can reference:

  1. A model in the project: Just use the model name (e.g., model: events)
  2. An external table: Specify the table name as it exists in the OLAP connector
# Referencing a model in the project
model: events

# Referencing an external table (connector defaults to project's default OLAP)
connector: clickhouse  # Optional: specify if different from default
model: my_external_table # Note: Doesn't support dot syntax for database/schema name. Use the separate `database:` or `database_schema:` keys for that if relevant (but try without first and see if that works).

Note: The table: property is a legacy alias for referencing external tables. Always prefer model: in new metrics views.

Timeseries

The timeseries: property identifies the timestamp column used for time-based filtering and line charts. This column must be a time/timestamp type in the underlying table.

timeseries: event_time

If the timeseries column is not listed in dimensions:, Rill automatically adds it as a time dimension. You can optionally configure additional time-related settings:

Read the full file on GitHub · 772 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. 8d ago First seen · 772 lines · 18 tokens per session scan A fba63e563760

Subscribe to this mod's changes

rill-metrics-view is a skill published in the GitHub repository rilldata/agent-skills (0 stars, last pushed 3d ago), licensed Apache-2.0. It adds 18 tokens to every session and 7,506 once invoked, about $0.0001 per session on Opus 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

systematic-debugging

Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes.

obra/superpowers · 21 tokens

local-ai-agents

Build local-first AI agents that run entirely on a developer workstation with Microsoft Foundry Local and Qwen function-calling models. Covers Small Language Models (SLMs), the OpenAI-compatible local endpoint, sandboxed local tools, local RAG with Chroma, local MCP servers, hybrid cloud/local routing, and the…

microsoft/ai-agents-for-beginners · 200 tokens

next-cache-components-adoption

Turn on Cache Components in a Next.js app and resolve the blocking routes it surfaces. Use when the user wants to enable, adopt, or migrate to Cache Components, flip the cacheComponents flag, work through a flood of blocking-prerender / instant validation errors, run the cache-components-instant-false codemod, or…

vercel/next.js · 95 tokens

next-partial-prefetching-adoption

Turn on Partial Prefetching in a Next.js app and work through the insights it surfaces. Use when the user wants to enable or adopt Partial Prefetching, flip the partialPrefetching flag, opt routes in with export const prefetch = 'partial', audit Link prefetch={true} behavior, preserve existing prefetched UI with…

vercel/next.js · 103 tokens

chronicle

Analyze Copilot session history for standup reports, usage tips, session search, and session reindexing. Use when the user asks for a standup, daily summary, usage tips, workflow recommendations, wants to search or find past sessions by keyword/file/PR, wants to reindex their session store, or asks about deleting…

microsoft/vscode · 72 tokens

babysit-pr

Babysit a GitHub pull request after creation by continuously polling review comments, CI checks/workflow runs, and mergeability state until the PR is merged/closed or user help is required. Diagnose failures, retry likely flaky failures up to 3 times, auto-fix/push branch-related issues when appropriate, and keep…

openai/codex · 114 tokens