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…
Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli.
$ npx skills add SAP/project-foxhound --skill stmo -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install SAP/project-foxhound stmo --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ 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-srcUse ~/.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/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .claude/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmoType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add SAP/project-foxhound --skill stmo -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install SAP/project-foxhound stmo --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/stmo .agents/skills/stmo && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .agents/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add SAP/project-foxhound --skill stmo -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install SAP/project-foxhound stmo --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/stmo .cursor/skills/stmo && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .cursor/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/SAP/project-foxhound.git --path .agents/skills/stmo--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add SAP/project-foxhound --skill stmo -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install SAP/project-foxhound stmo --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/stmo .gemini/skills/stmo && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .gemini/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install SAP/project-foxhound stmoInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add SAP/project-foxhound --skill stmo -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/stmo .github/skills/stmo && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .github/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add SAP/project-foxhound --skill stmo -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install SAP/project-foxhound stmo --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/SAP/project-foxhound.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/stmo .opencode/skills/stmo && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "stmo" agent skill from https://github.com/SAP/project-foxhound/tree/main/.agents/skills/stmo into .opencode/skills/stmo/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "stmo", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
stmoManage 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. 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.
5 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 9dcb850. It shows what the files ask for, not the result of running them.
Pre-approves these tools, so the agent can use them without asking each time:
Bash(stmo-cli:*)Bash(mkdir:*)ReadGrepGlobFrom allowed-tools in the SKILL.md frontmatter.
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.
Hosts in commands or code, which the agent is likely to contact:
sql.telemetry.mozilla.orgAlso links to:
docs.google.comFrom URLs in SKILL.md, links to its own repository left out.
Names these keys or tokens, usually read from environment variables:
REDASH_API_KEYFrom names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
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.
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.
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.
The full file from SAP/project-foxhound at commit 9dcb850, republished under its GPL-3.0 licence (© SAP). 592 words, ~1,753 tokens.
.claude/skills/stmo/SKILL.md (or your agent's skills folder).CLI for managing queries and dashboards on Mozilla's Redash instance (sql.telemetry.mozilla.org).
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 setTo get the key, go to https://sql.telemetry.mozilla.org/users/me (API Key section), copy the key, and export it:
export REDASH_API_KEY=your_key_hereIf stmo-cli is not available, install it via ./mach bootstrap.
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:
mkdir -p artifacts/stmo
cd artifacts/stmoQueries 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.
Find data sources
stmo-cli data-sources
stmo-cli data-sources <id> --schemaDiscover existing queries
stmo-cli discoverFetch and read an existing query
stmo-cli fetch <id>
# reads: queries/<id>-*.sql and queries/<id>-*.yamlExecute
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 valuesClean 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:
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:
stmo-cli unarchive <id>
stmo-cli fetch <id>Before answering a new data question, fetch the user's existing queries to understand what tables, patterns, and SQL style they already use:
stmo-cli fetch --allThen 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.
When Redash isn't sufficient — complex statistics, rich visualizations, or analysis over large result sets — export the raw data and analyze it locally:
stmo-cli execute <id> --format json --limit 10000 2>/dev/null > data.jsonFrom there:
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.
STMO queries run on BigQuery. Use BigQuery SQL syntax: backtick-quoted identifiers, DATE_ADD(date, INTERVAL N DAY), FORMAT_DATE, APPROX_COUNT_DISTINCT, etc.
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.
Create a new query:
Create queries/0-{slug}.sql with the SQL
Create queries/0-{slug}.yaml with metadata:
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.
For enum parameters, use YAML multiline format — escaped newlines (\\n) are not valid:
options:
parameters:
- name: normalized_channels
title: normalized_channels
type: enum
value:
- release
enumOptions: |-
nightly
aurora
beta
release
esr
multiValuesOptions:
prefix: ''''
suffix: ''''
separator: ','Deploy:
stmo-cli deploy --allSync the server-assigned ID:
stmo-cli fetch <new-id> # renames local files to {new-id}-{slug}.*Dashboards are addressed by slug, not ID.
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.
Run stmo-cli --help — stmo-cli outputs LLM-optimized help when run inside an AI coding environment (CLAUDECODE is set automatically).
queries/{id}-{slug}.sql # SQL text
queries/{id}-{slug}.yaml # metadata: name, data_source_id, options, visualizations
dashboards/{id}-{slug}.yamlNew 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
Just SKILL.md in .agents/skills/stmo of SAP/project-foxhound.
Open the folder on GitHubat commit 9dcb850
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.
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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Stmo this skillSAP/project-foxhound | 180 | 1 repos | ~1.8k | Automated safety check: Pass | GPL-3.0 | |
| Evolving The Data ModelTriliumNext/Trilium | 38k | — | ~2.1k | Automated safety check: Pass | AGPL-3.0 | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 10 repos | ~3.3k | Automated safety check: Pass | None | |
| SQL PortabilityHL7/sql-on-fhir | 150 | — | ~512 | Automated safety check: Pass | Custom licence | |
| DB Migrationskurealnum/dotfiles | 290 | — | ~820 | Automated safety check: Pass | None | |
| Contact FilterChatbotXIO/ChatbotX | 878 | — | ~2.5k | Automated safety check: Pass | Custom licence |
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…
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
HL7/sql-on-fhir
Analyse whether a SQL query is portable across database implementations using sqlglot transpilation.
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…
ChatbotXIO/ChatbotX
Work with the ChatbotX contact filter system — the shared filter model behind the contacts list, conversations, and broadcast audiences.
MichealWayne/fe-tools
Add or modify utility functions in fe-tools. An agent skill from MichealWayne/fe-tools.
SAP/project-foxhound
Performs an accessibility code review of a local diff or Phabricator revision in the style of the Firefox accessibility team.
SAP/project-foxhound
Structured performance opportunity investigation for SpiderMonkey (the Firefox JavaScript engine).
SAP/project-foxhound
File a Bugzilla bug for Firefox/Gecko work, or draft a bug summary and description.
SAP/project-foxhound
Map relationships between a web spec section, its Firefox implementation code, and Web Platform Tests.
SAP/project-foxhound
Guide for creating new Android gradle modules in the android-components project.
SAP/project-foxhound
Analyze Firefox performance profiles using the profiler-cli CLI tool.
Works with
Categories
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.
Stmo fits situations like: the user wants to explore telemetry data on STMO; execute Redash queries; manage dashboards; discover data sources.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.