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

0•

データベース管理

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.

主な機能

01Explore datasets and table schemas with formatted JSON output

02Save query results to destination tables or export directly to CSV

030 GitHub stars

04Execute standard SQL queries with cost estimation via dry runs

05Manage multi-project BigQuery environments and cross-dataset queries

06Preview table data efficiently using optimized head commands

ユースケース

01Rapid data exploration and schema verification for analytics pipelines

02Automating routine SQL reports and exporting results for local analysis

03Cost-conscious query testing and optimization before production execution

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add thanhtoan105/accounting_erp_chatbot bigquery

For use in Claude.ai and ChatGPT

Download Skill