Agent skill

Bigquery Public

Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs.

MITAuto-check passedDatabases

Install Bigquery Public

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/bigquery-public .claude/skills/bigquery-public && rm -rf skills-src

Use ~/.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/

Paste into Claude Code

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .claude/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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

$skill-installer install https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public

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

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/bigquery-public .agents/skills/bigquery-public && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .agents/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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.

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/bigquery-public .cursor/skills/bigquery-public && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .cursor/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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

$ gemini skills install https://github.com/ClawBio/ClawBio.git --path skills/bigquery-public

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/bigquery-public .gemini/skills/bigquery-public && rm -rf skills-src

Use ~/.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/

Paste into Gemini CLI

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .gemini/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public

Installs 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).

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/bigquery-public .github/skills/bigquery-public && rm -rf skills-src

Use ~/.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/

Paste into GitHub Copilot

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .github/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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.

skills CLI

$ npx skills add ClawBio/ClawBio --skill bigquery-public -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install ClawBio/ClawBio bigquery-public --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/ClawBio/ClawBio.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/bigquery-public .opencode/skills/bigquery-public && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "bigquery-public" agent skill from https://github.com/ClawBio/ClawBio/tree/main/skills/bigquery-public into .opencode/skills/bigquery-public/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "bigquery-public", 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-public
GitHub stars: 1.2k
Token cost: ~1.5k tokens
SKILL.md length: 500 words
Files: 8
Skills in repo: 104
Repo updated: Oct 7, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs.

Works in 6 steps: Read-only SQL execution: accepts SELECT… → Auth auto-detection: tries Python ADC… → Schema discovery: can list datasets,… → …
Tasks that involve Data warehousing
SKILL.md covers Why This Exists, Core Capabilities, Input Formats and Workflow, plus 9 more sections
Runs Python scripts from its folder; calls python

What it does

Bigquery Public is an agent skill from ClawBio/ClawBio. Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs.

Its SKILL.md is about 1.5k tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files (for example `bigquery_backends.py`, `bigquery_models.py` and `bigquery_public.py`).

It sits in Databases, covering Data warehousing, Reproducible research and SQL. It works with Google BigQuery and SQL. The repository describes itself as: 🦖 ClawBio - The first bioinformatics-native AI agent skill library. Local-first. Reproducible. Open. Free. The licence is MIT.

When your agent uses it

Tasks that involve Data warehousing
Tasks that involve Reproducible research
Tasks that involve SQL

Example prompts

“/bigquery-public”

Requirements

Python 3

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

Read-only SQL execution: accepts SELECT / WITH queries only.
Auth auto-detection: tries Python ADC first, then an authenticated bq CLI.
Schema discovery: can list datasets, list tables, and describe top-level table schema.
Exploration helpers: supports preview and count-only wrappers while preserving the original SQL.
Cost safeguards: supports dry-run and maximum-bytes-billed limits.
Reproducible outputs: writes query text, job metadata, provenance notes, CSV results, and a markdown summary locally.

What it can do on your machine

Read from SKILL.md and the folder at commit 5e045e3. 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
Ships script files (Python), which the agent can run.
Shell commands in SKILL.md call:
- python
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
- cloud.google.com
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 Public loads about 1.5k tokens when it runs. Until then it costs about 35 tokens; SKILL.md has 500 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~35
When it runs · the whole SKILL.md, loaded when a task matches: ~1.5k

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 ClawBio/ClawBio at commit 5e045e3, republished under its MIT licence (© ClawBio). 500 words, ~1,532 tokens.

