Google Cloud SQL Admin
Manage Cloud SQL instances: restart, export/import via GCS (Google OAuth2).
OCNORA ships 80 typed Google Cloud SQL Admin operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.
Before you connect Google Cloud SQL Admin
- Authentication
- OAuth 2.0
- Credential
- {"client_id", "client_secret", "refresh_token"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Google Cloud SQL Admin
Operations, grouped by what they do to your data.
Create and send 16
Read and search 25
Delete and cancel 9
A sample Google Cloud SQL Admin workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Google Cloud SQL Admin trigger is needed.
- 2Export to GCScloud_sql_admin.export_to_gcsExport databases from a Cloud SQL instance to a gs:// URI (SQL or CSV).
- 3Acquire Ssrs Lease Instancecloud_sql_admin.acquire_ssrs_lease_instanceAcquire a lease for the setup of SQL Server Reporting Services (SSRS).
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 80
- Acquire Ssrs Lease InstanceAcquire a lease for the setup of SQL Server Reporting Services (SSRS).cloud_sql_admin.acquire_ssrs_lease_instance
- Add Entra Id Certificate InstanceAdds a new Entra ID certificate for the specified instance.cloud_sql_admin.add_entra_id_certificate_instance
- Add Server Ca InstanceAdds a new trusted Certificate Authority (CA) version for the specified instance.cloud_sql_admin.add_server_ca_instance
- Add Server Certificate InstanceAdd a new trusted server certificate version for the specified instance using Certificate Authority Service (CAS) server CA.cloud_sql_admin.add_server_certificate_instance
- Cancel OperationCancels an instance operation that has been performed on an instance.cloud_sql_admin.cancel_operation
- Clone InstanceCreates a Cloud SQL instance as a clone of the source instance.cloud_sql_admin.clone_instance
- Create Backup BackupCreates a backup for a Cloud SQL instance.cloud_sql_admin.create_backup_backup
- Create Backup RunCreates a new backup run on demand.cloud_sql_admin.create_backup_run
- Create Blue Green DeploymentCreates a blue-green deployment under a given project and location.cloud_sql_admin.create_blue_green_deployment
- Create DatabaseInserts a resource containing information about a database inside a Cloud SQL instance.cloud_sql_admin.create_database
- Create Ephemeral Ssl CertGenerates a short-lived X509 certificate containing the provided public key and signed by a private key specific to the target instance.cloud_sql_admin.create_ephemeral_ssl_cert
- Create InstanceCreates a new Cloud SQL instance.cloud_sql_admin.create_instance
- Create Ssl CertCreates an SSL certificate and returns it along with the private key and server certificate authority.cloud_sql_admin.create_ssl_cert
- Create UserCreates a new user in a Cloud SQL instance.cloud_sql_admin.create_user
- Delete Backup BackupDeletes the backup.cloud_sql_admin.delete_backup_backup
- Delete Backup RunDeletes the backup taken by a backup run.cloud_sql_admin.delete_backup_run
- Delete Blue Green DeploymentDeletes a blue-green deployment.cloud_sql_admin.delete_blue_green_deployment
- Delete DatabaseDeletes a database from a Cloud SQL instance.cloud_sql_admin.delete_database
- Delete InstanceDeletes a Cloud SQL instance.cloud_sql_admin.delete_instance
- Delete Ssl CertDeletes the SSL certificate.cloud_sql_admin.delete_ssl_cert
- Delete UserDeletes a user from a Cloud SQL instance.cloud_sql_admin.delete_user
- Demote InstanceDemotes an existing standalone instance to be a Cloud SQL read replica for an external database server.cloud_sql_admin.demote_instance
- Demote Master InstanceDemotes the stand-alone instance to be a Cloud SQL read replica for an external database server.cloud_sql_admin.demote_master_instance
- Execute Sql InstanceExecute SQL statements.cloud_sql_admin.execute_sql_instance
- Export to GCSExport databases from a Cloud SQL instance to a gs:// URI (SQL or CSV).cloud_sql_admin.export_to_gcs
- Failover InstanceInitiates a manual failover of a high availability (HA) primary instance to a standby instance, which becomes the primary instance.cloud_sql_admin.failover_instance
- Generate Ephemeral Cert ConnectGenerates a short-lived X509 certificate containing the provided public key and signed by a private key specific to the target instance.cloud_sql_admin.generate_ephemeral_cert_connect
- Get Backup BackupRetrieves a resource containing information about a backup.cloud_sql_admin.get_backup_backup
- Get Backup RunRetrieves a resource containing information about a backup run.cloud_sql_admin.get_backup_run
- Get Blue Green DeploymentRetrieves a blue-green deployment resource under a given project and location.cloud_sql_admin.get_blue_green_deployment
- Get ConnectRetrieves connect settings about a Cloud SQL instance.cloud_sql_admin.get_connect
- Get DatabaseRetrieves a resource containing information about a database inside a Cloud SQL instance.cloud_sql_admin.get_database
- Get Disk Shrink Config InstanceGet Disk Shrink Config for a given instance.cloud_sql_admin.get_disk_shrink_config_instance
- Get InstanceGet a Cloud SQL instance (state, version, IPs, full resource).cloud_sql_admin.get_instance
- Get Latest Recovery Time InstanceGet Latest Recovery Time for a given instance.cloud_sql_admin.get_latest_recovery_time_instance
- Get OperationRetrieves an instance operation that has been performed on an instance.cloud_sql_admin.get_operation
- Get Ssl CertRetrieves a particular SSL certificate.cloud_sql_admin.get_ssl_cert
- Get UserRetrieves a resource containing information about a user.cloud_sql_admin.get_user
- Import from GCSImport a SQL dump or CSV from a gs:// URI into a Cloud SQL instance.cloud_sql_admin.import_from_gcs
- List Backup RunsLists all backup runs associated with the project or a given instance and configuration in the reverse chronological order of the backup initiation time.cloud_sql_admin.list_backup_runs
- List Backups BackupLists all backups associated with the project.cloud_sql_admin.list_backups_backup
- List Blue Green DeploymentsLists blue-green deployments under a given project.cloud_sql_admin.list_blue_green_deployments
- List DatabasesList databases on a Cloud SQL instance.cloud_sql_admin.list_databases
- List Entra Id Certificates InstanceLists all versions of EntraID certificates for the specified instance.cloud_sql_admin.list_entra_id_certificates_instance
- List FlagsLists all available database flags for Cloud SQL instances.cloud_sql_admin.list_flags
- List InstancesList Cloud SQL instances in a project.cloud_sql_admin.list_instances
- List OperationsLists all instance operations that have been performed on the given Cloud SQL instance in the reverse chronological order of the start time.cloud_sql_admin.list_operations
- List Server Cas InstanceLists all of the trusted Certificate Authorities (CAs) for the specified instance.cloud_sql_admin.list_server_cas_instance
Show 32 more
- List Server Certificates InstanceLists all versions of server certificates and certificate authorities (CAs) for the specified instance.cloud_sql_admin.list_server_certificates_instance
- List Ssl CertsLists all of the current SSL certificates for the instance.cloud_sql_admin.list_ssl_certs
- List TiersLists all available machine types (tiers) for Cloud SQL, for example, `db-custom-1-3840`.cloud_sql_admin.list_tiers
- List UsersLists users in the specified Cloud SQL instance.cloud_sql_admin.list_users
- Perform Disk Shrink InstancePerform Disk Shrink on primary instance.cloud_sql_admin.perform_disk_shrink_instance
- Point In Time Restore InstancePoint in time restore for an instance managed by Google Cloud Backup and Disaster Recovery.cloud_sql_admin.point_in_time_restore_instance
- Pre Check Major Version Upgrade InstanceExecute MVU Pre-checks.cloud_sql_admin.pre_check_major_version_upgrade_instance
- Promote Replica InstancePromotes the read replica instance to be an independent Cloud SQL primary instance.cloud_sql_admin.promote_replica_instance
- Reencrypt InstanceReencrypt CMEK instance with latest key version.cloud_sql_admin.reencrypt_instance
- Release Ssrs Lease InstanceRelease a lease for the setup of SQL Server Reporting Services (SSRS).cloud_sql_admin.release_ssrs_lease_instance
- Replace DatabaseUpdates a resource containing information about a database inside a Cloud SQL instance.cloud_sql_admin.replace_database
- Replace InstanceUpdates settings of a Cloud SQL instance.cloud_sql_admin.replace_instance
- Replace UserUpdates an existing user in a Cloud SQL instance.cloud_sql_admin.replace_user
- Reschedule Maintenance InstanceReschedules the maintenance on the given instance.cloud_sql_admin.reschedule_maintenance_instance
- Reset Replica Size InstanceReset Replica Size to primary instance disk size.cloud_sql_admin.reset_replica_size_instance
- Reset Ssl Config InstanceDeletes all client certificates and generates a new server SSL certificate for the instance.cloud_sql_admin.reset_ssl_config_instance
- Resolve ConnectRetrieves connect settings about a Cloud SQL instance using the instance DNS name.cloud_sql_admin.resolve_connect
- Restart InstanceRestart a Cloud SQL instance (returns the operation; does not poll).cloud_sql_admin.restart_instance
- Restore Backup InstanceRestores a backup of a Cloud SQL instance.cloud_sql_admin.restore_backup_instance
- Rotate Entra Id Certificate InstanceRotates the server certificate version to one previously added with the addEntraIdCertificate method.cloud_sql_admin.rotate_entra_id_certificate_instance
- Rotate Server Ca InstanceRotates the server certificate to one signed by the Certificate Authority (CA) version previously added with the addServerCA method.cloud_sql_admin.rotate_server_ca_instance
- Rotate Server Certificate InstanceRotates the server certificate version to one previously added with the addServerCertificate method.cloud_sql_admin.rotate_server_certificate_instance
- Start External Sync InstanceStart External primary instance migration.cloud_sql_admin.start_external_sync_instance
- Start Replica InstanceStarts the replication in the read replica instance.cloud_sql_admin.start_replica_instance
- Stop Replica InstanceStops the replication in the read replica instance.cloud_sql_admin.stop_replica_instance
- Switchover Blue Green DeploymentSwitches over to green instance for a blue-green deployment.cloud_sql_admin.switchover_blue_green_deployment
- Switchover InstanceSwitches over from the primary instance to the DR replica instance.cloud_sql_admin.switchover_instance
- Truncate Log InstanceTruncate MySQL general and slow query log tables MySQL only.cloud_sql_admin.truncate_log_instance
- Update Backup BackupUpdates the retention period and description of the backup.cloud_sql_admin.update_backup_backup
- Update DatabasePartially updates a resource containing information about a database inside a Cloud SQL instance.cloud_sql_admin.update_database
- Update InstancePartially updates settings of a Cloud SQL instance by merging the request with the current configuration.cloud_sql_admin.update_instance
- Verify External Sync Settings InstanceVerify External primary instance external sync settings.cloud_sql_admin.verify_external_sync_settings_instance
Google Cloud SQL Admin questions
- How does OCNORA authenticate with Google Cloud SQL Admin?
- With a stored OAuth 2.0 credential, shaped {"client_id", "client_secret", "refresh_token"}. A connection test can check it when you add it.
- What can I automate with Google Cloud SQL Admin?
- 80 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Google Cloud SQL Admin operation I need is not listed?
- Where Google Cloud SQL Admin has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Google Cloud SQL Admin?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Google Cloud SQL Admin calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
See your first Google Cloud SQL Admin workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.