Cloud SQL for PostgreSQL

Cloud SQL for PostgreSQL

• --prebuilt value: cloud-sql-postgres
• Environment Variables:
  • 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 IAM authentication if unspecified.
  • CLOUD_SQL_POSTGRES_PASSWORD: (Optional) The password for the database user. Defaults to IAM authentication if unspecified.
  • CLOUD_SQL_POSTGRES_IP_TYPE: (Optional) The IP type i.e. “Public” or “Private” (Default: Public).
• Permissions:
  • Cloud SQL Client (roles/cloudsql.client) to connect to the instance.
  • Database-level permissions (e.g., SELECT, INSERT) are required to execute queries.
• Tools:
  • execute_sql: Executes a SQL query.
  • list_tables: Lists tables in the database.
  • list_active_queries: Lists ongoing queries.
  • list_available_extensions: Discover all PostgreSQL extensions available for installation.
  • list_installed_extensions: List all installed PostgreSQL extensions.
  • long_running_transactions: Identifies and lists database transactions that exceed a specified time limit.
  • list_locks: Identifies all locks held by active processes.
  • replication_stats: Lists each replica’s process ID and sync state.
  • list_autovacuum_configurations: Lists autovacuum configurations in the database.
  • list_memory_configurations: Lists memory-related configurations in the database.
  • list_top_bloated_tables: List top bloated tables in the database.
  • list_replication_slots: Lists replication slots in the database.
  • list_invalid_indexes: Lists invalid indexes in the database.
  • get_query_plan: Generate the execution plan of a statement.
  • list_views: Lists views in the database from pg_views with a default limit of 50 rows. Returns schemaname, viewname and the ownername.
  • list_schemas: Lists schemas in the database.
  • database_overview: Fetches the current state of the PostgreSQL server.
  • list_triggers: Lists triggers in the database.
  • list_indexes: List available user indexes in a PostgreSQL database.
  • list_sequences: List sequences in a PostgreSQL database.
  • list_query_stats: Lists query statistics.
  • get_column_cardinality: Gets column cardinality.
  • list_table_stats: Lists table statistics.
  • list_publication_tables: List publication tables in a PostgreSQL database.
  • list_tablespaces: Lists tablespaces in the database.
  • list_pg_settings: List configuration parameters for the PostgreSQL server.
  • list_database_stats: Lists the key performance and activity statistics for each database in the postgreSQL instance.
  • list_roles: Lists all the user-created roles in PostgreSQL database.
  • list_stored_procedure: Lists stored procedures.