bigquery-ai-ml
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, detect outliers, find key drivers, or leverage generative AI capabilities in BigQuery.
Install
With your agent
Install OMGSkills skill "googlecloudplatform/data-agent-kit-plugin:skills/bigquery-ai-ml" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/GoogleCloudPlatform/data-agent-kit-plugin /tmp/data-agent-kit-plugin && ln -s /tmp/data-agent-kit-plugin/skills/bigquery-ai-ml ~/.claude/skills/bigquery-ai-mlFrom README
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.KEYDRIVERS, AI.DETECTANOMALIES, and AI.GENERATE. [!IMPORTANT] You MUST read and follow the global constraints and mandatory function routing rules in aifunctionbestpractices.md before writing any BQML AI/ML SQL query. Reference Directory Best Practices: aifunctionbestpractices.md Functions Reference: AI.AGG: aiagg.md - Multi-row semantic aggregation and summarization. AI.CLASSIFY: aiclassify.md - Classify text. AI.DETECTANOMALIES: aidetectanomalies.md - Detect anomalies. AI.EVALUATE: aievaluate.md - Evaluate models. AI.FORECAST: aiforecast.md - Time-series forecasting. AI.GENERATE: aigenerate.md - Generate text using LLMs. AI.GENERATEEMBEDDING: aigenerateembedding.md - Generate embeddings. AI.GENERATETABLE: aigeneratetable.md - Table-valued AI generation.
More from this repo
accidental-data-loss-prevention
**STOP AND VERIFY**: Before running any command or tool that results in irreversible data loss, you MUST obtain...
bigquery-bigframes
Generates Python code using BigQuery DataFrames (BigFrames).
bigquery-data-transfer-service
Discovers and inspects BigQuery Data Transfer Service (DTS) configurations.