·bigquery

Query Mozilla telemetry data directly from BigQuery using the bq CLI. Use when the user wants to run SQL against Firefox telemetry, analyze Windows version distribution, count DAU/MAU/WAU, query Glean metrics, or investigate user populations. Triggers on "bigquery", "bq", "telemetry query", "DAU", "MAU", "Windows distribution", "macOS distribution", "Darwin version", "Linux distribution", "kernel version", "client count", "user count", "Glean metrics query", "baseline_clients".

14Installs·0Trend·@jwmossmoz

Installation

$npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery

How to Install bigquery

Quickly install bigquery AI skill to your development environment via command line

  1. Open Terminal: Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.)
  2. Run Installation Command: Copy and run this command: npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery
  3. Verify Installation: Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Source: jwmossmoz/agent-skills.

SKILL.md

View raw

If queries fail with "Access Denied", the billing project likely lacks permissions. Try --projectid=mozdata.

Choose the right table — this is the most important optimization:

| Windows version distribution | telemetry.windows10aggregate | Pre-aggregated, instant | | DAU/MAU by standard dimensions | firefoxdesktopderived.activeusersaggregatesv3 | Pre-computed, 100x faster | | DAU with custom dimensions | firefoxdesktop.baselineclientsdaily | One row per client per day |

Query Mozilla telemetry data directly from BigQuery using the bq CLI. Use when the user wants to run SQL against Firefox telemetry, analyze Windows version distribution, count DAU/MAU/WAU, query Glean metrics, or investigate user populations. Triggers on "bigquery", "bq", "telemetry query", "DAU", "MAU", "Windows distribution", "macOS distribution", "Darwin version", "Linux distribution", "kernel version", "client count", "user count", "Glean metrics query", "baseline_clients". Source: jwmossmoz/agent-skills.

Facts (cite-ready)

Stable fields and commands for AI/search citations.

Install command
npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery
Category
{}Data Analysis
Verified
First Seen
2026-02-21
Updated
2026-03-10

Browse more skills from jwmossmoz/agent-skills

Quick answers

What is bigquery?

Query Mozilla telemetry data directly from BigQuery using the bq CLI. Use when the user wants to run SQL against Firefox telemetry, analyze Windows version distribution, count DAU/MAU/WAU, query Glean metrics, or investigate user populations. Triggers on "bigquery", "bq", "telemetry query", "DAU", "MAU", "Windows distribution", "macOS distribution", "Darwin version", "Linux distribution", "kernel version", "client count", "user count", "Glean metrics query", "baseline_clients". Source: jwmossmoz/agent-skills.

How do I install bigquery?

Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Where is the source repository?

https://github.com/jwmossmoz/agent-skills