# Bigquery AI ML

> Bigquery AI ML is an open-source agent skill for databases. Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/google/skills/tree/main/skills/cloud/bigquery-ai-ml
- **Repository:** https://github.com/google/skills
- **GitHub stars:** 24,379
- **License:** Apache-2.0
- **Skill name:** bigquery-ai-ml
- **Collection:** https://github.com/google/skills
- **Categories:** databases, analytics and data
- **Listing updated:** 2026-11-17

## About

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, generate descriptive statistics and table distribution profiles, 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.

## When your agent uses it

> 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, generate descriptive statistics and table distribution profiles, 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.

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Instructions only, no scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/bigquery-ai-ml)
- [License: Apache-2.0](https://github.com/google/skills/tree/HEAD/skills/cloud/bigquery-ai-ml)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/bigquery-ai-ml` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/bigquery-ai-ml &&
cp -R "$tmp/skills/cloud/bigquery-ai-ml" ~/.claude/skills/bigquery-ai-ml &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/bigquery-ai-ml` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/bigquery-ai-ml` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/bigquery-ai-ml &&
cp -R "$tmp/skills/cloud/bigquery-ai-ml" ~/.agents/skills/bigquery-ai-ml &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/bigquery-ai-ml` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/bigquery-ai-ml` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/bigquery-ai-ml &&
cp -R "$tmp/skills/cloud/bigquery-ai-ml" ~/.cursor/skills/bigquery-ai-ml &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/bigquery-ai-ml` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/google/skills.git --path skills/cloud/bigquery-ai-ml
```

Or copy the folder to `~/.gemini/skills/bigquery-ai-ml` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/bigquery-ai-ml`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/bigquery-ai-ml &&
cp -R "$tmp/skills/cloud/bigquery-ai-ml" ~/.copilot/skills/bigquery-ai-ml &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/bigquery-ai-ml` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/google/skills.git
```

Then copy `skills/skills/cloud/bigquery-ai-ml` into your agent's skills folder as `bigquery-ai-ml`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Bigquery AI ML in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/bigquery-ai-ml to use it in all your projects, or to .claude/skills/bigquery-ai-ml in one project.

### Does Bigquery AI ML run scripts?

No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Bigquery AI ML?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Bigquery AI ML?

The closest alternatives to Bigquery AI ML are SQL code review, Creating oracle to postgres master migration plan, Ssma console, Migrating oracle to postgres data access code and Creating oracle to postgres migration integration tests.

## Alternatives

- [SQL code review](https://ai-powered.com/skills/sql-code-review): SQL code review is an open-source agent skill for databases.
- [Creating oracle to postgres master migration plan](https://ai-powered.com/skills/creating-oracle-to-postgres-master-migration-plan): Creating oracle to postgres master migration plan is an open-source agent skill for databases.
- [Ssma console](https://ai-powered.com/skills/ssma-console): Ssma console is an open-source agent skill for databases.
- [Migrating oracle to postgres data access code](https://ai-powered.com/skills/migrating-oracle-to-postgres-data-access-code): Migrating oracle to postgres data access code is an open-source agent skill for databases.
- [Creating oracle to postgres migration integration tests](https://ai-powered.com/skills/creating-oracle-to-postgres-migration-integration-tests): Creating oracle to postgres migration integration tests is an open-source agent skill for databases.
- [Power bi model design review](https://ai-powered.com/skills/power-bi-model-design-review): Power bi model design review is an open-source agent skill for analytics and data.
- [Power bi performance troubleshooting](https://ai-powered.com/skills/power-bi-performance-troubleshooting): Power bi performance troubleshooting is an open-source agent skill for analytics and data.
- [SQL server table reconciliation](https://ai-powered.com/skills/sql-server-table-reconciliation): SQL server table reconciliation is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/bigquery-ai-ml
