Clickhouse Logs Queries
supabase/supabase
Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint).
Skill for BigQuery AI and Machine Learning queries using standard SQL and AI.
Install Bigquery AI ML
$ npx skills add google/adk-python --skill bigquery-ai-ml -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install google/adk-python bigquery-ai-ml --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .claude/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .claude/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .claude/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-mlType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add google/adk-python --skill bigquery-ai-ml -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install google/adk-python bigquery-ai-ml --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .agents/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .agents/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .agents/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add google/adk-python --skill bigquery-ai-ml -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install google/adk-python bigquery-ai-ml --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .cursor/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .cursor/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/google/adk-python.git --path src/google/adk/integrations/bigquery/skills/bigquery-ai-ml--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add google/adk-python --skill bigquery-ai-ml -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install google/adk-python bigquery-ai-ml --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .gemini/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .gemini/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install google/adk-python bigquery-ai-mlInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add google/adk-python --skill bigquery-ai-ml -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .github/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .github/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .github/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add google/adk-python --skill bigquery-ai-ml -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install google/adk-python bigquery-ai-ml --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/google/adk-python.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml .opencode/skills/bigquery-ai-ml && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "bigquery-ai-ml" agent skill from https://github.com/google/adk-python/tree/main/src/google/adk/integrations/bigquery/skills/bigquery-ai-ml into .opencode/skills/bigquery-ai-ml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-ai-ml", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
bigquery-ai-ml- GitHub stars
- 22k
- Token cost
- ~592 tokens
- SKILL.md length
- 213 words
- Files
- 12 (incl. references)
- Skills in repo
- 13
- Repo updated
- First seen
- Licence
- Apache-2.0
At a glance
Skill for BigQuery AI and Machine Learning queries using standard SQL and AI.
- Works in 2 steps: Skill vs Tool Preference (BigQuery AI/ML) → Mandatory Reference Routing
- Tasks that involve Data warehousing
- SKILL.md covers 1. Skill vs Tool Preference… and 2. Mandatory Reference Routing
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Bigquery AI ML is an agent skill from google/adk-python, published by the product's own GitHub organization. Skill for BigQuery AI and Machine Learning queries using standard SQL and AI. functions (preferred over dedicated tools).
Its SKILL.md is about 590 tokens, which your agent loads only when the skill is triggered. The skill folder holds 12 other files, including reference files (for example `references/bigquery_ai_classify.md`, `references/bigquery_ai_detect_anomalies.md` and `references/bigquery_ai_forecast.md`).
It sits in Databases, covering Data warehousing. It works with Google BigQuery and SQL. The repository describes itself as: An open-source, code-first Python toolkit for building, evaluating, and deploying sophisticated AI agents with flexibility and control. The licence is Apache-2.0.
When your agent uses it
- Tasks that involve Data warehousing
Example prompts
- “/bigquery-ai-ml”
Workflow steps
2 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 097ae1e. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Bigquery AI ML loads about 592 tokens when it runs, and up to ~9.2k if it reads all its reference files. Until then it costs about 35 tokens; SKILL.md has 213 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from google/adk-python at commit 097ae1e, republished under its Apache-2.0 licence (© google). 213 words, ~592 tokens.
Download SKILL.mdSave it as
.claude/skills/bigquery-ai-ml/SKILL.md (or your agent's skills folder). This skill also uses 11 other files; get the full folder from GitHub.- name
- bigquery-ai-ml
- description
- Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools).
- license
- Apache-2.0
- metadata.author
- google-adk
- metadata.version
- 1.0
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 |
© google, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 11 other files (references) in src/google/adk/integrations/bigquery/skills/bigquery-ai-ml of google/adk-python.
- SKILL.md
- 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
Open the folder on GitHubat commit 097ae1e
Compare with similar skills
Bigquery AI ML next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Bigquery AI ML this skillgoogle/adk-python | 22k | — | ~592 | Automated safety check: Pass | Apache-2.0 | |
| Clickhouse Logs Queriessupabase/supabase | 111k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | |
| Semantic Analystsidequery/sidemantic | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | |
| Analysis Artifactswarpdotdev/oz-skills | 825 | — | ~1.1k | Automated safety check: Pass | MIT | |
| SQL Queriesw95/awesome-claude-corporate-skills | 237 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | |
| Imaging Data CommonsK-Dense-AI/scientific-agent-skills | 48k | 1 repos | ~7.8k | Automated safety check: Pass | MIT |
Similar skills
- Official
Semantic Analyst
sidequery/sidemantic
Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.
Analysis Artifacts
warpdotdev/oz-skills
Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis.
SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
Imaging Data Commons
K-Dense-AI/scientific-agent-skills
Queries and downloads public cancer imaging data from NCI Imaging Data Commons.
- Official
Bigquery Basics
google/skills
Manages datasets, tables, and jobs in BigQuery. An agent skill from google/skills.
More from google/adk-python
All 13 skills in this repo- Official
Adk Verify Snippets
google/adk-python
Checks that every Python code block in a Markdown file actually compiles and runs, by extracting each block to a temporary file, executing it in an isolated subprocess, and writing a pass/fail…
- Official
Adk Sample Creator
google/adk-python
Creates a new sample agent in the ADK Python repository — the sample directory, its agent.py, and its README.md — following the conventions the existing samples already use.
- Official
Adk Unit Guide
google/adk-python
Writes a hands-on developer guide for one ADK code unit — a minimal runnable example, how it works, a configuration-option table, advanced uses, limitations, and links to related samples — to…
- Official
Adk Git
google/adk-python
Writes commit messages and pull request descriptions for the adk-python repository: Conventional Commits types and scopes, subject lines that say why a change was made, and the linked-issue and…
- Official
Adk Setup
google/adk-python
Sets up a local ADK Python development environment in a git clone of the open-source adk-python repository: a uv virtual environment, all dependency extras, pre-commit hooks, and a first unit-test…
- Official
Adk Agent Builder
google/adk-python
Builds ADK (Agent Development Kit) Python agents: LLM agents with tools, graph workflows of function and agent nodes, conditional routing, fan-out and join, schema-validated delegation between…
Related
Works with
Categories
Questions about Bigquery AI ML
What does Bigquery AI ML do?
Skill for BigQuery AI and Machine Learning queries using standard SQL and AI. Bigquery AI ML is an agent skill from google/adk-python, published by the product's own GitHub organization. Skill for BigQuery AI and Machine Learning queries using standard SQL and AI.
When should I use Bigquery AI ML?
Bigquery AI ML fits situations like: tasks that involve Data warehousing.
How do I install Bigquery AI ML in Claude Code?
Run `npx skills add google/adk-python --skill bigquery-ai-ml -a claude-code`. Or copy the skill folder (src/google/adk/integrations/bigquery/skills/bigquery-ai-ml in google/adk-python) into .claude/skills/bigquery-ai-ml in your project. Claude Code loads it when a task matches its description.
How do I install Bigquery AI ML in Codex?
Run `npx skills add google/adk-python --skill bigquery-ai-ml -a codex`. Or copy the skill folder (src/google/adk/integrations/bigquery/skills/bigquery-ai-ml in google/adk-python) into .agents/skills/bigquery-ai-ml in your project. Codex loads it when a task matches its description.
Can I use Bigquery AI ML in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add google/adk-python --skill bigquery-ai-ml -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/bigquery-ai-ml, .gemini/skills/bigquery-ai-ml, .github/skills/bigquery-ai-ml and .opencode/skills/bigquery-ai-ml in your project.
What does Bigquery AI ML need to run?
SKILL.md names no scripts, command-line tools or credentials: Bigquery AI ML is instructions for the agent only.
Does Bigquery AI ML access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Bigquery AI ML safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Bigquery AI ML use?
Bigquery AI ML is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Bigquery AI ML use?
About 592 tokens (SKILL.md is roughly 2.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 8.6k tokens, read only when the agent opens those files.
What are the alternatives to Bigquery AI ML?
Skills that share tags, products or a category with Bigquery AI ML: Clickhouse Logs Queries (supabase/supabase, 111k stars), Semantic Analyst (sidequery/sidemantic, 129 stars), Analysis Artifacts (warpdotdev/oz-skills, 825 stars) and SQL Queries (w95/awesome-claude-corporate-skills, 237 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Bigquery AI ML?
google (a GitHub organization, an official publisher) maintains it in google/adk-python, which has 21,736 GitHub stars. The repository holds 13 skills in this directory. The repository was last updated on October 8, 2026.
Source: google/adk-python on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.