skills.rest
MubasherMohammed
MubasherMohammedCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

bigquery-public

Execute read-only SQL queries on BigQuery public datasets and save results locally.

Updated May 10, 2026
Search Tags:#bioinformatics#sql#cloud#bigquery#public datasets
One-click install
npx skills add https://github.com/MubasherMohammed/opencode-BioInfo --skill bigquery-public
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-public
Source: https://github.com/MubasherMohammed/opencode-BioInfo/tree/main/python/skills/bigquery-public
Command: npx skills add https://github.com/MubasherMohammed/opencode-BioInfo --skill bigquery-public

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-cloud-bigquery, google-auth, bq, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides read-only access to BigQuery public datasets, eliminating the need for manual SQL operations, while maintaining reproducibility and local-first security.

Core Features & Use Cases

  • Read-Only SQL Queries: Execute SELECT/WITH queries against BigQuery public datasets.
  • Local Results: Save outputs and keep sensitive data local, enhancing reproducibility.
  • Auth & Safety: Auto-detects Python ADC for auth, with optional bq CLI fallback. Offers dry-run, row and byte safeguards, and medical disclaimers for security.
  • Use Case: If you need to query BigQuery's public genomic data and generate reports locally without handling sensitive information on the cloud, this Skill streamlines the process.

Quick Start

To execute a query and save results locally, run the following command: bigquery_public.py --query "SELECT * FROM bigquery-public-data.samples.shakespeare LIMIT 5" --output /path/to/output

Frequently Asked Questions about bigquery-public

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run read-only SQL queries on BigQuery public datasets?▼

You can execute read-only SQL queries on BigQuery public datasets using a Python script or bq CLI. The Skill automates authentication and saves query results locally to a specified output path for analysis.

What is needed to authenticate BigQuery access for genomic analysis?▼

BigQuery authentication for genomic analysis requires Python Application Default Credentials (ADC) auto-detection, with an optional bq CLI fallback. You must install google-cloud-bigquery and google-auth dependencies to process queries.

Can I use the bq CLI instead of Python to query BigQuery public datasets?▼

Yes, you can use the bq CLI as a fallback backend to query BigQuery public datasets. The Skill supports both Python and bq CLI execution methods, requiring the bq package to be installed if you choose the CLI route.

Does this BigQuery Skill support modifying or writing data to the cloud?▼

No, this Skill enforces read-only access to BigQuery public datasets and does not support data modification. It includes dry-run capabilities, row and byte safeguards, and medical disclaimers to ensure secure, local-first query execution.

How do I save BigQuery public dataset results locally for reproducibility?▼

Save BigQuery public dataset results locally by specifying an output file path in your query command. The Skill generates local output files directly, keeping sensitive genomic data off the cloud to enhance reproducibility and security.

Related Skills

Explore More Data & Analytics Skills→
fritzprixfritzprix
8

system-setup

Install and verify MCP runtime dependencies across Windows, Linux, and macOS.

Community
Intermediate
biomaps-infrabiomaps-infra

lib-deeptools

Convert BAM files to normalized bigWig tracks for NGS analysis.

Official
Advanced
galeepgaleep

gget

Query over 20 genomic databases for gene and sequence data.

Community
Advanced
iankikuiankiku
18

data

Design analytics systems, generate SQL queries, plan event tracking, and build dashboards.

Community
Advanced