bq-analytics-query

Query bq-analytics data in BigQuery using the bq CLI.

5|Updated Apr 27, 2026
One-click install
npx skills add https://github.com/johnkueh/bq-analytics --skill bq-analytics-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bq-analytics-query
Source: https://github.com/johnkueh/bq-analytics/tree/main/claude-skills/query
Command: npx skills add https://github.com/johnkueh/bq-analytics --skill bq-analytics-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Quickly answer questions about product analytics, funnels, log searches, and user traits by querying bq-analytics data directly in BigQuery through the bq CLI.

Core Features & Use Cases

  • Ad-hoc access to product analytics, funnel metrics, and user traits from the shared bq-analytics schema.
  • Flexible SQL-based exploration across Next.js, Express, Hono, Expo / RN, and CLI runtimes.
  • Use cases include quick data exploration, hypothesis validation, and on-demand reporting without dashboards.

Quick Start

Run a targeted bq query against your project's bq-analytics dataset to retrieve the requested insights.

Frequently Asked Questions about bq-analytics-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run ad-hoc SQL queries for product analytics in BigQuery?

Run ad-hoc SQL queries for product analytics in BigQuery by using the bq CLI to access the shared bq-analytics schema, retrieving insights without needing pre-built dashboards.

What do I need to query bq-analytics data stored in BigQuery?

To query bq-analytics data stored in BigQuery, you need a configured BigQuery dataset and the bq CLI tool installed to access the shared events schema and run standard queries.

Can I query funnel metrics and user traits using SQL with bq CLI?

Yes, you can query funnel metrics and user traits using SQL with the bq CLI, which allows flexible, SQL-based exploration across Next.js, Express, Hono, Expo, and CLI runtimes.

What's the best way to validate product analytics hypotheses without a dashboard?

The best way to validate product analytics hypotheses without a dashboard is running targeted bq queries via the bq CLI against your project's bq-analytics dataset for quick data exploration.

Does bq-analytics work with Next.js and Expo React Native runtimes?

Yes, bq-analytics works with Next.js and Expo React Native runtimes, providing flexible SQL-based exploration that also extends to Express, Hono, and CLI environments.