| Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools).
npx skills add https://github.com/google/adk-python --skill bigquery-ai-ml
This skill defines the usage and rules for BigQuery AI/ML functions,
preferring SQL-based Skills over dedicated BigQuery tools.
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.
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 |
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.
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.
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.
Replace with description of the skill and when Claude should use it.
Use when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies
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.
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.
Use when creating new skills, editing existing skills, or verifying skills work before deployment
Take google/adk-python-bigquery-ai-ml from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
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.