Agent Skills
› google/skills
› bigquery-ai-ml
bigquery-ai-ml
GitHub提供BigQuery内置AI/ML功能的SQL参考，涵盖预测、异常检测、因果分析、向量搜索及生成式AI等高级数据分析能力。
Trigger Scenarios
需要进行时间序列预测或趋势分析
需要执行文本分类或语义搜索
需要检测数据异常或关键驱动因素
Install
npx skills add google/skills --skill bigquery-ai-ml -g -y
SKILL.md
Frontmatter
{
"name": "bigquery-ai-ml",
"metadata": {
"version": "1.1.0",
"category": "AiAndMachineLearning"
},
"description": "Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. Use when you need to write SQL queries that perform time-series forecasting, predict values, detect outliers or anomalies, find key drivers, perform semantic search or vector search, classify text, calculate similarity, summarize content, translate language, evaluate models, filter by semantic conditions, measure the causal effect of an intervention, compute correlations between columns, detect change points or structural breaks, extract trend or seasonality components, or leverage generative AI capabilities in BigQuery. Do not use for general BigQuery dataset, table, or job management requests."
}
BigQuery AI & ML
BigQuery integrates with Vertex AI to provide powerful machine learning and
generative AI capabilities directly within SQL queries using built-in functions
like AI.FORECAST, AI.KEY_DRIVERS, AI.DETECT_ANOMALIES, and AI.GENERATE.
Reference Directory
-
Functions Reference:
- AI.AGG: ai_agg.md - Multi-row semantic aggregation and summarization.
- AI.CAUSAL_EFFECT: ai_causal_effect.md - Quantifies the impact of an intervention on a time series.
- AI.CLASSIFY: ai_classify.md - Classify text.
- AI.DETECT_ANOMALIES: ai_detect_anomalies.md - Detect anomalies.
- AI.EVALUATE: ai_evaluate.md - Evaluate models.
- AI.FORECAST: ai_forecast.md - Time-series forecasting.
- AI.GENERATE: ai_generate.md - Generate text using LLMs.
- AI.GENERATE_EMBEDDING: ai_generate_embedding.md - Generate embeddings.
- AI.GENERATE_TABLE: ai_generate_table.md - Table-valued AI generation.
- AI.IF: ai_if.md - Evaluate semantic conditions.
- AI.KEY_DRIVERS: ai_key_drivers.md - Identifies key drivers, this is a TVF.
- AI.SCORE: ai_score.md - Score data.
- AI.SEARCH: ai_search.md - Semantic search.
- AI.SIMILARITY: ai_similarity.md - Semantic similarity.
- Remote Models: remote_models.md - Working with remote models (Vertex AI).
- CONTRIBUTION_ANALYSIS:
ml_contribution_analysis.md
- Finds contributing factors, key drivers of change. Requires creating a MODEL entity.
- ML.CORRELATION: ml_correlation.md - Calculates correlation between columns, optionally sliced by dimensions.
- ML.DETECT_CHANGE_POINTS: ml_detect_change_points.md - Detects structural breaks or sustained shifts in a time series.
- ML.SEASONALITY: ml_seasonality.md - Extracts seasonal components from a time series.
- ML.TREND: ml_trend.md - Extracts the long-term trend component from a time series.
- VECTOR_SEARCH: vector_search.md - Vector search best practices.
Related Skills
- BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.
Version History
-
f566651
Current 2026-09-27 16:18
新增相关性、变化点检测、因果效应、趋势和季节性分析的参考文档。
-
d91e77b
2026-09-22 05:18
实施语义化版本控制规范，要求SKILL.md中的version字段严格遵循双引号包裹的SemVer 2.0格式，并为缺失版本的技能补充初始版本号1.0.0。
-
46a4414
2026-08-05 06:57
新增多个AI函数参考文档，包括多行语义聚合、文本分类、模型评估、表格值AI生成、条件判断及评分等功能说明。
- aabe37a 2026-07-05 15:28
