Redash

Redash Query Tool

Query Mozilla's Redash (sql.telemetry.mozilla.org) for telemetry data. Redash is the front-end to BigQuery telemetry data.

Knowledge References

@references/README.md @references/fxci-schema.md

Prerequisites

• REDASH_API_KEY environment variable set
• uv for running the script

Quick Start

# Run custom SQL
uv run scripts/query_redash.py --sql "SELECT * FROM telemetry.main LIMIT 10"

# Fetch cached results from an existing Redash query
uv run scripts/query_redash.py --query-id 65967

# Save results to file
uv run scripts/query_redash.py --sql "SELECT 1" --output ~/moz_artifacts/data.json

Usage

Either --sql or --query-id is required.

| Flag | Description | |------|-------------| | --sql | SQL query to execute against BigQuery via Redash | | --query-id | Fetch cached results from an existing Redash query ID | | --output, -o | Save results to JSON file | | --format, -f | Output format: json, csv, table (default: table) | | --limit | Limit number of rows displayed |

Example Prompts

These natural language prompts map to queries in references/common-queries.md:

| Prompt | Query used | |--------|------------| | "What's the DAU breakdown by macOS version?" | --query-id 114866 (macOS Version DAU) | | "Show me macOS version × architecture distribution" | --query-id 114867 (macOS version × arch) | | "What share of macOS users are on Apple Silicon?" | --query-id 114867, compare aarch64 vs x8664 | | "Pull the macOS DAU and arch breakdown for the last 28 days" | --query-id 114866 and --query-id 114867 | | "What Windows versions are Firefox Desktop users on?" | --query-id 65967 (Windows Version Distribution) | | "How many Firefox users are on Windows 11?" | --query-id 65967 | | "What does the macOS adoption curve look like over time?" | --query-id 114866, look at darwinversion | | "Why is a worker pool showing high queue time?" | Use the FXCI worker-pool queue-time query in references/common-queries.md | | "What task groups are driving queue time for a worker pool?" | Use the FXCI worker-pool queue-time queries in references/common-queries.md |

For questions not covered by a documented query, write SQL on the fly using the table references in references/README.md.

Common Queries

@references/common-queries.md

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: mozilla-platform-ops
• Source: mozilla-platform-ops/agent-skills
• License: MPL-2.0
• Homepage: https://agentskills.io/home

Install and usage instructions live in the source repository linked above.