Agent skill
data-querying
Write and verify SQL queries with BigQuery. Use when executing bq commands, writing SQL queries, or including query results in documents.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/data-querying
SKILL.md
Data Querying
Verification Requirement
All queries MUST be executed with bq and verified before inclusion. Never include unverified queries or fabricated data.
Query Process
-
Dry run: Validate syntax and check cost
bashbq query --project_id=<PROJECT_ID> --use_legacy_sql=false --dry_run "SELECT ..."Cost: ~$5/TB. <1GB is light, 2GB+ needs optimization.
-
Execute: Run and confirm results
bashbq query --project_id=<PROJECT_ID> --use_legacy_sql=false --format=csv "SELECT ..." -
Learn: Study existing queries in project docs for patterns.
Query Design
- Specify exact date ranges
- Filter partitioned tables by partition key
- Avoid correlated subqueries (use JOINs/CTEs)
- Filter early with CTEs before joining large tables
Documentation
- Execute exact query with
bq - Copy real output only
- State time period and what query measures
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?