1 extensionsmax 1000x1000 1
In June, Google introduced Gemini CLI, an open-source AI agent that brings the power of Gemini directly into your terminal. And today, we’re excited to announce open-source Gemini CLI extensions for Google Data Cloud services.
Building applications and analyzing trends with services like Cloud SQL, AlloyDB and BigQuery has never been easier — all from your local development environment! Whether you’re just getting started or a seasoned developer, these extensions make common data interactions such as app development, deployment, operations, and data analytics more productive and easier. So, let’s jump right in!
Before you get started, make sure you have enabled the APIs and configured the IAM permissions required to access specific services.
To retrieve the newest functionality, install the latest release of the Gemini CLI (v0.6.0):
npm install -g @google/gemini-cli@latest
Next, install the extension:
gemini extensions install https://github.com/gemini-cli-extensions/<EXTENSION>
Replace <EXTENSION> with the name of the service you want to use. For example, alloydb, cloud-sql-postgresql or bigquery-data-analytics.
Before starting the Gemini CLI, you’ll need to configure the extension to connect with your Google Cloud project by adding the required environment variables. The table below provides more information on the configuration required.
Extension Name | Description | Configuration |
alloydb | Create resources and interact with AlloyDB for PostgreSQL databases and data. | |
alloydb-observability | Monitor database performance and health for AlloyDB for PostgreSQL databases. | |
bigquery-data-analytics | Discover and ask questions from BigQuery data. | |
bigquery-conversational-analytics | Dive deeper , discover insights from BigQuery data using the built-in stateless agent offered by Conversational Analytics API | |
cloud-sql-mysql | Connect and interact with a Cloud SQL for MySQL database and data. | |
cloud-sql-mysql-observability | Monitor database performance and health for Cloud SQL for MySQL databases. | |
cloud-sql-postgresql | Create resources and interact with Cloud SQL for PostgreSQL databases and data. | |
cloud-sql-postgresql-observability | Monitor database performance and health for Cloud SQL for PostgreSQL databases. | |
cloud-sql-sqlserver | Connect and interact with a Cloud SQL for SQL Server database and data. | |
cloud-sql-sqlserver-observability | Monitor database performance and health for Cloud SQL for SQL Server databases. | |
dataplex | Connect to Dataplex Universal Catalog to discover, manage, monitor, and govern data and AI artifacts across your data platform. | |
firestore-native | Connect and interact with Firestore databases, collections, and documents. | |
looker | Connect to Looker to query data, run Looks, and create dashboards. | |
mysql | Connect and interact with a MySQL database and data. | |
postgres | Connect and interact with a PostgreSQL database and data. | |
spanner | Connect and interact with a Spanner database and data. | |
sql-server | Connect and interact with a SQL Server database and data. | |
mcp-toolbox | Load custom tools using MCP Toolbox for Databases. |
Now, you can start the Gemini CLI using command gemini. You can view the extensions installed with the command /extensions
You can list the MCP servers and tools included in the extension using command /mcp list
The Cloud SQL for PostgreSQL extension lets you perform a number of actions. Some of the main ones are included below:
Create instance: Creates a new Cloud SQL instance for PostgreSQL (and also MySQL, or SQL Server)
List instances: Lists all Cloud SQL instances in a given project
Get instance: Retrieves information about a specific Cloud SQL instance
Create user: Creates a new user account within a specified Cloud SQL instance, supporting both standard and Cloud IAM users
Curious about how to put it in action? Like any good project, start with a solid written plan of what you are trying to do. Then, you can provide that project plan to the CLI as a series of prompts, and the agent will start provisioning the database and other resources:
After configuring the extension to connect to the new database, the agent can generate the required tables based on the approved plan. For easy testing, you can prompt the agent to add test data.
Now the agent can use the context it has to generate an API to make the data accessible.
As you can see, these extensions make it incredibly easy to start building with Google Cloud databases!
For your analytical needs, we are thrilled to give you a first look at the Gemini CLI extension for BigQuery Data Analytics. We are also excited to give access to the Conversational Analytics API through the BigQuery Conversational Analytics extension. This is the first step in our journey to bring the full power of BigQuery directly into your local coding environment, creating an integrated and unified workflow.
With this extension you can
Explore data: Use natural language to search for your tables.
Analyze: Ask business questions on the data and generate intelligent insights.
Dive deeper: Use conversational analytics APIs to dive deeper into the insights.
And extend: Use other tools or extensions to extend into advanced workflows like charting, reporting, code management, etc.
This initial release provides a comprehensive suite of tools to Gemini CLI:
Metadata tools: Discover and understand the BigQuery data landscape.
Query execution tool: Run any BigQuery query and get the results back, summarized to your console.
AI-powered forecasting: Leverage BigQuery’s built-in AI.Forecast function for powerful time-series predictions directly from the command line.
Deeper data Insights: The“ask_data_insights” tool provides access to server-side BigQuery agent for richer data insights.
And more …
[Note: To use the conversational analytics extension you need to enable additional APIs. Refer to documentation for additional info.]
Here is an example journey with analytics extensions:
Explore and analyze your data , e.g.,
Run deeper insights
Using “ask_data_insights” to trigger an agent on the BigQuery (Conversational analytics API) to answer your questions. The server side agent is smart enough to gather additional context about your data and offer deeper insights into your questions.
You can go further and generate charts and reports by mixing BigQuery data with your local tools. Here’s a prompt to try:
”using bigquery-public-data.pypi.file_downloads can you forecast downloads for the last four months of 2025 for package urllib3? Please plot a chart that includes actual downloads for the first 8 months, followed by the forecast for the last four months”
Ready to level up your Gemini CLI extensions for our Data Cloud services? Read more in the extensions documentation. Check out our templates and start building your own extensions to share with the community!
submitted by /u/mtrx3 [link] [comments]
Imbalanced datasets are a common challenge in machine learning.
Organizations are increasingly integrating generative AI capabilities into their applications to enhance customer experiences, streamline…
Many data science teams rely on Apache Spark running on Dataproc managed clusters for powerful,…
The upgraded version of the Legion Go S with SteamOS makes for a nice Steam…
Artificial intelligence is transforming biology and medicine by accelerating the discovery of new drugs and…