Skip to content

Available Skills

This plugin provides specialized skills for BigQuery ETL workflows. Skills are automatically invoked by Claude based on your requests - you don't need to call them explicitly.

Skill Categories

Foundation

Skill Purpose Claude uses when
bigquery-etl-core Project conventions and patterns Checking naming conventions, understanding project structure

Construction Workflows

Skill Purpose Claude uses when
model-requirements Requirements gathering Planning new tables or understanding existing ones
query-writer SQL/Python query writing Creating or updating query.sql, query.py files or ad-hoc queries
metadata-manager Schema and metadata config Generating schema.yaml & metadata.yaml files with descriptions
sql-test-generator Unit test generation Creating, updating, and running unit tests
bigconfig-generator Data quality monitoring Adding Bigeye monitoring configurations

Meta Skills

Skill Purpose Claude uses when
skill-creator Create new skills Extending the plugin with new capabilities

How Skills Work Together

Skills are designed to be composable—they work together to complete complex workflows:

Example: Creating a New Table

Prompt: Create a new table from ad_metrics that tracks advertiser performance grouped by:

- submission_date
- advertiser
- country
- impressions

graph LR
    A[User Request] --> B[model-requirements]
    B --> C[query-writer]
    C --> D[metadata-manager]
    D --> E[sql-test-generator]
    E --> F[bigconfig-generator]
    F --> G[Complete Table]
  1. model-requirements gathers requirements
  2. query-writer creates the SQL
  3. metadata-manager generates schema/metadata
  4. sql-test-generator creates tests
  5. bigconfig-generator adds monitoring

Example: Updating a Query

Prompt: Update the logic in x table to filter out y

graph LR
    A[User Request] --> B[query-writer]
    B --> C[metadata-manager]
    C --> D[sql-test-generator]
    D --> E[Updated Query]
  1. query-writer updates the query
  2. metadata-manager updates the schema
  3. sql-test-generator updates tests

See the Skills Overview for detailed information about skill anatomy and coordination.