gemini-cli-extensions/bigquery-data-analytics
claude-codeData Analytics skills for BigQuery
BigQuery Data Analytics is an open-source extension by Google that lets AI coding agents discover, query, and analyze BigQuery datasets with natural language. Ask for tables, run SQL, or forecast trends without leaving your CLI or the GCP console.
Our Review
Built and maintained by Google through the gemini-cli-extensions org, this extension connects four AI coding agents to BigQuery: Claude Code, Gemini CLI, Antigravity, and Codex. It ships under Apache-2.0 and packages three distinct skill sets rather than a single query tool.
What BigQuery Data Analytics adds to your AI agent:
- •Natural-language data discovery ask "find tables related to PyPI downloads" and the agent locates the right BigQuery datasets and tables without you writing metadata queries.
- •SQL execution at scale the bigquery-data skill runs queries across your data warehouse directly from the agent, so you stay in the CLI instead of switching to the GCP console.
- •Forecasting and contribution analysis the bigquery-analytics skill generates time-series forecasts and explains why a metric changed, answering "why did this move" questions automatically.
- •BigQuery AI and ML in SQL the bigquery-ai-ml skill exposes AI.* SQL functions for text generation, classification, semantic search, and forecasting using pre-trained models, with no custom model management.
- •Three packaged skills bigquery-data, bigquery-analytics, and bigquery-ai-ml install together so the agent picks the right capability for each request.
- •MCP Toolbox backend the extension runs on the MCP Toolbox binary, the same server layer Google uses across its database extensions.
Compatibility:
Install on Claude Code with /plugin marketplace add then /plugin install, on Antigravity and Gemini CLI as a plugin, on Codex via a local marketplace.json entry, or through the npx skills add open skills tool. It needs a Google Cloud project with the BigQuery API enabled, Application Default Credentials, and the BigQuery User IAM role; the optional AI/ML skills also need Vertex AI access.
Limitations:
The extension is in beta (pre-v1.0) and the maintainers warn of breaking changes until the first stable release, so treat it as early-stage. The latest tagged release is v0.2.1 from April 2026 while the code is pushed more recently, meaning it ships from the main branch ahead of formal versions. It only works with BigQuery, not other warehouses, and BigQuery query and storage costs apply on top of the free extension. Setup also requires GCP credentials and IAM configuration, which puts it out of reach for non-technical users.
Our Verdict
The bigquery-data-analytics extension is the official way Google brings BigQuery into an AI coding agent in 2026, and the inclusion of forecasting and AI/ML SQL skills makes it more than a plain query bridge.
For Vibe Builders, the natural-language layer is the appeal: you can ask for tables and insights in plain English and never write metadata SQL or open the GCP console. The catch is the GCP setup, which means credentials and IAM roles before your first query.
For Developers and data engineers, the three-skill split is the real value. The bigquery-analytics and bigquery-ai-ml skills add forecasting, contribution analysis, and AI.* SQL functions that a generic database connector does not, and it runs across Claude Code, Gemini CLI, Antigravity, and Codex.
Skip if you use a warehouse other than BigQuery, need a production-stable tool today, or want a database connector that works without cloud credentials. The beta status and v0.2.1 release tag mean you should track the releases page and expect changes.
Frequently Asked Questions
What is the BigQuery Data Analytics extension?
BigQuery Data Analytics is an open-source extension by Google that lets AI coding agents query and analyze BigQuery datasets using natural language. It packages three skills (bigquery-data, bigquery-analytics, and bigquery-ai-ml) so an agent can discover tables, run SQL at scale, generate forecasts, and call BigQuery AI.* functions directly from your terminal instead of the GCP console.
Is BigQuery Data Analytics free and open source?
Yes, the extension is open source under the Apache-2.0 license, with 44 GitHub stars as of June 2026. The extension itself costs nothing, but it queries BigQuery, so standard BigQuery query and storage charges from Google Cloud still apply. You also need a Google Cloud project with the BigQuery API enabled to use it.
Which AI agents support BigQuery Data Analytics?
The extension works with four AI coding agents: Claude Code, Gemini CLI, Antigravity, and Codex. On Claude Code it installs as a plugin from a marketplace, on Antigravity and Gemini CLI as a plugin, and on Codex through a local marketplace.json entry. You can also install it with the open skills tool using the npx skills command.
How do you install BigQuery Data Analytics on Claude Code?
In 2026 you install it on Claude Code by first setting the BigQuery environment variables, then running the command to add its marketplace and a second command to install the plugin. Before that, make sure you have Application Default Credentials set up and the BigQuery User IAM role on your Google Cloud project. Run /plugin list inside Claude Code to confirm the plugin is active.
Is BigQuery Data Analytics ready for production use?
Not yet for critical workloads. Google labels the extension as beta (pre-v1.0) and warns that breaking changes may land until the first stable v1.0 release. The latest tagged release is v0.2.1 from April 2026, so it is best used for exploration and internal analytics today rather than production pipelines, and you should watch the releases page for updates.
What is bigquery-data-analytics?
BigQuery Data Analytics is an open-source extension by Google that lets AI coding agents discover, query, and analyze BigQuery datasets with natural language. Ask for tables, run SQL, or forecast trends without leaving your CLI or the GCP console.
How do I install bigquery-data-analytics?
Visit the GitHub repository at https://github.com/gemini-cli-extensions/bigquery-data-analytics for installation instructions.
What license does bigquery-data-analytics use?
bigquery-data-analytics uses the Apache-2.0 license.
What are alternatives to bigquery-data-analytics?
Explore related tools and alternatives on My AI Guide.
Open source: source code publicly visible
Anyone can inspect exactly what this repo does on GitHub before using it. Apache-2.0 licensed.
Reviewed by My AI Guide for relevance, quality, and active maintenance before listing.
Install in Claude Code:
/install bigquery-data-analytics