Agent skill · data analytics · davila7
bigquery-basics
Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. Use for SQL queries, resource management, data ingestion, or AI applications on BigQuery.
Why this skill is useful
Provides specific commands and workflows for managing datasets and tables in BigQuery that the AI wouldn't reliably generate on its own.
What it needs
Requires bq, gcloud installed locally. Requires google account access. About 1k tokens when loaded. Last updated 2026-08-06. 30,138 stars on the source repository.
What this skill does
BigQuery Basics BigQuery is a serverless, AI-ready data platform that enables high-speed analysis of large datasets using SQL and Python. Its disaggregated architecture separates compute and storage, allowing them to scale independently while providing built-in machine learning, geospatial analysis, and business intelligence capabilities. Setup and Basic Usage 1. Enable the BigQuery API: 2. Create a Dataset: 3. Create a Table: Create a file named schema.json with your table schema: Then create the table with the bq tool: 4. Run a Query: Reference Directory Core Concepts: Storage types, analytics workflows, and BigQuery Studio features. CLI Usage: Essential bq command-line tool operations for managing data and jobs. Client Libraries: Using Google Cloud client libraries for Python, Java, Node.js, and Go. MCP Usage: Using the BigQuery remote MCP server and Gemini CLI extension. Infrastructure as Code: Terraform examples for datasets, tables, and reservations. IAM & Security: Roles, permissions, and data governance best practices. If you need product information not found in these references, use the Developer Knowledge MCP server searchdocuments tool. Related Skills BigQuery AI & ML Skill: SKILL.md file for BigQuery AI and ML capabilities. BigQuery AI & ML References: Reference files published for the BigQuery AI and ML skill. bigqueryaiclassify.md bigqueryaidetectanomalies.md bigqueryaiforecast.md bigqueryaigenerate.md bigqueryaigeneratebool.md bigqueryaigeneratedouble.md bigqueryaigenerateint.md bigqueryaiif.md bigqueryaiscore.md bigqueryaisearch.md bigqueryaisimilarity.md
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills davila7/bigquery-basics