bq-query-optimization
BigQuery Query Optimization
Use this skill when writing, debugging, or optimizing BigQuery SQL queries for performance and efficiency.
Query Execution Analysis
Using EXPLAIN
-- Get execution plan
EXPLAIN SELECT * FROM `project.dataset.table` WHERE condition;
-- Get execution plan with runtime stats
EXPLAIN ANALYZE SELECT * FROM `project.dataset.table` WHERE condition;
What the plan shows:
- Stages of execution
- Bytes read per stage
More from funnelenvy/agents_webinar_demos
gemini-qa
Use Google Gemini CLI to answer questions about code, analyze files, or perform codebase exploration. Invoke this skill when the user asks to use Gemini, wants a second opinion from another AI, or wants to compare Claude's answer with Gemini's response.
25n8n-workflow
Use when creating, deploying, or managing N8N workflows. Automatically uses N8N_HOST and N8N_API_KEY from environment.
22playwright-browser
Use when capturing screenshots, automating browser interactions, or scraping web content. Covers Playwright Python API for page navigation, screenshots, element selection, form filling, and waiting strategies.
21hubspot-crm
Use when syncing contacts or lists to HubSpot CRM. Automatically uses HUBSPOT_API_TOKEN from environment.
20gcp-cli-gotchas
Use when encountering gcloud or bq CLI formatting errors, quote escaping issues, command substitution problems, or when debugging CLI commands. Provides solutions for backtick usage, heredoc syntax, timestamp filters, parameter escaping, and multiline command formatting.
12codex-qa
Use OpenAI Codex CLI to answer questions about code, analyze files, or perform read-only codebase exploration. Invoke this skill when the user asks to use Codex, wants a second opinion from another AI agent, or wants to compare Claude's answer with Codex's response.
10