Download SKILL.mdSave it as .claude/skills/bigquery-public/SKILL.md (or your agent's skills folder). This skill also uses 7 other files; get the full folder from GitHub.

name: bigquery-public
description: Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs.
license: MIT
metadata.version: 0.2.1
metadata.author: ClawBio
metadata.tags: bigquery, public-datasets, sql, cloud, genomics

🗃️ BigQuery Public

You are BigQuery Public, a specialised ClawBio agent for read-only access to BigQuery public datasets. Your role is to execute safe SQL against public reference tables, save local outputs, and keep sensitive user data off the cloud.

Why This Exists

Without it: users have to hand-roll BigQuery auth, cost limits, SQL safety checks, and result export every time.
With it: a single ClawBio skill can run a public-data query, save report.md and result.json, and record reproducibility metadata.
Why ClawBio: it preserves the project’s local-first boundary by querying only public cloud data while keeping patient-specific interpretation local.

Core Capabilities

Read-only SQL execution: accepts SELECT / WITH queries only.
Auth auto-detection: tries Python ADC first, then an authenticated bq CLI.
Schema discovery: can list datasets, list tables, and describe top-level table schema.
Exploration helpers: supports preview and count-only wrappers while preserving the original SQL.
Cost safeguards: supports dry-run and maximum-bytes-billed limits.
Reproducible outputs: writes query text, job metadata, provenance notes, CSV results, and a markdown summary locally.

Input Formats

Format	Extension	Required Fields	Example
Inline SQL	n/a	`--query`	`SELECT * FROM \`bigquery-public-data.samples.shakespeare` LIMIT 5`
SQL file	`.sql`	`--input <file.sql>`	`queries/shakespeare_top_words.sql`

Workflow

When the user asks to query BigQuery public data:

Validate: accept only read-only SQL and reject multi-statement or mutating queries.
Authenticate: try Python ADC, then fall back to logged-in bq CLI.
Execute: run a dry-run estimate or the live query with row and byte safeguards.
Discover: optionally inspect projects, datasets, tables, and top-level schema before writing SQL.
Generate: write report.md, result.json, tables/results.csv, and a reproducibility bundle.

CLI Reference

bash

# Inline SQL
python skills/bigquery-public/bigquery_public.py \
  --query "SELECT corpus, word, word_count FROM \`bigquery-public-data.samples.shakespeare\` LIMIT 5" \
  --output /tmp/bigquery_public

# SQL file
python skills/bigquery-public/bigquery_public.py \
  --input path/to/query.sql \
  --output /tmp/bigquery_public

# Preview a larger query without editing the SQL file
python skills/bigquery-public/bigquery_public.py \
  --input path/to/query.sql \
  --preview 20 \
  --output /tmp/bigquery_preview

# Discover tables before writing SQL
python skills/bigquery-public/bigquery_public.py \
  --list-tables isb-cgc.TCGA_bioclin_v0 \
  --output /tmp/bigquery_tables

# Demo mode (offline fixture)
python skills/bigquery-public/bigquery_public.py --demo --output /tmp/bigquery_demo

# Via ClawBio runner
python clawbio.py run bigquery --demo
python clawbio.py run bigquery --query "SELECT 1 AS example" --output /tmp/bigquery_public
python clawbio.py run bigquery --describe isb-cgc.TCGA_bioclin_v0.Clinical --output /tmp/bigquery_schema

Demo

To verify the skill works:

bash

python clawbio.py run bigquery --demo

Expected output: a local report and CSV preview using a bundled snapshot of bigquery-public-data.samples.shakespeare.

Show full SKILL.md (212 more words)Show less

Algorithm / Methodology

Normalize query: strip comments, mask literals, reject non-read-only SQL.
Resolve auth: prefer ADC for the Python client, otherwise use bq if already logged in.
Wrap when helpful: optionally turn a user query into a preview or count-only subquery without rewriting the original file.
Run safely: apply --max-bytes-billed, --max-rows, and optional dry-run.
Persist locally: store query text, result rows, job metadata, and provenance notes in the output directory.

Key parameters:

Default location: US
Default max rows: 100
Default max bytes billed: 1,000,000,000

Example Queries

"Run this public BigQuery SQL and save the output"
"Query a public genomics dataset in BigQuery"
"Dry-run this BigQuery statement and show estimated bytes"

Output Structure

text

output_directory/
├── report.md
├── result.json
├── tables/
│   └── results.csv
└── reproducibility/
    ├── commands.sh
    ├── environment.yml
    ├── job_metadata.json
    ├── provenance.json
    └── query.sql

Dependencies

Required:

google-cloud-bigquery — Python BigQuery client
google-auth — ADC detection and auth

Optional:

bq CLI — fallback backend when ADC is missing

Safety

Local-first: only public reference data is queried; do not upload patient-specific files or genotypes.
Read-only: no table creation, export, mutation, or multi-statement scripting.
Disclaimer: every report includes the standard ClawBio medical disclaimer.
Cost control: dry-run and billed-byte caps are enabled by default.

Integration with Bio Orchestrator

This v1 skill is intended for explicit invocation through clawbio.py run bigquery. Natural-language routing is intentionally out of scope for the first release.

Citations

Files

SKILL.md and 7 other files in skills/bigquery-public of ClawBio/ClawBio.

SKILL.md
bigquery_backends.py
bigquery_models.py
bigquery_public.py
bigquery_support.py
demo/demo_query.sql
demo/demo_result.json
tests/test_bigquery_public.py

Open the folder on GitHubat commit 5e045e3

Compare with similar skills

Bigquery Public 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.

Bigquery Public compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Bigquery Public this skillClawBio/ClawBio	1.2k	—	~1.5k	Automated safety check: Pass	MIT	yesterday
Semantic Analystsidequery/sidemantic	129	—	~982	Automated safety check: Pass	AGPL-3.0	yesterday
Analysis Artifactswarpdotdev/oz-skills	825	—	~1.1k	Automated safety check: Pass	MIT	1 mo ago
Bigquery Graphgoogle/adk-python	22k	—	~4.8k	Automated safety check: Pass	Apache-2.0	yesterday
SQL Queriesw95/awesome-claude-corporate-skills	237	3 repos	~2.8k	Automated safety check: Pass	MIT	7 mo ago
Imaging Data CommonsK-Dense-AI/scientific-agent-skills	48k	1 repos	~7.8k	Automated safety check: Pass	MIT	3 days ago

Similar skills

Semantic Analyst
sidequery/sidemantic
Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.
129 GitHub stars~982 tokensUpdated yesterday
DatabasesAuto-check passed
Analysis Artifacts
warpdotdev/oz-skills
Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis.
825 GitHub stars~1.1k tokensUpdated 1 mo ago
DatabasesAuto-check passed
Bigquery Graph
google/adk-python
Official
Skill for Graph Query Language (GQL) or SQL/PGQ queries against a property graph.
22k GitHub stars~4.8k tokensUpdated yesterday
DatabasesAuto-check passed
SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
237 GitHub starsUsed in 3 repos~2.8k tokens
DatabasesAuto-check passed
Imaging Data Commons
K-Dense-AI/scientific-agent-skills
Queries and downloads public cancer imaging data from NCI Imaging Data Commons.
48k GitHub starsUsed in 1 repo~7.8k tokens
DatabasesAuto-check passed
Bigquery Basics
google/skills
Official
Manages datasets, tables, and jobs in BigQuery. An agent skill from google/skills.
21k GitHub starsUsed in 1 repo~1.1k tokens
DatabasesAuto-check passed

Questions about Bigquery Public

What does Bigquery Public do?

Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs. Bigquery Public is an agent skill from ClawBio/ClawBio. Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs.

When should I use Bigquery Public?

Bigquery Public fits situations like: tasks that involve Data warehousing; tasks that involve Reproducible research; tasks that involve SQL.

How do I install Bigquery Public in Claude Code?

Run `npx skills add ClawBio/ClawBio --skill bigquery-public -a claude-code`. Or copy the skill folder (skills/bigquery-public in ClawBio/ClawBio) into .claude/skills/bigquery-public in your project. Claude Code loads it when a task matches its description.

How do I install Bigquery Public in Codex?

Run `npx skills add ClawBio/ClawBio --skill bigquery-public -a codex`. Or copy the skill folder (skills/bigquery-public in ClawBio/ClawBio) into .agents/skills/bigquery-public in your project. Codex loads it when a task matches its description.

Can I use Bigquery Public 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 ClawBio/ClawBio --skill bigquery-public -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-public, .gemini/skills/bigquery-public, .github/skills/bigquery-public and .opencode/skills/bigquery-public in your project.

What does Bigquery Public need to run?

Going by SKILL.md and its folder, Bigquery Public needs Python for the scripts in its folder and the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Bigquery Public access the network?

SKILL.md names 1 domain. As links in the text: cloud.google.com. This is read from the text; nothing was executed.

Is Bigquery Public 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 Public use?

Bigquery Public is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Bigquery Public use?

About 1.5k tokens (SKILL.md is roughly 6.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Bigquery Public?

Skills that share tags, products or a category with Bigquery Public: Semantic Analyst (sidequery/sidemantic, 129 stars), Analysis Artifacts (warpdotdev/oz-skills, 825 stars), Bigquery Graph (google/adk-python, 22k 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 Public?

ClawBio (a GitHub organization) maintains it in ClawBio/ClawBio, which has 1,154 GitHub stars. The repository holds 104 skills in this directory. The repository was last updated on October 7, 2026.

Source: ClawBio/ClawBio on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Bigquery Public

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

🗃️ BigQuery Public

Why This Exists

Core Capabilities

Input Formats

Workflow

CLI Reference

Demo

Algorithm / Methodology

Example Queries

Output Structure

Dependencies

Safety

Integration with Bio Orchestrator

Citations

Files

Compare with similar skills

Similar skills

More from ClawBio/ClawBio

Related

Questions about Bigquery Public