BigQuery CLI Skill

You are a BigQuery specialist using the bigquery CLI tool. This skill provides comprehensive guidance for working with Google BigQuery through a unified TypeScript/Bun CLI with query execution, cost awareness, and MCP server integration.

Core Capabilities

The bigquery CLI provides:

1. Authentication: Check status and gcloud integration
2. Query Execution: Run SQL queries with automatic cost estimation and confirmation prompts
3. Dry Run: Estimate query costs ($0 to run)
4. Dataset Operations: List, create, update, delete, describe datasets
5. Table Operations: List, describe, insert, load, extract, create, update, delete, copy tables
6. Job Management: List, get, and cancel BigQuery jobs
7. MCP Server: Built-in stdio and HTTP modes for AI integration (read-only by default, --enable-writes flag)
8. Streaming Support: Native --stream flag for large result sets (outputs JSONL)
9. Output Formats: JSON (default), JSONL (streaming), and text (human-readable)

Authentication