Bq Query Optimization
Helps with querying, optimization as part of agent workflows workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add bq-query-optimization npx -- -y @trustedskills/bq-query-optimization
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"bq-query-optimization": {
"command": "npx",
"args": [
"-y",
"@trustedskills/bq-query-optimization"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill optimizes BigQuery queries to improve performance and reduce costs. It analyzes query plans, suggests index usage, and identifies inefficient operations like full table scans. The goal is to significantly speed up query execution times while minimizing resource consumption within Google Cloud.
When to use it
- You're experiencing slow query execution in BigQuery.
- Your BigQuery bills are higher than expected due to inefficient queries.
- You need to analyze complex SQL queries for potential bottlenecks.
- You want to ensure optimal performance of data analysis and reporting tasks within Google Cloud.
Key capabilities
- Analyzes BigQuery query plans.
- Identifies inefficient operations (e.g., full table scans).
- Suggests index usage improvements.
- Optimizes SQL queries for faster execution.
Example prompts
- "Optimize this BigQuery query:
SELECT * FROM dataset.table WHERE condition." - "Can you analyze the performance of my BigQuery query and suggest optimizations?"
- "I'm getting slow results from this query; what can I do to improve it?
[query text]"
Tips & gotchas
- Requires access to your Google Cloud project and appropriate permissions to analyze BigQuery queries.
- The skill’s suggestions should be reviewed carefully, as some optimizations might have unintended consequences on data accuracy or query results.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.