Self-hosted alternatives to bigquery-slot-cost-optimizer

B

bigquery-slot-cost-optimizer

Analyzes Google Cloud BigQuery slot consumption, query costs

BigQuery slot and cost optimizer is an agent skill that gives agents and cloud engineers a set of heuristics for finding and fixing expensive or slow BigQuery work. It analyzes resource consumption, calculates slot hours, identifies slot contention and queueing, and looks for query patterns that waste capacity. Among the issues it targets are Cartesian joins and row count explosions, which multiply data far beyond what a query needs, and unpartitioned table scans or missing partition filters, which read far more data than necessary. It also covers jobs that run slowly or spill memory. The skill has a list of trigger conditions, so the agent loads it when you ask it to optimize query performance or reduce slot use, find the most expensive queries, diagnose contention, fix slow jobs, or detect Cartesian joins. Before it runs, it requires the SDKs, permissions and billing setup described in its prerequisites section. The data it reads comes from INFORMATION_SCHEMA. It is aimed at engineers who run BigQuery at scale and need to control both speed and spending. It is published by Google on skills.sh under the google skills repository, with about 21.3K stars and about 1.2K installs. The skills.sh listing shows Gen Agent Trust Hub and Socket passing, with Snyk showing Warn.