＋ Add to collection

Or: paste this in your AI chat

Please install the Agent Skill "google/bigquery-ai-ml" for me from skillmd.com. A SkillMD skill is a SKILL.md file — plain markdown plus a few companion files — that you save into my skills directory. Use whichever fetch route fits your setup: (1) if you have a terminal, run npx -y skillmds add google/bigquery-ai-ml; (2) otherwise fetch the file manifest at https://api.skillmd.com/api/skills/google/bigquery-ai-ml/bundle?format=manifest and download each listed file from its "url" into bigquery-ai-ml/ in your skills directory; (3) if the SkillMD MCP tools are connected, call skillmd_download with slug "google/bigquery-ai-ml" and save the returned files under bigquery-ai-ml/. Show me the SKILL.md before saving if you'd like me to review it. If your skills directory is read-only (e.g. the Claude desktop app), save the files to a working folder instead and tell me — I'll add them through my app's skills settings.

README badge

Show this skill's registry status in your repo:

[![SkillMD](https://skillmd.com/badge/google/bigquery-ai-ml.svg)](https://skillmd.com/skills/google/bigquery-ai-ml)

Bigquery AI Ml

Name: Bigquery AI Ml
Rating: 4.2 (5 reviews)
Author: Google

by Google google/bigquery-ai-ml multi-file Updated Jul 6, 2026

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

SKILL.md

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

AI Forecast: Leveraging pre-trained TimesFM model for forecasting without custom training.
AI Detect Anomalies: Identify deviations in time series data using pre-trained TimesFM model.
AI Generate: General-purpose text and content generation using Gemini models.
AI Key Drivers: Automatically identify dimensional segments most responsible for driving changes in a metric.

Related Skills

BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.

---
name: bigquery-ai-ml
description: Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.
---

# 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

-   [AI Forecast](references/ai_forecast.md): Leveraging pre-trained
    TimesFM model for forecasting without custom training.

-   [AI Detect Anomalies](references/ai_detect_anomalies.md): Identify
    deviations in time series data using pre-trained TimesFM model.

-   [AI Generate](references/ai_generate.md): General-purpose text and
    content generation using Gemini models.

-   [AI Key Drivers](references/ai_key_drivers.md): Automatically identify
    dimensional segments most responsible for driving changes in a metric.

## Related Skills

- [BigQuery Basics Skill](../bigquery-basics):
  SKILL.md file for core BigQuery concepts, resource management, CLI,
  and client libraries.

google/skills/tree/main/skills/cloud/bigquery-ai-ml commit · aabe37a010

▌
Cja Dimension Analysis · adobe bundle
Analyze CJA dimensions for cardinality, distribution, trends, anomalies, data quality, comparisons, and forecasting, producing an interactive HTML dashboard or markdown report.

142
repo stars
▌
Bigquery Bigframes · google
Generates Python code using BigQuery DataFrames (BigFrames), the pandas/scikit-learn-style API over BigQuery, for dataframe and ML workflows.

14.4k
repo stars
▌
Polars Bio · k-dense-ai bundle
Perform high-performance genomic interval operations and bioinformatics file I/O on Polars DataFrames, including overlap, nearest, merge, coverage, complement, subtract, and reading/writing BED, VCF, BAM, GFF, FASTA, and FASTQ formats with streaming and cloud-native support.

30.2k
repo stars
▌
Aeon · qhjqhj00 bundle
Performs time series machine learning tasks including classification, regression, clustering, forecasting, anomaly detection, segmentation, and similarity search using the aeon toolkit.

3
repo stars
▌
Aeon · lingxling bundle
Runs time series machine learning tasks—classification, regression, clustering, forecasting, anomaly detection, segmentation, and similarity search—using the scikit-learn compatible aeon toolkit.

253
repo stars
▌
Aeon · majiayu000 bundle
Provides scikit-learn compatible algorithms for time series machine learning, including classification, regression, clustering, forecasting, anomaly detection, segmentation, and similarity search.

567
repo stars

Frequently asked questions

How do I install the Bigquery AI Ml skill?

Run npx skillmds add google/bigquery-ai-ml in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Bigquery AI Ml skill do?

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation. It is listed under Data & Analytics, AI & ML, DevOps & Infra, Data Analysis, SQL & Databases on SkillMD.

Is Bigquery AI Ml safe to use?

SkillMD's automated safety review verdict for this skill is PASS. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Bigquery AI Ml?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Bigquery AI Ml free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Bigquery AI Ml?

Google (@google) published this skill as a verified publisher. Their other Agent Skills are listed on their SkillMD profile.