Agent Skills
› google/skills
› bigquery-ai-ml
bigquery-ai-ml
GitHub利用 BigQuery 内置 ML 和 GenAI 能力进行高级数据分析，支持时间序列预测、异常检测、语义搜索、文本分类及内容生成等 SQL 查询任务。
Trigger Scenarios
需要执行时间序列预测或数值预测
检测数据中的异常值或离群点
进行语义搜索、向量搜索或文本相似度计算
对文本进行分类、摘要或翻译
评估机器学习模型性能
Install
npx skills add google/skills --skill bigquery-ai-ml -g -y
SKILL.md
Frontmatter
{
"name": "bigquery-ai-ml",
"metadata": {
"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, 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.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.
- 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
-
46a4414
Current 2026-08-05 06:57
新增多个AI函数参考文档，包括多行语义聚合、文本分类、模型评估、表格值AI生成、条件判断及评分等功能说明。
- aabe37a 2026-07-05 15:28
