Official agent skill

Stmo

by SAP in SAP/project-foxhound

Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli.

OfficialGPL-3.0Auto-check passedDatabases

Install Stmo

skills CLI
$ npx skills add SAP/project-foxhound --skill stmo -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install SAP/project-foxhound stmo --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/stmo .claude/skills/stmo && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
stmo
GitHub stars
180
Used in
1 other repo
Token cost
~1.8k tokens
SKILL.md length
592 words
Files
1
Skills in repo
10
Repo updated
First seen
Licence
GPL-3.0

At a glance

Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli.

  • Works in 5 steps: Find data sources → Discover existing queries → Fetch and read an existing query → …
  • The user wants to explore telemetry data on STMO
  • SKILL.md covers Prerequisites, Working directory, Data exploration workflow and Bootstrap context from…, plus 7 more sections
  • Reaches sql.telemetry.mozilla.org; needs REDASH_API_KEY

What it does

Stmo is an agent skill from SAP/project-foxhound, published by the product's own GitHub organization. Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli. Use when the user wants to explore telemetry data on STMO, write, deploy, or execute Redash queries, manage dashboards, or discover data sources. Also trigger on mentions of STMO, Redash, sql.telemetry.mozilla.org, or when the user wants to query Mozilla telemetry data (as opposed to probe/metric discovery, which is mozdata territory).

Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL. It works with SQL. The repository describes itself as: A web browser with dynamic data-flow tracking enabled in the Javascript engine and DOM, based on Mozilla Firefox (https://github.com/mozilla-firefox/firefox). It can be used to… The licence is GPL-3.0.

When your agent uses it

  • The user wants to explore telemetry data on STMO
  • Execute Redash queries
  • Manage dashboards
  • Discover data sources

Example prompts

  • “/stmo”

Requirements

  • Python 3
  • A credential in REDASH_API_KEY
  • Pre-approved tools (allowed-tools): Bash(stmo-cli:*), Bash(mkdir:*), Read, Grep, Glob

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Find data sources
  2. Discover existing queries
  3. Fetch and read an existing query
  4. Execute
  5. Clean up newly created queries

What it can do on your machine

Read from SKILL.md and the folder at commit 9dcb850. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Bash(stmo-cli:*)
    • Bash(mkdir:*)
    • Read
    • Grep
    • Glob

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are bash and yaml).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • sql.telemetry.mozilla.org

    Also links to:

    • docs.google.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names these keys or tokens, usually read from environment variables:

    • REDASH_API_KEY

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Stmo loads about 1.8k tokens when it runs. Until then it costs about 110 tokens; SKILL.md has 592 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~110
When it runs · the whole SKILL.md, loaded when a task matches
~1.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from SAP/project-foxhound at commit 9dcb850, republished under its GPL-3.0 licence (© SAP). 592 words, ~1,753 tokens.

