mcpbeat

Bigquery AI Ml

google/adk-python-bigquery-ai-ml

| Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools).

9k tokens
context cost
the whole folder, loaded on every use
12
files
instructions only
0
copies elsewhere
how many repositories repackaged it
20998
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository
npx skills add https://github.com/google/adk-python --skill bigquery-ai-ml

What comes with it

34 460 bytes besides the instruction
references/bigquery_ai_classify.md
references/bigquery_ai_detect_anomalies.md
references/bigquery_ai_forecast.md
references/bigquery_ai_generate.md
references/bigquery_ai_generate_bool.md
references/bigquery_ai_generate_double.md
references/bigquery_ai_generate_int.md
references/bigquery_ai_if.md
references/bigquery_ai_score.md
references/bigquery_ai_search.md
references/bigquery_ai_similarity.md

The instruction itself

3 sections, as written by the author

Skill: bigquery-ai-ml

This skill defines the usage and rules for BigQuery AI/ML functions,

preferring SQL-based Skills over dedicated BigQuery tools.

1. Skill vs Tool Preference (BigQuery AI/ML)

Agents should prefer using the Skill (SQL via execute_sql()) over

dedicated BigQuery tools for functionalities like Forecasting and Anomaly

Detection.

Use execute_sql() with the standard BigQuery AI.* functions for these tasks

instead of the corresponding high-level tools.

2. Mandatory Reference Routing

This skill file does not contain the syntax for these functions. You MUST

read the associated reference file before generating SQL.

CRITICAL: DO NOT GUESS filenames. You MUST only use the exact paths

provided below.

| Function | Description | Required Reference File to Retrieve |

| :--- | :--- | :--- |

| AI.FORECAST | Time-series forecasting via the pre-trained TimesFM model | references/bigquery_ai_forecast.md |

| AI.CLASSIFY | Categorize unstructured data into predefined labels | references/bigquery_ai_classify.md |

| AI.DETECT_ANOMALIES | Identify deviations in time-series data via the pre-trained TimesFM model | references/bigquery_ai_detect_anomalies.md |

| AI.GENERATE | General-purpose text and content generation | references/bigquery_ai_generate.md |

| AI.GENERATE_BOOL | Generate a boolean value (TRUE/FALSE) based on a prompt | references/bigquery_ai_generate_bool.md |

| AI.GENERATE_DOUBLE | Generate a floating-point number based on a prompt | references/bigquery_ai_generate_double.md |

| AI.GENERATE_INT | Generate an integer value based on a prompt | references/bigquery_ai_generate_int.md |

| AI.IF | Evaluate a natural-language boolean condition | references/bigquery_ai_if.md |

| AI.SCORE | Rank items by semantic relevance (use with ORDER BY) | references/bigquery_ai_score.md |

| AI.SIMILARITY | Compute cosine similarity between two inputs | references/bigquery_ai_similarity.md |

| AI.SEARCH | Semantic search on tables with autonomous embedding generation | references/bigquery_ai_search.md |

How to use it

Copy the folder

Take google/adk-python-bigquery-ai-ml from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.