Does this skill support standard SQL?

Yes, the skill is configured to use standard SQL syntax by default using the --use_legacy_sql=false flag.

Can I check the cost of a query before running it?

Absolutely. The skill includes a dry run command that estimates the number of bytes processed without incurring costs.

How do I export BigQuery results to a file?

You can use the export feature to run a query and redirect the formatted CSV output into a local file.

Does this skill handle authentication?

The skill assumes that the Google Cloud CLI (gcloud) and bq tool are already authenticated on your local environment.

Can I preview table data without running a full query?

Yes, you can use the 'bq head' command included in this skill to preview a specific number of rows from any table.

BigQuery CLI Integration

Name: BigQuery CLI Integration
Author: thanhtoan105

bythanhtoan105

データベース管理

Facilitates seamless interaction with Google BigQuery via the bq command-line tool for data exploration and analysis.

概要

This skill empowers Claude to manage Google BigQuery workflows directly through the command line interface. It provides standardized patterns for listing datasets, inspecting table schemas, and executing complex SQL queries with built-in support for cost estimation and data exports. Ideal for data engineers and analysts, it streamlines the process of exploring production data, creating temporary scratch tables, and retrieving insights without leaving the terminal environment.

主な機能

Explore datasets and table schemas with formatted JSON output
Save query results to destination tables or export directly to CSV
0 GitHub stars
Execute standard SQL queries with cost estimation via dry runs
Manage multi-project BigQuery environments and cross-dataset queries
Preview table data efficiently using optimized head commands

ユースケース

Rapid data exploration and schema verification for analytics pipelines
Automating routine SQL reports and exporting results for local analysis
Cost-conscious query testing and optimization before production execution

概要

主な機能

Explore datasets and table schemas with formatted JSON output
Save query results to destination tables or export directly to CSV
0 GitHub stars
Execute standard SQL queries with cost estimation via dry runs
Manage multi-project BigQuery environments and cross-dataset queries
Preview table data efficiently using optimized head commands

ユースケース

Rapid data exploration and schema verification for analytics pipelines
Automating routine SQL reports and exporting results for local analysis
Cost-conscious query testing and optimization before production execution