Gemini CLI Extension: The Future of Google’s Cloud-Based Data Management

Google announced the launch of the Gemini CLI extensions, followed by the launch of Google Gemini CLI in June. Gemini CLI is an open-source AI agent that integrates Gemini’s power directly into the organizational terminal. Now, Google has announced the launch of CLI extensions for Google’s Cloud-Based Data Management System services. Analyzing trends and developing applications with services like Cloud SQL, BigQuery, and AlloyDB from a local development environment is a tough nut to crack. These extensions simplify data interactions, such as app development, deployment, data analytics, and operations, making them more efficient. Now, with the CLI extensions, data management and other data interactions would be easier than ever.

With this article, find out how Gemini CLI extensions would work and their potential contribution to cloud-based data management systems. This is a detailed guide to the use of various Cloud Gemini CLI extensions.

Automating App Deployment and Security Analysis with New CLI Extensions

With Google’s CLI extensions, the security and Cloud Run extensions, Google has bridged the gap between an organizational terminal and the cloud. These extensions are designed to address the critical parts of one’s workflows with intuitive and simple commands. For example, the ‘/security: analyze’ command executes a comprehensive scan in the local repository, with GitHub’s support. This ensures security is a natural part of the development cycle. The ‘/deploy’ command deploys an application to Cloud Run in a few minutes. With these commands, Google provided us a glimpse of its upcoming full Gemini CLI extensions.   

How to Use a Data Cloud Gemini CLI Extension?

To make the best out of the newly launched Data Cloud Gemini CLI Extensions, we must know the process of using them. Listed below are the steps for enabling the data extension. 

Step 1: Before using the Cloud Gemini CLI extension, one must ensure that the APIs are enabled and configure the IAM permissions to access particular services.

Step 2: To recoup the latest functionality of the extension, one must install the latest version of the Gemini CLI, i.e., V0.6.0, using the command ‘npm install - g @google/gemini-cli@latest.’

Step 3: In the next step, one must install the extension through this command: “gemini extensions install https://github.com/gemini-cli-extensions/<EXTENSION>”

Step 4: Later, one must replace <EXTENSION>with the service name one wants to use. For example, ‘alloydb, cloud-sql-postgresql.’

Step 5: One needs to configure the extension to connect to one’s Google Cloud project by adding the required variables.

CLI Extension and Descriptions 

To know which extension serves what purpose, let us check out the list of extensions and their descriptions below:

1. BigQuery-data-analytics: This extension identifies and asks questions from BigQuery data.

2. BigQuery-conversational-analytics: With this extension, one can dig deeper and identify insights from BigQuery data using the built-in stateless agent of Conversational Analytics API.

3. AlloyDB: It creates resources and interacts with AlloyDB for PostgreSQL databases and data.

4. AlloyDB-observability: This extension monitors database performance and quality for AlloyDB and PostgreSQL databases.

5. Cloud-sql-mysql: It connects and interacts with Cloud SQL for the  MySQL database. 

6. Cloud-sql-mysql-observability: It monitors database performance and quality for MySQL and Cloud SQL databases.

7. Cloud-sql-sqlserver: This extension connects with a Cloud SQL for SQL Server database.

8. Cloud-sql-sqlserver-observability: It monitors database performance and quality for SQL Server and Cloud SQL databases.

9. Cloud-sql-postgresql: This extension creates resources and interacts with Cloud SQL for PostgreSQL databases.

10. Cloud-sql-postgresql-observability: It monitors database performance and quality for PostgreSQL and Cloud SQL databases.

11. Dataplex: It connects to the Dataplex Universal Catalog to identify, manage, monitor, and govern data and AI artifacts across one’s data platform, for example, Google Cloud Computing

12. Looker: This extension connects to Looker for data query, run Looks, and create dashboards.

13. Firestore-native: It connects and interacts with Firestore databases, documents, and collections.

14. Postgres: This can connect and interact with a PostgreSQL database.

15. Mysql: It connects and interacts with the MySQL database.

16. SQL Server: This extension connects and interacts with a SQL Server database.

17. Mcp-toolbox: This extension loads custom tools using MCP Toolbox for Databases.

18. Spanner: It connects and interacts with a Spanner database.

Step 6: After connecting the extension to the Google Cloud platform, one can start the Gemini CLI using the gemini command. If one needs to view the installed extensions, they can do so using the command ‘/extensions.’

Step 7: Next, one can list the MCP tools and servers included in the extension through the command ‘/mcp list.’

Exploring The BigQuery Analytics Extensions

For all the analytical needs, the Gemini CLI extension designed for BigQuery Data Analytics will soon be available for users. Google has also given access to the Conversational Analytics API through the BigQuery Conversational Analytics extension. Through the launch of this CLI extension, Google is finally able to leverage the full potential of BigQuery directly into one’s local coding environment. This extension helps in creating a unified and integrated workflow for organizations. Below are some of the benefits of using the BigQuery Data Analytics extension-

• Exploring Data: Using natural language lets users search for data tables.

• Analysis: One can ask business questions on the data and derive intelligent insights using the extension.

• Conversational Analytics: Through the conversational analytics APIs, one can get deeper data insights.

• Extending: By using other tools or extensions, one can extend into advanced workflows, including reporting, charting, code management, and others.

The release of this extension adds a comprehensive suite of tools to Gemini CLI. Listed below are some of the tools that come with this Google Database extension:

1. Query execution tool: This tool lets you run any query on BigQuery and draw results from it that are summarized to your console.

2. Deeper Data Insights: With the “ask_data_insights” tool, you can get access to the server-side BigQuery agent for enriched data insights.

3. Metadata Tools: This tool lets you discover and comprehend the BigQuery data landscape.

4. AI-Powered Forecasting: You can leverage the power of BigQuery’s built-in AI.Forecast function. It allows robust time-series predictions directly from the command line.

An Example of Using The BigQuery Analytics Extensions

Here is an example of leveraging analytics extensions

Explore and Analyze Data

(Source: Google)

Generating Deeper Insights

You can use the “ask_data_insights” command to trigger any agent on BigQuery to find an answer to your questions. The smart server-side agent can collect additional context about the data to deliver deeper insights into your questions. By going further, one can generate reports and charts by blending BigQuery data with one’s local tools. 

The Process of Using Gemini CLI for PostgreSQL and Cloud SQL extension

PostgreSQL and Cloud SQL are parts of the Google Cloud Platform extensions that let one perform a range of actions, some of which are as follows:

• Creating Instances: The Cloud SQL extension lets users create a new Cloud SQL instance for PostgreSQL, SQL Server, and MySQL.

• Listing Instances: These two extensions list all Cloud SQL instances in a particular project.

• Getting Instances: These extensions are capable of retrieving information about a specific Cloud SQL instance.

• Creating User: These extensions can also create a new user account within a particular Cloud SQL instance. It can support both Cloud IAM and standard users.

Executing the Extensions

Now, if you are wondering about how to execute this process, this is what you can do. Similar to any other project, you can start with a robust written plan about the aim and objectives of your project. Afterwards, provide that project plan to the CLI as a series of prompts, after which the agent will commence provisioning the database and other resources.

After the extension’s configuration to let it connect to the new database, the agent can generate the required tables depending on the approved plan. To test the extension, one can prompt the agent to add test data.

Furthermore, the agent can use the context it has to create an API and make the data accessible. These extensions make building with Google Cloud databases easier than ever before.

The Silicon Journal brings to you the current updates on the launches of such technological advancements. Along with that, it also features articles covering a wide range of industry topics, which include finance, technology, healthcare, innovation, and several more.