{
  "markdown": "# Gemini CLI Extension - Cloud SQL for PostgreSQL Observability\n\n> [!NOTE]\n> This extension is currently in beta (pre-v1.0), and may see breaking changes until the first stable release (v1.0).\n\nThis 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.\n\nLearn more about [Gemini CLI Extensions](https://github.com/google-gemini/gemini-cli/blob/main/docs/extensions/index.md).\n> [!IMPORTANT]\n> **We Want Your Feedback!**\n> Please share your thoughts with us by filling out our feedback [form][form]. \n> Your input is invaluable and helps us improve the project for everyone.\n\n[form]: https://docs.google.com/forms/d/e/1FAIpQLSfEGmLR46iipyNTgwTmIDJqzkAwDPXxbocpXpUbHXydiN1RTw/viewform?usp=pp_url&entry.157487=cloud-sql-postgresql-observability\n\n## Why Use the Cloud SQL for PostgreSQL Observability Extension?\n\n* **Natural Language Management:** Stop wrestling with complex monitoring queries. Explore monitoring data by describing what you want in plain English.\n* **Seamless Workflow:** As a Google-developed extension, it integrates seamlessly into the Gemini CLI environment. No need to constantly switch contexts for common tasks.\n\n\n## Prerequisites\n\nBefore you begin, ensure you have the following:\n\n* [Gemini CLI](https://github.com/google-gemini/gemini-cli) installed with version **+v0.6.0**.\n* Setup Gemini CLI [Authentication](https://github.com/google-gemini/gemini-cli/tree/main?tab=readme-ov-file#-authentication-options).\n* A Google Cloud project with the **Cloud Monitoring API** enabled.\n* Ensure [Application Default Credentials](https://cloud.google.com/docs/authentication/gcloud) are available in your environment.\n* IAM Permissions:\n  * Monitoring Viewer (`roles/monitoring.viewer`)\n\n## Getting Started\n\n### Installation\n\nTo install the extension, use the command:\n\n```bash\ngemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability\n```\n\n### Configuration\n\nEnsure [Application Default Credentials](https://cloud.google.com/docs/authentication/gcloud) are available in your environment.\n\n### Start Gemini CLI\n\nTo start the Gemini CLI, use the following command:\n\n```bash\ngemini\n```\n\n## Usage Examples\n\nInteract with Cloud Monitoring metrics using natural language right from your IDE:\n\n* \"What is the memory usage for my Postgres database?\"\n* \"What is the overall system performance for my instance?\"\n* \"What queries have been run for this instance over the last 3 hours?\"\n* \"Provide the execution time for the query X\"\n\n## Supported Tools\n\n* `get_system_metrics`: Fetches system level cloud monitoring data (timeseries metrics) for a Postgres instance using a PromQL query.\n* `get_query_metrics`: Fetches query level cloud monitoring data (timeseries metrics) for queries running in Postgres instance using a PromQL query.\n\n## Additional Extensions\n\nFind additional extensions to support your entire software development lifecycle at [github.com/gemini-cli-extensions](https://github.com/gemini-cli-extensions), including:\n* [Cloud SQL for PostgreSQL extension](https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability)\n* [Generic PostgreSQL extension](https://github.com/gemini-cli-extensions/postgres)\n* and more!\n\n## Troubleshooting\n\nUse `gemini --debug` to enable debugging.\n\nCommon issues:\n\n* \"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.\n* \"✖ 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.\n* \"✖ 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+.\n* \"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.\n",
  "bytes": 4617,
  "sha": "cb83e935374283020b58dfd6abdb5d5e83331d6f7556d8872ccddf8a7c5f3c10",
  "repo_slug": "gemini-cli-extensions/cloud-sql-postgresql-observability",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/plg_gemini_cli_extensions_cloud_sql_postgres_c8a567db/readme"
}