Download SKILL.mdSave it as .claude/skills/stmo/SKILL.md (or your agent's skills folder).
name
stmo
description
Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli. Use when the user wants to explore telemetry data on STMO, write, deploy, or execute Redash queries, manage dashboards, or discover data sources. Also trigger on mentions of STMO, Redash, sql.telemetry.mozilla.org, or when the user wants to query Mozilla telemetry data (as opposed to probe/metric discovery, which is mozdata territory).
allowed-tools
Bash(stmo-cli:*), Bash(mkdir:*), Read, Grep, Glob

stmo-cli

CLI for managing queries and dashboards on Mozilla's Redash instance (sql.telemetry.mozilla.org).

Prerequisites

Before running any stmo-cli command (except init and update), verify REDASH_API_KEY is set. If missing, every command fails immediately with:

Error: REDASH_API_KEY environment variable not set

To get the key, go to https://sql.telemetry.mozilla.org/users/me (API Key section), copy the key, and export it:

bash
export REDASH_API_KEY=your_key_here

If stmo-cli is not available, install it via ./mach bootstrap.

Working directory

stmo-cli creates queries/ and dashboards/ relative to the current directory. Never run file-creating commands from the Firefox repo tree. Always use the artifacts/stmo/ directory, which is already VCS-ignored:

bash
mkdir -p artifacts/stmo
cd artifacts/stmo

Queries created during exploration are ephemeral: fetch → execute → archive → done.

The temp directory is not a git repo, so stmo-cli deploy (which uses git diff to detect changes) won't work — always use stmo-cli deploy --all instead.

Data exploration workflow

  1. Find data sources

    bash
    stmo-cli data-sources
    stmo-cli data-sources <id> --schema
  2. Discover existing queries

    bash
    stmo-cli discover
  3. Fetch and read an existing query

    bash
    stmo-cli fetch <id>
    # reads: queries/<id>-*.sql and queries/<id>-*.yaml
  4. Execute

    bash
    stmo-cli execute <id> --format table --limit 50
    stmo-cli execute <id> --format json --limit 50
    stmo-cli execute <id> --param key=value
    stmo-cli execute <id> --param channels='["release","beta"]'  # multi-value enum: always JSON array
    stmo-cli execute <id> --interactive  # prompts for parameter values
  5. Clean up newly created queries

    If you created a new query (the id: 0 → deploy flow) and it's not worth keeping, archive it — throwaway queries clutter the Redash account:

    bash
    stmo-cli archive <id>

    If the query is useful or you want to share it with others, leave it in Redash instead. The same applies to dashboards created during exploration — archive with stmo-cli dashboards archive <slug> if throwaway, leave if worth sharing.

    Do not archive queries or dashboards you only fetched to read — that would delete them from Redash.

    To restore an archived query:

    bash
    stmo-cli unarchive <id>
    stmo-cli fetch <id>

Bootstrap context from existing queries

Before answering a new data question, fetch the user's existing queries to understand what tables, patterns, and SQL style they already use:

bash
stmo-cli fetch --all

Then read the downloaded .sql files to learn which tables are queried, how filters are structured, and what metrics are already tracked. This makes new queries fit naturally into the user's existing work.

Beyond Redash: export and analyze

When Redash isn't sufficient — complex statistics, rich visualizations, or analysis over large result sets — export the raw data and analyze it locally:

bash
stmo-cli execute <id> --format json --limit 10000 2>/dev/null > data.json

From there:

  • DuckDB or SQLite for SQL-based analysis over the exported data
  • Python + pandas/scipy/numpy for real statistics (mean/median alone is almost always wrong)
  • Apache Echarts for rich interactive charts in HTML/JS that handle large datasets well
  • Jinja2 for templating if generating reports

A static website updated via cron (behind SSO) is a proven pattern for sharing results within Mozilla — see the App Engine static site with IAP runbook.

Show full SKILL.md (251 more words)Show less

SQL style

STMO queries run on BigQuery. Use BigQuery SQL syntax: backtick-quoted identifiers, DATE_ADD(date, INTERVAL N DAY), FORMAT_DATE, APPROX_COUNT_DISTINCT, etc.

mozdata integration

Use the mozdata MCP tools (mozdata:probe-discovery, mozdata:query-writing) to find the right telemetry probes, metrics, and table schemas. Then use stmo-cli to write, deploy, and execute the actual Redash queries.

Query management

Create a new query:

  1. Create queries/0-{slug}.sql with the SQL

  2. Create queries/0-{slug}.yaml with metadata:

    yaml
    id: 0
    name: My Query Name
    data_source_id: <id from stmo-cli data-sources>
    options:
      parameters: []
    visualizations: []

    Both options (with parameters) and visualizations are required even when empty.

    Do not add a default Table visualization — Redash creates one automatically for every new query.

    Slug rule: stmo-cli derives the expected SQL filename by slugifying the name field — non-alphanumeric chars become -, consecutive dashes collapse, apostrophes are stripped (e.g. "Mozilla's .rpm" → mozilla-s-rpm). The {slug} in both filenames must match this transform.

  3. For enum parameters, use YAML multiline format — escaped newlines (\\n) are not valid:

    yaml
    options:
      parameters:
      - name: normalized_channels
        title: normalized_channels
        type: enum
        value:
        - release
        enumOptions: |-
          nightly
          aurora
          beta
          release
          esr
        multiValuesOptions:
          prefix: ''''
          suffix: ''''
          separator: ','
  4. Deploy:

    bash
    stmo-cli deploy --all
  5. Sync the server-assigned ID:

    bash
    stmo-cli fetch <new-id>  # renames local files to {new-id}-{slug}.*

Dashboard management

Dashboards are addressed by slug, not ID.

bash
stmo-cli dashboards discover                    # only shows favorited dashboards
stmo-cli dashboards fetch <slug>
stmo-cli dashboards deploy <slug>
stmo-cli dashboards deploy --all
stmo-cli dashboards archive <slug>
stmo-cli dashboards unarchive <slug>

Create: dashboards/0-{slug}.yaml with id: 0, deploy, file auto-renames with real ID.

Command reference

Run stmo-cli --help — stmo-cli outputs LLM-optimized help when run inside an AI coding environment (CLAUDECODE is set automatically).

File format

queries/{id}-{slug}.sql    # SQL text
queries/{id}-{slug}.yaml   # metadata: name, data_source_id, options, visualizations
dashboards/{id}-{slug}.yaml

New queries/dashboards use id: 0 in the filename until deployed.

© SAP, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/stmo of SAP/project-foxhound.

Open the folder on GitHubat commit 9dcb850

Used in 1 other repository

We found 3 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in SAP/project-foxhound, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Stmo next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Stmo compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Stmo this skillSAP/project-foxhound1801 repos~1.8kAutomated safety check: PassGPL-3.0
Evolving The Data ModelTriliumNext/Trilium38k—~2.1kAutomated safety check: PassAGPL-3.0
SQL Optimization Patternsynulihao/AgentSkillOS61710 repos~3.3kAutomated safety check: PassNone
SQL PortabilityHL7/sql-on-fhir150—~512Automated safety check: PassCustom licence
DB Migrationskurealnum/dotfiles290—~820Automated safety check: PassNone
Contact FilterChatbotXIO/ChatbotX878—~2.5kAutomated safety check: PassCustom licence

Similar skills

  • Evolving The Data Model

    TriliumNext/Trilium

    A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to…

    38k GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed
  • SQL Optimization Patterns

    ynulihao/AgentSkillOS

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

    617 GitHub starsUsed in 10 repos~3.3k tokens
    DatabasesAuto-check passed
  • SQL Portability

    HL7/sql-on-fhir

    Analyse whether a SQL query is portable across database implementations using sqlglot transpilation.

    150 GitHub stars~512 tokensUpdated yesterday
    DatabasesAuto-check passed
  • DB Migrations

    kurealnum/dotfiles

    A skill your agent uses when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration…

    290 GitHub stars~820 tokensUpdated 5 mo ago
    DatabasesAuto-check passed
  • Contact Filter

    ChatbotXIO/ChatbotX

    Work with the ChatbotX contact filter system — the shared filter model behind the contacts list, conversations, and broadcast audiences.

    878 GitHub stars~2.5k tokensUpdated today
    DatabasesAuto-check passed
  • Add Utils Function

    MichealWayne/fe-tools

    Add or modify utility functions in fe-tools. An agent skill from MichealWayne/fe-tools.

    207 GitHub stars~602 tokensUpdated 29 days ago
    DatabasesAuto-check passed

More from SAP/project-foxhound

All 10 skills in this repo
  • Accessibility Frontend Review

    SAP/project-foxhound

    Official

    Performs an accessibility code review of a local diff or Phabricator revision in the style of the Firefox accessibility team.

    180 GitHub starsUsed in 1 repo~3.2k tokens
    Auto-check passed
  • JS Perf Investigation

    SAP/project-foxhound

    Official

    Structured performance opportunity investigation for SpiderMonkey (the Firefox JavaScript engine).

    180 GitHub starsUsed in 1 repo~4.1k tokens
    Auto-check passed
  • Bug Filing

    SAP/project-foxhound

    Official

    File a Bugzilla bug for Firefox/Gecko work, or draft a bug summary and description.

    180 GitHub starsUsed in 1 repo~828 tokens
    Auto-check passed
  • Specmap

    SAP/project-foxhound

    Official

    Map relationships between a web spec section, its Firefox implementation code, and Web Platform Tests.

    180 GitHub starsUsed in 1 repo~1.3k tokens
    Auto-check passed
  • Android New Module

    SAP/project-foxhound

    Official

    Guide for creating new Android gradle modules in the android-components project.

    180 GitHub starsUsed in 1 repo~1.8k tokens
    Auto-check passed
  • Profiler Analysis

    SAP/project-foxhound

    Official

    Analyze Firefox performance profiles using the profiler-cli CLI tool.

    180 GitHub starsUsed in 1 repo~1.1k tokens
    Auto-check passed

Works with

Categories

Questions about Stmo

What does Stmo do?

Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli. Stmo is an agent skill from SAP/project-foxhound, published by the product's own GitHub organization.org) using stmo-cli.

When should I use Stmo?

Stmo fits situations like: the user wants to explore telemetry data on STMO; execute Redash queries; manage dashboards; discover data sources.

How do I install Stmo in Claude Code?

Run `npx skills add SAP/project-foxhound --skill stmo -a claude-code`. Or copy the skill folder (.agents/skills/stmo in SAP/project-foxhound) into .claude/skills/stmo in your project. Claude Code loads it when a task matches its description.

How do I install Stmo in Codex?

Run `npx skills add SAP/project-foxhound --skill stmo -a codex`. Or copy the skill folder (.agents/skills/stmo in SAP/project-foxhound) into .agents/skills/stmo in your project. Codex loads it when a task matches its description.

Can I use Stmo in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add SAP/project-foxhound --skill stmo -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/stmo, .gemini/skills/stmo, .github/skills/stmo and .opencode/skills/stmo in your project.

What does Stmo need to run?

Going by SKILL.md and its folder, Stmo needs credentials named REDASH_API_KEY. Our summary lists: Python 3; A credential in REDASH_API_KEY. Its frontmatter pre-approves these tools: Bash(stmo-cli:*), Bash(mkdir:*), Read, Grep, Glob.

Does Stmo access the network?

SKILL.md names 2 domains. In commands or code: sql.telemetry.mozilla.org; the agent is likely to contact it when it follows the instructions. As links in the text: docs.google.com. This is read from the text; nothing was executed.

Is Stmo safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Stmo use?

Stmo is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Stmo use?

About 1.8k tokens (SKILL.md is roughly 7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Stmo?

Skills that share tags, products or a category with Stmo: Evolving The Data Model (TriliumNext/Trilium, 38k stars), SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), SQL Portability (HL7/sql-on-fhir, 150 stars) and DB Migrations (kurealnum/dotfiles, 290 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Stmo?

SAP (a GitHub organization, an official publisher) maintains it in SAP/project-foxhound, which has 180 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on October 6, 2026.

Source: SAP/project-foxhound on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.