mcpbeat Sign in

Bigquery AI Ml Agent Skill

| 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 |

Other skills for the same job

different authors, same section of the catalogue
Skill Creator
by anthropics
vendor ×10

Create new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.

56k tokens scripts
Skill Creator
by vercel-labs
vendor ×10

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.

12k tokens scripts
Skill Creator
by JayZeeDesign
×9

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.

10k tokens scripts
Template Skill
by JayZeeDesign
×7

Replace with description of the skill and when Claude should use it.

35 tokens
Dispatching Parallel Agents
by ZhanlinCui
×5

Use when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies

2k tokens
Skill Development
by anthropics
vendor ×4

This skill should be used when the user wants to "create a skill", "add a skill to plugin", "write a new skill", "improve skill description", "organize skill content", or needs guidance on skill structure, progressive disclosure, or skill development best practices for Claude Code plugins.

9k tokens
Find Skills
by sanity-io
vendor ×4

Helps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express interest in extending capabilities. This skill should be used when the user is looking for functionality that might exist as an installable skill.

1k tokens
Writing Skills
by ZhanlinCui
×4

Use when creating new skills, editing existing skills, or verifying skills work before deployment

26k tokens scripts

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.