This Gemini CLI extension provides a set of tools to interact with Cloud SQL for PostgreSQL monitoring metrics. It allows you to fetch a wide range of database metrics, enabling comprehensive monitoring of database performance and health directly from the Gemini CLI, using natural language prompts.

Learn more about Gemini CLI Extensions.

• Natural Language Management: Stop wrestling with complex monitoring queries. Explore monitoring data by describing what you want in plain English.
• Seamless Workflow: As a Google-developed extension, it integrates seamlessly into the Gemini CLI environment. No need to constantly switch contexts for common tasks.

Before you begin, ensure you have the following:

• Gemini CLI installed with version +v0.6.0.
• Setup Gemini CLI Authentication.
• A Google Cloud project with the Cloud Monitoring API enabled.
• Ensure Application Default Credentials are available in your environment.
• IAM Permissions:
  • Monitoring Viewer (roles/monitoring.viewer)

To install the extension, use the command:

gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability

Ensure Application Default Credentials are available in your environment.

To start the Gemini CLI, use the following command:

gemini

Interact with Cloud Monitoring metrics using natural language right from your IDE:

• "What is the memory usage for my Postgres database?"
• "What is the overall system performance for my instance?"
• "What queries have been run for this instance over the last 3 hours?"
• "Provide the execution time for the query X"

• get_system_metrics: Fetches system level cloud monitoring data (timeseries metrics) for a Postgres instance using a PromQL query.
• get_query_metrics: Fetches query level cloud monitoring data (timeseries metrics) for queries running in Postgres instance using a PromQL query.

Find additional extensions to support your entire software development lifecycle at github.com/gemini-cli-extensions, including:

• Cloud SQL for PostgreSQL extension
• Generic PostgreSQL extension
• and more!

Use gemini --debug to enable debugging.

Common issues:

• "failed to find default credentials: google: could not find default credentials.": Ensure Application Default Credentials are available in your environment. See Set up Application Default Credentials for more information.
• "✖ Error during discovery for server: MCP error -32000: Connection closed": The database connection has not been established. Ensure your configuration is set via environment variables.
• "✖ MCP ERROR: Error: spawn /Users/USER/.gemini/extensions/cloud-sql-postgresql-observability/toolbox ENOENT": The Toolbox binary did not download correctly. Ensure you are using Gemini CLI v0.6.0+.
• "cannot execute binary file": The Toolbox binary did not download correctly. Ensure the correct binary for your OS/Architecture has been downloaded. See Installing the server for more information.