메뉴
Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools).
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Central hub for building, testing, and iterating on ADK agents. Trigger this skill when the user wants to create a new agent, configure modes (task, single-turn), or build graph-based workflows.
Author new samples for the ADK Python repository. Use this skill when the user wants to create a new sample demonstrating a feature or agent pattern (e.g., dynamic nodes, standalone agents, fan-out/fan-in) or when adding examples to subdirectories under `contributing/`.
Creates or updates code unit design documents for source code documentation.
Creates detailed code unit guides for source code documentation.
Set up a local development environment for the ADK Python project. Use when the user wants to get started developing, set up their environment, install dependencies, or prepare for contributing.
Reviews all local changes in the repository for errors, styling compliance, unintended outcomes, and necessary documentation/test/sample updates. Generates a report and assists in fixing identified issues on-demand. Triggers on "adk-review", "review changes", "pr review", "check code style", "verify changes".
| name | bigquery-ai-ml |
| license | Apache-2.0 |
| metadata | {"author":"google-adk","version":"1.0"} |
| description | Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools). |
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 |
