bigquery-data

Original：🇺🇸 English

Translated

6 scripts

Use these skills when you need to handle large-scale data exploration and dataset management. Use when users need to find data assets or run SQL at scale. Provides metadata discovery and query execution across the data warehouse.

4installs

Sourcegemini-cli-extensions/bigquery-data-analytics

Added on2026-04-29

NPX Install

npx skill4agent add gemini-cli-extensions/bigquery-data-analytics bigquery-data

SKILL.md Content

View Translation Comparison →

Usage

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.

Scripts

execute_sql

Use this skill to execute sql statement.

Parameters

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`

get_dataset_info

Use this skill to get dataset metadata.

Parameters

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

get_table_info

Use this skill to get table metadata.

Parameters

Name	Type	Description	Required
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

list_dataset_ids

Use this skill to list datasets.

Parameters

Name	Type	Description	Required	Default
project	string	The Google Cloud project to list dataset ids.	No

list_table_ids

Use this skill to list tables.

Parameters

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

search_catalog

Use this skill to find tables, views, models, routines or connections.

Parameters

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`

bigquery-data

NPX Install

Tags

SKILL.md Content

Usage

Scripts

execute_sql

Parameters

get_dataset_info

Parameters

get_table_info

Parameters

list_dataset_ids

Parameters

list_table_ids

Parameters

search_catalog

Parameters