# Redash

> >

- **Type:** Skill
- **Install:** `agentstack add skill-mozilla-platform-ops-agent-skills-redash`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [mozilla-platform-ops](https://agentstack.voostack.com/s/mozilla-platform-ops)
- **Installs:** 0
- **Category:** [Developer Tools](https://agentstack.voostack.com/c/developer-tools)
- **Latest version:** 0.1.0
- **License:** MPL-2.0
- **Upstream author:** [mozilla-platform-ops](https://github.com/mozilla-platform-ops)
- **Source:** https://github.com/mozilla-platform-ops/agent-skills/tree/main/skills/redash
- **Website:** https://agentskills.io/home

## Install

```sh
agentstack add skill-mozilla-platform-ops-agent-skills-redash
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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

```bash
# 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 x86_64 |
| "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 darwin_version |
| "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](https://github.com/mozilla-platform-ops)
- **Source:** [mozilla-platform-ops/agent-skills](https://github.com/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.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-mozilla-platform-ops-agent-skills-redash
- Seller: https://agentstack.voostack.com/s/mozilla-platform-ops
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.