BigQuery Data Analytics Skills
[!NOTE]
Currently in beta (pre-v1.0), and may see breaking changes until the first stable release (v1.0).
Developers can effortlessly connect, interact, and generate data insights with BigQuery datasets and data using natural language commands.
[!IMPORTANT]
We Want Your Feedback!
Please share your thoughts with us by filling out our feedback form.
Your input is invaluable and helps us improve the project for everyone.
Table of Contents
Why Use the BigQuery Data Analytics Extension?
- Natural Language to data analytics : Find required BigQuery tables and ask analytical questions in natural language.
- Seamless Workflow: Stay in your CLI. No need to constantly switch contexts to the GCP console for generating analytical insights.
- Run advanced analytics : Generate forecasts, run a contributions analysis using built-in advanced skills.
Prerequisites
Before you begin, ensure you have the following:
- One of these AI agents installed
- A Google Cloud project with the BigQuery API enabled.
- Ensure Application Default Credentials are available in your environment.
- IAM Permissions:
- BigQuery User (
roles/bigquery.user)
- (Optional) To use BigQuery AI/ML skills
- Ensure that Vertex AI API is enabled
- IAM permissions:
- BigQuery Connection User (
roles/bigquery.connectionUser)
- Vertex AI User (
roles/aiplatform.user)
Getting Started
Configuration
Please keep these env vars handy during the installation process:
BIGQUERY_PROJECT: The GCP project ID.BIGQUERY_LOCATION: (Optional) The dataset location.
[!NOTE]
Installation & Usage
To start interacting with your database, install the skills for your preferred AI agent, then launch the agent and use natural language to ask questions or perform tasks.
For the latest version, check the releases page.
Antigravity
You can use either of these two agents for Antigravity:
💡 Tip — Migrating from Gemini CLI?
If you previously installed this extension with gemini extensions install, you can convert it to an Antigravity plugin instead of reinstalling from scratch:
- On first launch of Antigravity CLI, accept the Migration Options prompt to automatically convert your installed Gemini CLI extensions to Antigravity plugins.
- Or, from your terminal, run:
agy plugin import gemini
See Migrating from Gemini CLI for details on plugins, context files (GEMINI.md / AGENTS.md), and MCP server config differences.
Antigravity 2.0 (IDE)
1. Clone the Repo:
git clone --branch 0.2.1 https://github.com/gemini-cli-extensions/bigquery-data-analytics.git
2. Install the skills:
Choose a location for the skills:
- Global (all workspaces):
~/.gemini/antigravity/skills/
- Workspace-specific:
<workspace-root>/.agents/skills/
Copy the skill folders from the cloned repository's skills/ directory to your chosen location:
cp -R bigquery-data-analytics/skills/* ~/.gemini/antigravity/skills/
