Catalog›Plugins›Databases›cloud-sql-postgresql-observabilityCScloud-sql-postgresql-observabilityManage and monitor database performance and health for Cloud SQL for PostgreSQL databases. Open site Open in the app JSON README (API)READMELoading documentation…# Gemini CLI Extension - Cloud SQL for PostgreSQL Observability > [!NOTE] > This extension is currently in beta (pre-v1.0), and may see breaking changes until the first stable release (v1.0). This Gemini CLI extension provides a set of tools to interact with [Cloud SQL for PostgreSQL](https://cloud.google.com/sql/docs/postgres) 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](https://google-gemini.github.io/gemini-cli/), using natural language prompts. Learn more about [Gemini CLI Extensions](https://github.com/google-gemini/gemini-cli/blob/main/docs/extensions/index.md). > [!IMPORTANT] > **We Want Your Feedback!** > Please share your thoughts with us by filling out our feedback [form][form]. > Your input is invaluable and helps us improve the project for everyone. [form]: https://docs.google.com/forms/d/e/1FAIpQLSfEGmLR46iipyNTgwTmIDJqzkAwDPXxbocpXpUbHXydiN1RTw/viewform?usp=pp_url&entry.157487=cloud-sql-postgresql-observability ## Why Use the Cloud SQL for PostgreSQL Observability Extension? * **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. ## Prerequisites Before you begin, ensure you have the following: * [Gemini CLI](https://github.com/google-gemini/gemini-cli) installed with version **+v0.6.0**. * Setup Gemini CLI [Authentication](https://github.com/google-gemini/gemini-cli/tree/main?tab=readme-ov-file#-authentication-options). * A Google Cloud project with the **Cloud Monitoring API** enabled. * Ensure [Application Default Credentials](https://cloud.google.com/docs/authentication/gcloud) are available in your environment. * IAM Permissions: * Monitoring Viewer (`roles/monitoring.viewer`) ## Getting Started ### Installation To install the extension, use the command: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability ``` ### Configuration Ensure [Application Default Credentials](https://cloud.google.com/docs/authentication/gcloud) are available in your environment. ### Start Gemini CLI To start the Gemini CLI, use the following command: ```bash gemini ``` ## Usage Examples 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" ## Supported Tools * `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. ## Additional Extensions Find additional extensions to support your entire software development lifecycle at [github.com/gemini-cli-extensions](https://github.com/gemini-cli-extensions), including: * [Cloud SQL for PostgreSQL extension](https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability) * [Generic PostgreSQL extension](https://github.com/gemini-cli-extensions/postgres) * and more! ## Troubleshooting Use `gemini --debug` to enable debugging. Common issues: * "failed to find default credentials: google: could not find default credentials.": Ensure [Application Default Credentials](https://cloud.google.com/docs/authentication/gcloud) are available in your environment. See [Set up Application Default Credentials](https://cloud.google.com/docs/authentication/external/set-up-adc) 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](https://mcp-toolbox.dev/documentation/introduction/#install-toolbox) for more information. DetailsTypePluginsTopicDatabasesPublishergemini-cli-extensionsSourcegeminiCategoryToolsVersion0.1.3Stars6Copies (forks)1Proposed changes6Last updateNov 9, 20266 days agoProject statusActiveLicenseApache-2.0AddedAug 30, 20263 months agoUpdatedAug 30, 20263 months agoSource idgemini-cli-extensions/cloud-sql-postgresql-observabilityMoreMore plugins on DatabasesAll from gemini-cli-extensionsA–Z index
