Skip to main content

@swamp/gcp/sqladmin

v2026.04.23.1

Google Cloud sqladmin infrastructure models

Repository

https://github.com/systeminit/swamp-extensions

Labels

gcpgoogle-cloudsqladmincloudinfrastructure

Contents

Quality score

Verified by Swamp

How well-documented and verifiable this extension is.

100%

Grade A

  • Has README or module doc2/2earned
  • README has a code example1/1earned
  • README is substantive1/1earned
  • Most symbols documented1/1earned
  • No slow types1/1earned
  • Has description1/1earned
  • At least one platform tag (or universal)1/1earned
  • Two or more platform tags (or universal)1/1earned
  • License declared1/1earned
  • Verified public repository2/2earned

Install

$ swamp extension pull @swamp/gcp/sqladmin

sslcerts.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
namestringInstance name for this resource (used as the unique identifier in the factory pattern)
commonName?stringUser supplied name. Must be a distinct name from the other certificates for this instance.
instancestringCloud SQL instance ID. This does not include the project ID.
createCreate a sslCerts
getGet a sslCerts
ArgumentTypeDescription
identifierstringThe name of the sslCerts
deleteDelete the sslCerts
ArgumentTypeDescription
identifierstringThe name of the sslCerts
syncSync sslCerts state from GCP
create_ephemeralcreate ephemeral
ArgumentTypeDescription
access_token?any
public_key?any
connect.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
namestringInstance name for this resource (used as the unique identifier in the factory pattern)
getGet a connect
ArgumentTypeDescription
identifierstringThe name of the connect
syncSync connect state from GCP
generate_ephemeral_certgenerate ephemeral cert
ArgumentTypeDescription
access_token?any
public_key?any
readTime?any
validDuration?any
users.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
databaseRoles?arrayOptional. Role memberships of the user
dualPasswordType?enumDual password status for the user.
host?stringOptional. The host from which the user can connect. For `insert` operations, host defaults to an empty string. For `update` operations, host is specified as part of the request URL. The host name cannot be updated after insertion. For a MySQL instance, it's required; for a PostgreSQL or SQL Server instance, it's optional.
iamEmail?stringOptional. The full email for an IAM user. For normal database users, this will not be filled. Only applicable to MySQL database users.
iamStatus?enumIndicates if a group is active or inactive for IAM database authentication.
instance?stringThe name of the Cloud SQL instance. This does not include the project ID. Can be omitted for `update` because it is already specified on the URL.
name?stringThe name of the user in the Cloud SQL instance. Can be omitted for `update` because it is already specified in the URL.
password?stringThe password for the user.
passwordPolicy?objectNumber of failed login attempts allowed before user get locked.
project?stringThe project ID of the project containing the Cloud SQL database. The Google apps domain is prefixed if applicable. Can be omitted for `update` because it is already specified on the URL.
sqlserverUserDetails?objectIf the user has been disabled
type?enumThe user type. It determines the method to authenticate the user during login. The default is the database's built-in user type.
createCreate a users
getGet a users
ArgumentTypeDescription
identifierstringThe name of the users
updateUpdate users attributes
deleteDelete the users
ArgumentTypeDescription
identifierstringThe name of the users
syncSync users state from GCP
backupruns.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
backupKind?enumSpecifies the kind of backup, PHYSICAL or DEFAULT_SNAPSHOT.
description?stringThe description of this run, only applicable to on-demand backups.
diskEncryptionConfiguration?objectThis is always `sql#diskEncryptionConfiguration`.
diskEncryptionStatus?objectThis is always `sql#diskEncryptionStatus`.
endTime?stringThe time the backup operation completed in UTC timezone in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
enqueuedTime?stringThe time the run was enqueued in UTC timezone in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
error?objectIdentifies the specific error that occurred.
id?stringThe identifier for this backup run. Unique only for a specific Cloud SQL instance.
instance?stringName of the database instance.
location?stringLocation of the backups.
startTime?stringThe time the backup operation actually started in UTC timezone in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
status?enumThe status of this run.
timeZone?stringBackup time zone to prevent restores to an instance with a different time zone. Now relevant only for SQL Server.
type?enumThe type of this run; can be either "AUTOMATED" or "ON_DEMAND" or "FINAL". This field defaults to "ON_DEMAND" and is ignored, when specified for insert requests.
windowStartTime?stringThe start time of the backup window during which this the backup was attempted in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
createCreate a backupRuns
ArgumentTypeDescription
waitForReady?booleanWait for the resource to reach a ready state after creation (default: true)
getGet a backupRuns
ArgumentTypeDescription
identifierstringThe id of the backupRuns
deleteDelete the backupRuns
ArgumentTypeDescription
identifierstringThe id of the backupRuns
syncSync backupRuns state from GCP
tiers.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
namestringInstance name for this resource (used as the unique identifier in the factory pattern)
getGet a tiers
ArgumentTypeDescription
identifierstringThe name of the tiers
syncSync tiers state from GCP
instances.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
backendType?enumThe backend type. `SECOND_GEN`: Cloud SQL database instance. `EXTERNAL`: A database server that is not managed by Google. This property is read-only; use the `tier` property in the `settings` object to determine the database type.
connectionName?stringConnection name of the Cloud SQL instance used in connection strings.
databaseVersion?enumThe database engine type and version. The `databaseVersion` field cannot be changed after instance creation.
diskEncryptionConfiguration?objectThis is always `sql#diskEncryptionConfiguration`.
diskEncryptionStatus?objectThis is always `sql#diskEncryptionStatus`.
failoverReplica?objectThe availability status of the failover replica. A false status indicates that the failover replica is out of sync. The primary instance can only failover to the failover replica when the status is true.
gceZone?stringThe Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.
geminiConfig?objectOutput only. Whether the active query is enabled.
includeReplicasForMajorVersionUpgrade?booleanInput only. Determines whether an in-place major version upgrade of replicas happens when an in-place major version upgrade of a primary instance is initiated.
instanceType?enumThe instance type.
ipAddresses?arrayThe IP address assigned.
maintenanceVersion?stringThe current software version on the instance.
masterInstanceName?stringThe name of the instance which will act as primary in the replication setup.
name?stringName of the Cloud SQL instance. This does not include the project ID.
nodeCount?numberThe number of read pool nodes in a read pool.
onPremisesConfiguration?objectPEM representation of the trusted CA's x509 certificate.
outOfDiskReport?objectThe minimum recommended increase size in GigaBytes This field is consumed by the frontend * Writers: * the proactive database wellness job for OOD. * Readers:
project?stringThe project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
region?stringThe geographical region of the Cloud SQL instance. It can be one of the [regions](https://cloud.google.com/sql/docs/mysql/locations#location-r) where Cloud SQL operates: For example, `asia-east1`, `europe-west1`, and `us-central1`. The default value is `us-central1`.
replicaConfiguration?objectOptional. Specifies if a SQL Server replica is a cascadable replica. A cascadable replica is a SQL Server cross region replica that supports replica(s) under it.
replicaNames?arrayThe replicas of the instance.
replicationCluster?objectOutput only. Read-only field that indicates whether the replica is a DR replica. This field is not set if the instance is a primary instance.
rootPassword?stringInitial root password. Use only on creation. You must set root passwords before you can connect to PostgreSQL instances.
satisfiesPzs?booleanThis status indicates whether the instance satisfies PZS. The status is reserved for future use.
scheduledMaintenance?objectIf the scheduled maintenance can be rescheduled.
secondaryGceZone?stringThe Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.
serverCaCert?objectPEM representation.
serviceAccountEmailAddress?stringThe service account email address assigned to the instance.\\This property is read-only.
settings?objectOptional. Whether the replica is in accelerated mode. This feature is in private preview and requires allowlisting to take effect.
sqlNetworkArchitecture?enum
state?enumThe current serving state of the Cloud SQL instance.
suspensionReason?arrayIf the instance state is SUSPENDED, the reason for the suspension.
switchTransactionLogsToCloudStorageEnabled?booleanInput only. Whether Cloud SQL is enabled to switch storing point-in-time recovery log files from a data disk to Cloud Storage.
tags?recordOptional. Input only. Immutable. Tag keys and tag values that are bound to this instance. You must represent each item in the map as: `"": ""`. For example, a single resource can have the following tags: ` "123/environment": "production", "123/costCenter": "marketing", ` For more information on tag creation and management, see https://cloud.google.com/resource-manager/docs/tags/tags-overview.
createCreate a instances
ArgumentTypeDescription
waitForReady?booleanWait for the resource to reach a ready state after creation (default: true)
getGet a instances
ArgumentTypeDescription
identifierstringThe name of the instances
updateUpdate instances attributes
ArgumentTypeDescription
waitForReady?booleanWait for the resource to reach a ready state after update (default: true)
deleteDelete the instances
ArgumentTypeDescription
identifierstringThe name of the instances
syncSync instances state from GCP
acquire_ssrs_leaseacquire ssrs lease
ArgumentTypeDescription
acquireSsrsLeaseContext?any
add_entra_id_certificateadd entra id certificate
add_server_caadd server ca
add_server_certificateadd server certificate
cloneclone
ArgumentTypeDescription
cloneContext?any
demotedemote
ArgumentTypeDescription
demoteContext?any
demote_masterdemote master
ArgumentTypeDescription
demoteMasterContext?any
execute_sqlexecute sql
ArgumentTypeDescription
application?any
autoIamAuthn?any
database?any
partialResultMode?any
rowLimit?any
sqlStatement?any
user?any
exportexport
ArgumentTypeDescription
exportContext?any
failoverfailover
ArgumentTypeDescription
failoverContext?any
importimport
ArgumentTypeDescription
importContext?any
list_entra_id_certificateslist entra id certificates
list_server_caslist server cas
list_server_certificateslist server certificates
point_in_time_restorepoint in time restore
ArgumentTypeDescription
allocatedIpRange?any
datasource?any
pointInTime?any
preferredSecondaryZone?any
preferredZone?any
privateNetwork?any
region?any
targetInstance?any
targetInstanceClearSettingsFieldNames?any
targetInstanceSettings?any
pre_check_major_version_upgradepre check major version upgrade
ArgumentTypeDescription
preCheckMajorVersionUpgradeContext?any
promote_replicapromote replica
reencryptreencrypt
ArgumentTypeDescription
backupReencryptionConfig?any
release_ssrs_leaserelease ssrs lease
reset_ssl_configreset ssl config
restartrestart
restore_backuprestore backup
ArgumentTypeDescription
backup?any
backupdrBackup?any
restoreBackupContext?any
restoreInstanceClearOverridesFieldNames?any
restoreInstanceSettings?any
rotate_entra_id_certificaterotate entra id certificate
ArgumentTypeDescription
rotateEntraIdCertificateContext?any
rotate_server_carotate server ca
ArgumentTypeDescription
rotateServerCaContext?any
rotate_server_certificaterotate server certificate
ArgumentTypeDescription
rotateServerCertificateContext?any
start_replicastart replica
stop_replicastop replica
switchoverswitchover
truncate_logtruncate log
ArgumentTypeDescription
truncateLogContext?any
databases.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
charset?stringThe Cloud SQL charset value.
collation?stringThe Cloud SQL collation value.
instance?stringThe name of the Cloud SQL instance. This does not include the project ID.
name?stringThe name of the database in the Cloud SQL instance. This does not include the project ID or instance name.
project?stringThe project ID of the project containing the Cloud SQL database. The Google apps domain is prefixed if applicable.
sqlserverDatabaseDetails?objectThe version of SQL Server with which the database is to be made compatible
createCreate a databases
getGet a databases
ArgumentTypeDescription
identifierstringThe name of the databases
updateUpdate databases attributes
deleteDelete the databases
ArgumentTypeDescription
identifierstringThe name of the databases
syncSync databases state from GCP
flags.tsv2026.04.23.1

Global Arguments

ArgumentTypeDescription
namestringInstance name for this resource (used as the unique identifier in the factory pattern)
getGet a flags
ArgumentTypeDescription
identifierstringThe name of the flags
syncSync flags state from GCP