praveenmaiya/bq-query
.claude/skills/bq-query/SKILL.md
Execute BigQuery SQL queries using bq CLI. Use when user asks to run SQL, query data, extract features, or interact with BigQuery tables.
tools
Updated Apr 17, 2026
$ install --global
skillsauthnpx skillsauth add praveenmaiya/holley-rec bq-queryInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 17, 2026, 8:22 AM4.9s1 file scanned
SKILL.md
- name:
- bq-query
- description:
- Execute BigQuery SQL queries using bq CLI. Use when user asks to run SQL, query data, extract features, or interact with BigQuery tables.
- allowed-tools:
- Bash, Read, Glob
BigQuery Query Skill
When to Use
- Running SQL queries against BigQuery
- Extracting data for analysis
- Creating or updating tables
- Validating SQL syntax
Commands
Run a query from file
bq query --use_legacy_sql=false --format=prettyjson < sql/recommendations/extract/query.sql
Run with parameters
bq query --use_legacy_sql=false \
--parameter='start_date:DATE:2024-01-01' \
--parameter='end_date:DATE:2024-01-02' \
< sql/recommendations/extract/users.sql
Dry run (estimate cost, validate syntax)
bq query --dry_run --use_legacy_sql=false < sql/recommendations/extract/query.sql
Run inline query
bq query --use_legacy_sql=false "SELECT COUNT(*) FROM \`project.dataset.table\`"
Conventions
- SQL files are in
sql/recommendations/organized by ETL stage - Always use
--use_legacy_sql=false(standard SQL) - Check
agent_docs/bigquery_patterns.mdfor naming conventions - Use
--dry_runfirst for large queries to estimate cost
Test Mode
For development, limit results:
bq query --use_legacy_sql=false --max_rows=1000 < query.sql
Related Skills
praveenmaiya/weekly-update
testing
VerifiedTrustedCommunity
Generate a team-facing weekly status update from STATUS_LOG.md and git history.
SKILL.mdUpdated Apr 17, 2026
praveenmaiya/validate
testing
VerifiedTrustedCommunity
Run QA validation checks on the recommendation pipeline output. Use after pipeline runs to verify data quality.
SKILL.mdUpdated Apr 17, 2026
praveenmaiya/uplift
research
VerifiedTrustedCommunity
Compare Personalized vs Static treatment performance with unbiased methodology. Use for A/B analysis and treatment comparison.
SKILL.mdUpdated Apr 17, 2026
praveenmaiya/status
testing
VerifiedTrustedCommunity
Show current pipeline and deployment status. Use for quick health check.
SKILL.mdUpdated Apr 17, 2026