Cloud SQL

Module: Cloud SQL

Module flag: cloudsql Enabled by default: yes

---

Overview

The Cloud SQL module lists Cloud SQL instances across your project. Use it to audit database versions, machine tiers, regions, and instance states.

---

Enable This Module

GCP_PROJECT_ID=my-project ./aura-tracker-gcp --modules cloudsql

---

Required GCP APIs

gcloud services enable sqladmin.googleapis.com

---

Required IAM Permissions

Role	Tools that need it
roles/cloudsql.viewer	All tools

---

Tools

gcp_cloudsql_list_instances

Lists Cloud SQL instances in the project.

Parameters:

Name	Required	Description
project_id	yes	GCP project ID

Returns: Instance name, database version (MYSQL_8_0, POSTGRES_15, SQLSERVER_2019_STANDARD, etc.), region, tier (machine type), state (RUNNABLE / SUSPENDED / PENDING_CREATE / MAINTENANCE), labels, primary IP address type (PRIVATE / PUBLIC).

---

Prompt Examples

Inventory

"List all Cloud SQL instances in project my-project."

Version audit

"Which Cloud SQL instances in project my-project are running a database version older than PostgreSQL 14 or MySQL 8.0?"

Public IP audit

"Which Cloud SQL instances in project my-project have a public IP address configured?"

Aura combined

"What is the Aura Score for the Cloud SQL instances in project my-project and what's causing any low scores?"

---

Related Modules

Module flag	Why you'd combine it
aura	Aura Score includes Cloud SQL health (CPU, memory, disk)
topology	Find Cloud Run services that connect to these instances
vpcaccess	VPC connectors that enable private IP Cloud SQL access
monitoring	Fetch CPU utilization and connection count metrics