| name | bigquery-data |
| description | 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. |
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 |
