Executes SQL queries at scale on BigQuery, retrieves dataset and table metadata, lists datasets/tables, and searches data catalog.
npx claudepluginhub gemini-cli-extensions/bigquery-data-analytics --plugin bigquery-data-analyticsThis skill uses the workspace's default tool permissions.
All scripts can be executed using Node.js. Replace `<param_name>` and `<param_value>` with actual values.
Guides BigQuery engineering with bq CLI for queries, table ops, data load/export; GoogleSQL syntax, functions, window funcs; partitioning, clustering, optimization.
Discovers and inspects GCP data assets like BigQuery datasets/tables/views, Spanner databases/tables, BigLake via Dataplex semantic/keyword search and CLI tools. Retrieves schemas, metadata, governance without exact IDs.
Automates Google BigQuery tasks via Rube MCP and Metabase: runs SQL queries, MBQL queries, explores datasets and metadata. Useful for querying BigQuery data sources.
Share bugs, ideas, or general feedback.
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 |