bigquery-data

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	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

---

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

---