Manage Cloud SQL for PostgreSQL on GCP: provision instances, explore databases, audit health, monitor performance via PromQL, manage replication, optimize vector search, and tune configurations.
Use these skills when you need to audit database health, identify storage bloat, find invalid indexes, analyze table statistics, and manage maintenance configurations like autovacuum.
Use these skills when you need to manage the lifecycle of your instances, including performing backups and restores, checking major version upgrade compatibility, and monitoring overall instance status.
Use these skills when you need to troubleshoot performance bottlenecks, analyze query execution plans, identify resource-heavy processes, and monitor system-level PromQL metrics.
Use these skills when you need to monitor replication health, manage sync states between nodes, and audit database roles and security settings to ensure environment integrity.
Use these skills to set up and optimize production-ready vector workloads by simply expressing your intent and performance requirements.
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
This plugin requires configuration values that are prompted when the plugin is enabled. Sensitive values are stored in your system keychain.
cloud_sql_postgres_user(Optional) Username of the database user (Default: IAM user)
${user_config.cloud_sql_postgres_user}cloud_sql_postgres_regionRegion of the Cloud SQL instance
${user_config.cloud_sql_postgres_region}cloud_sql_postgres_ip_type(Optional) Type of the IP address: PUBLIC, PRIVATE, or PSC (Default: Public)
${user_config.cloud_sql_postgres_ip_type}cloud_sql_postgres_projectID of the Google Cloud project
${user_config.cloud_sql_postgres_project}cloud_sql_postgres_databaseName of the database
${user_config.cloud_sql_postgres_database}cloud_sql_postgres_instanceName of the Cloud SQL instance
${user_config.cloud_sql_postgres_instance}cloud_sql_postgres_password(Optional) Password of the database user (Default: IAM user)
${user_config.cloud_sql_postgres_password}[!NOTE] Currently in beta (pre-v1.0), and may see breaking changes until the first stable release (v1.0).
This repository provides a set of agent skills to interact with Cloud SQL for PostgreSQL instances. These skills can be used with various AI agents, including Antigravity, Claude Code and Codex, to manage your databases, execute queries, explore schemas, and troubleshoot issues using natural language prompts.
[!IMPORTANT] We Want Your Feedback! Please share your thoughts with us by filling out our feedback form. Your input is invaluable and helps us improve the project for everyone.
Before you begin, ensure you have the following:
roles/cloudsql.client)roles/cloudsql.admin)[!NOTE] If you do not configure a specific
CLOUD_SQL_POSTGRES_USERorCLOUD_SQL_POSTGRES_PASSWORD, these skills default to using the active local IAM user credentials. You must also add the IAM user to your Cloud SQL instance, see Creating a database user.
Please keep these env vars handy during the installation process:
CLOUD_SQL_POSTGRES_PROJECT: The GCP project ID.CLOUD_SQL_POSTGRES_REGION: The region of your Cloud SQL instance.CLOUD_SQL_POSTGRES_INSTANCE: The ID of your Cloud SQL instance.CLOUD_SQL_POSTGRES_DATABASE: The name of the database to connect to.CLOUD_SQL_POSTGRES_USER: (Optional) The database username. Defaults to the active IAM user.CLOUD_SQL_POSTGRES_PASSWORD: (Optional) The password for the database user.CLOUD_SQL_POSTGRES_IP_TYPE: (Optional) Type of the IP address: PUBLIC, PRIVATE, or PSC. Defaults to PUBLIC.[!NOTE]
- Ensure Application Default Credentials are available in your environment.
- If your Cloud SQL for PostgreSQL instance uses private IPs, you must run your agent in the same Virtual Private Cloud (VPC) network.
To start interacting with your database, install the skills for your preferred AI agent, then launch the agent and use natural language to ask questions or perform tasks.
For the latest version, check the releases page.
You can use either of these two agents for Antigravity:
npx claudepluginhub gemini-cli-extensions/cloud-sql-postgresql --plugin cloud-sql-postgresqlThis plugin provides a specialized suite of skills for data engineers and database practitioners working on Google Cloud. It acts as an expert assistant, allowing you to use natural language prompts in your preferred coding agent to architect complex data pipelines, transform data with dbt, write Spark and BigQuery SQL notebooks, and orchestrate end-to-end workflows across GCP's data ecosystem.
🐉 Specialised SRE skills for outage investigations, monitoring graphs, and post-mortems on Google Cloud Platform.
Connect to Looker and interact with your data using LookML.
Connect, query, and generate data insights for BigQuery datasets and data.
The CI/CD extension provides Gemini powered AI assisted CI/CD. It supports deployment to Cloud Run and Cloud Storage as well as creation of a robust CI/CD pipeline.
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
Connect and interact with a Cloud SQL for MySQL database and data.
Comprehensive operations manager for FairDB managed PostgreSQL service - SOPs, incident response, monitoring, and automation
SQL optimization, query tuning, and database performance expert for production systems
Database architecture and SQL optimization with PostgreSQL expertise
Connect and interact with Spanner data using natural language.