Executes SQL queries, retrieves dataset/table metadata, lists datasets and tables, and searches the data catalog in BigQuery.
How this skill is triggered — by the user, by Claude, or both
Slash command
/bigquery-data-analytics:bigquery-dataThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
All scripts can be executed using Node.js. Replace `<param_name>` and `<param_value>` with actual values.
All scripts can be executed using Node.js. Replace <param_name> and <param_value> with actual values.
Bash:
node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'
PowerShell:
node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'
Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.
Use this skill to execute sql statement.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| sql | string | The SQL to execute. | Yes | |
| dry_run | boolean | If set to true, the query will be validated and information about the execution will be returned without running the query. Defaults to false. | No | false |
Use this skill to get dataset metadata.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| project | string | The Google Cloud project ID containing the dataset. | No | |
| dataset | string | The dataset to get metadata information. Can be in project.dataset format. | Yes |
Use this skill to get table metadata.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| project | string | The Google Cloud project ID containing the dataset and table. | No | |
| dataset | string | The table's parent dataset. | Yes | |
| table | string | The table to get metadata information. | Yes |
Use this skill to list datasets.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| project | string | The Google Cloud project to list dataset ids. | No |
Use this skill to list tables.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| project | string | The Google Cloud project ID containing the dataset. | No | |
| dataset | string | The dataset to list table ids. | Yes |
Use this skill to find tables, views, models, routines or connections.
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| prompt | string | Prompt representing search intention. Do not rewrite the prompt. | Yes | |
| datasetIds | array | Array of dataset IDs. | No | [] |
| projectIds | array | Array of project IDs. | No | [] |
| types | array | Array of data types to filter by. | No | [] |
| pageSize | integer | Number of results in the search page. | No | 5 |
npx claudepluginhub gemini-cli-extensions/bigquery-data-analytics --plugin bigquery-data-analyticsSearches and inspects GCP data assets via Dataplex catalog, BigQuery, Spanner, and BigLake. Use when you have a topic but lack specific resource IDs.
Guides BigQuery engineering with bq CLI for queries, table ops, data load/export; GoogleSQL syntax, functions, window funcs; partitioning, clustering, optimization.
Automate Google BigQuery tasks: run SQL queries, explore datasets and metadata, execute MBQL queries via Metabase integration.