Gcp/sqladmin
@swamp/gcp/sqladminv2026.06.10.1
01README
Google Cloud sqladmin infrastructure models
02Release Notes
- Updated: connect, instances, users
03Models
backupruns.tsv2026.06.08.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| project? | string | GCP project ID; overrides GCP_PROJECT / GOOGLE_CLOUD_PROJECT environment variables. |
| backupKind? | enum | Specifies the kind of backup, PHYSICAL or DEFAULT_SNAPSHOT. |
| description? | string | The description of this run, only applicable to on-demand backups. |
| diskEncryptionConfiguration? | object | This is always `sql#diskEncryptionConfiguration`. |
| diskEncryptionStatus? | object | This is always `sql#diskEncryptionStatus`. |
| endTime? | string | The 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? | string | The 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? | object | Identifies the specific error that occurred. |
| id? | string | The identifier for this backup run. Unique only for a specific Cloud SQL instance. |
| instance? | string | Name of the database instance. |
| location? | string | Location of the backups. |
| startTime? | string | The 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? | enum | The status of this run. |
| timeZone? | string | Backup time zone to prevent restores to an instance with a different time zone. Now relevant only for SQL Server. |
| type? | enum | The 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? | string | The 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`. |
fn create(waitForReady?: boolean)
Create a backupRuns
| Argument | Type | Description |
|---|---|---|
| waitForReady? | boolean | Wait for the resource to reach a ready state after creation (default: true) |
fn get(identifier: string)
Get a backupRuns
| Argument | Type | Description |
|---|---|---|
| identifier | string | The id of the backupRuns |
fn delete(identifier: string)
Delete the backupRuns
| Argument | Type | Description |
|---|---|---|
| identifier | string | The id of the backupRuns |
fn sync()
Sync backupRuns state from GCP
fn list(maxResults?: number, maxPages?: number)
List backupRuns resources
| Argument | Type | Description |
|---|---|---|
| maxResults? | number | Maximum number of backup runs per response. |
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
connect.tsv2026.06.10.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| name | string | Instance name for this resource (used as the unique identifier in the factory pattern) |
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| project? | string | GCP project ID; overrides GCP_PROJECT / GOOGLE_CLOUD_PROJECT environment variables. |
fn get(identifier: string)
Get a connect
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the connect |
fn sync()
Sync connect state from GCP
fn generate_ephemeral_cert(access_token?: any, public_key?: any, readTime?: any, validDuration?: any)
generate ephemeral cert
| Argument | Type | Description |
|---|---|---|
| access_token? | any | |
| public_key? | any | |
| readTime? | any | |
| validDuration? | any |
fn resolve()
resolve
databases.tsv2026.06.08.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| charset? | string | The Cloud SQL charset value. |
| collation? | string | The Cloud SQL collation value. |
| instance? | string | The name of the Cloud SQL instance. This does not include the project ID. |
| name? | string | The name of the database in the Cloud SQL instance. This does not include the project ID or instance name. |
| project? | string | The project ID of the project containing the Cloud SQL database. The Google apps domain is prefixed if applicable. |
| sqlserverDatabaseDetails? | object | The version of SQL Server with which the database is to be made compatible |
fn create()
Create a databases
fn get(identifier: string)
Get a databases
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the databases |
fn update()
Update databases attributes
fn delete(identifier: string)
Delete the databases
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the databases |
fn sync()
Sync databases state from GCP
fn list(maxPages?: number)
List databases resources
| Argument | Type | Description |
|---|---|---|
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
flags.tsv2026.06.08.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| name | string | Instance name for this resource (used as the unique identifier in the factory pattern) |
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| project? | string | GCP project ID; overrides GCP_PROJECT / GOOGLE_CLOUD_PROJECT environment variables. |
fn get(identifier: string)
Get a flags
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the flags |
fn sync()
Sync flags state from GCP
fn list(databaseVersion?: string, flagScope?: string, maxPages?: number)
List flags resources
| Argument | Type | Description |
|---|---|---|
| databaseVersion? | string | Database type and version you want to retrieve flags for. By default, this method returns flags for all database types and versions. |
| flagScope? | string | Optional. Specify the scope of flags to be returned by SqlFlagsListService. Return list of database flags if unspecified. |
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
instances.tsv2026.06.10.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| backendType? | enum | The 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? | string | Connection name of the Cloud SQL instance used in connection strings. |
| databaseVersion? | enum | The database engine type and version. The `databaseVersion` field cannot be changed after instance creation. |
| diskEncryptionConfiguration? | object | This is always `sql#diskEncryptionConfiguration`. |
| diskEncryptionStatus? | object | This is always `sql#diskEncryptionStatus`. |
| failoverReplica? | object | The 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? | string | The 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? | object | Output only. Whether the active query is enabled. |
| includeReplicasForMajorVersionUpgrade? | boolean | Input 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? | enum | The instance type. |
| ipAddresses? | array | The IP address assigned. |
| maintenanceVersion? | string | The current software version on the instance. |
| masterInstanceName? | string | The name of the instance which will act as primary in the replication setup. |
| name? | string | Name of the Cloud SQL instance. This does not include the project ID. |
| nodeCount? | number | The number of read pool nodes in a read pool. |
| onPremisesConfiguration? | object | PEM representation of the trusted CA's x509 certificate. |
| outOfDiskReport? | object | The minimum recommended increase size in GigaBytes This field is consumed by the frontend * Writers: * the proactive database wellness job for OOD. * Readers: |
| project? | string | The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable. |
| region? | string | The 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? | object | Optional. 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? | array | The replicas of the instance. |
| replicationCluster? | object | Output 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? | string | Initial root password. Use only on creation. You must set root passwords before you can connect to PostgreSQL instances. |
| satisfiesPzs? | boolean | This status indicates whether the instance satisfies PZS. The status is reserved for future use. |
| scheduledMaintenance? | object | If the scheduled maintenance can be rescheduled. |
| secondaryGceZone? | string | The 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? | object | PEM representation. |
| serviceAccountEmailAddress? | string | The service account email address assigned to the instance.\\This property is read-only. |
| settings? | object | Optional. Whether the replica is in accelerated mode. This feature is in private preview and requires allowlisting to take effect. |
| sqlNetworkArchitecture? | enum | |
| state? | enum | The current serving state of the Cloud SQL instance. |
| suspensionReason? | array | If the instance state is SUSPENDED, the reason for the suspension. |
| switchTransactionLogsToCloudStorageEnabled? | boolean | Input only. Whether Cloud SQL is enabled to switch storing point-in-time recovery log files from a data disk to Cloud Storage. |
| tags? | record | Optional. 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. |
fn create(waitForReady?: boolean)
Create a instances
| Argument | Type | Description |
|---|---|---|
| waitForReady? | boolean | Wait for the resource to reach a ready state after creation (default: true) |
fn get(identifier: string)
Get a instances
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the instances |
fn update(waitForReady?: boolean)
Update instances attributes
| Argument | Type | Description |
|---|---|---|
| waitForReady? | boolean | Wait for the resource to reach a ready state after update (default: true) |
fn delete(identifier: string)
Delete the instances
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the instances |
fn sync()
Sync instances state from GCP
fn list(filter?: string, maxResults?: number, maxPages?: number)
List instances resources
| Argument | Type | Description |
|---|---|---|
| filter? | string | A filter expression that filters resources listed in the response. The expression is in the form of field:value. For example, 'instanceType:CLOUD_SQL_INSTANCE'. Fields can be nested as needed as per their JSON representation, such as 'settings.userLabels.auto_start:true'. Multiple filter queries are space-separated. For example. 'state:RUNNABLE instanceType:CLOUD_SQL_INSTANCE'. By default, each expression is an AND expression. However, you can include AND and OR expressions explicitly. |
| maxResults? | number | The maximum number of instances to return. The service may return fewer than this value. If unspecified, at most 500 instances are returned. The maximum value is 1000; values above 1000 are coerced to 1000. |
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
fn acquire_ssrs_lease(acquireSsrsLeaseContext?: any)
acquire ssrs lease
| Argument | Type | Description |
|---|---|---|
| acquireSsrsLeaseContext? | any |
fn add_entra_id_certificate()
add entra id certificate
fn add_server_ca()
add server ca
fn add_server_certificate()
add server certificate
fn clone(cloneContext?: any)
clone
| Argument | Type | Description |
|---|---|---|
| cloneContext? | any |
fn demote(demoteContext?: any)
demote
| Argument | Type | Description |
|---|---|---|
| demoteContext? | any |
fn demote_master(demoteMasterContext?: any)
demote master
| Argument | Type | Description |
|---|---|---|
| demoteMasterContext? | any |
fn execute_sql(application?: any, autoIamAuthn?: any, database?: any, partialResultMode?: any, rowLimit?: any, sqlStatement?: any, user?: any)
execute sql
| Argument | Type | Description |
|---|---|---|
| application? | any | |
| autoIamAuthn? | any | |
| database? | any | |
| partialResultMode? | any | |
| rowLimit? | any | |
| sqlStatement? | any | |
| user? | any |
fn export(exportContext?: any)
export
| Argument | Type | Description |
|---|---|---|
| exportContext? | any |
fn failover(failoverContext?: any)
failover
| Argument | Type | Description |
|---|---|---|
| failoverContext? | any |
fn import(importContext?: any)
import
| Argument | Type | Description |
|---|---|---|
| importContext? | any |
fn list_entra_id_certificates()
list entra id certificates
fn list_server_cas()
list server cas
fn list_server_certificates()
list server certificates
fn point_in_time_restore(allocatedIpRange?: any, datasource?: any, pointInTime?: any, preferredSecondaryZone?: any, preferredZone?: any, privateNetwork?: any, region?: any, targetInstance?: any, targetInstanceClearSettingsFieldNames?: any, targetInstanceSettings?: any)
point in time restore
| Argument | Type | Description |
|---|---|---|
| allocatedIpRange? | any | |
| datasource? | any | |
| pointInTime? | any | |
| preferredSecondaryZone? | any | |
| preferredZone? | any | |
| privateNetwork? | any | |
| region? | any | |
| targetInstance? | any | |
| targetInstanceClearSettingsFieldNames? | any | |
| targetInstanceSettings? | any |
fn pre_check_major_version_upgrade(preCheckMajorVersionUpgradeContext?: any)
pre check major version upgrade
| Argument | Type | Description |
|---|---|---|
| preCheckMajorVersionUpgradeContext? | any |
fn promote_replica()
promote replica
fn reencrypt(backupReencryptionConfig?: any)
reencrypt
| Argument | Type | Description |
|---|---|---|
| backupReencryptionConfig? | any |
fn release_ssrs_lease()
release ssrs lease
fn reset_ssl_config()
reset ssl config
fn restart()
restart
fn restore_backup(backup?: any, backupdrBackup?: any, restoreBackupContext?: any, restoreInstanceClearOverridesFieldNames?: any, restoreInstanceSettings?: any)
restore backup
| Argument | Type | Description |
|---|---|---|
| backup? | any | |
| backupdrBackup? | any | |
| restoreBackupContext? | any | |
| restoreInstanceClearOverridesFieldNames? | any | |
| restoreInstanceSettings? | any |
fn rotate_entra_id_certificate(rotateEntraIdCertificateContext?: any)
rotate entra id certificate
| Argument | Type | Description |
|---|---|---|
| rotateEntraIdCertificateContext? | any |
fn rotate_server_ca(rotateServerCaContext?: any)
rotate server ca
| Argument | Type | Description |
|---|---|---|
| rotateServerCaContext? | any |
fn rotate_server_certificate(rotateServerCertificateContext?: any)
rotate server certificate
| Argument | Type | Description |
|---|---|---|
| rotateServerCertificateContext? | any |
fn start_replica()
start replica
fn stop_replica()
stop replica
fn switchover()
switchover
fn truncate_log(truncateLogContext?: any)
truncate log
| Argument | Type | Description |
|---|---|---|
| truncateLogContext? | any |
sslcerts.tsv2026.06.08.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| name | string | Instance name for this resource (used as the unique identifier in the factory pattern) |
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| project? | string | GCP project ID; overrides GCP_PROJECT / GOOGLE_CLOUD_PROJECT environment variables. |
| commonName? | string | User supplied name. Must be a distinct name from the other certificates for this instance. |
| instance | string | Cloud SQL instance ID. This does not include the project ID. |
fn create()
Create a sslCerts
fn get(identifier: string)
Get a sslCerts
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the sslCerts |
fn delete(identifier: string)
Delete the sslCerts
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the sslCerts |
fn sync()
Sync sslCerts state from GCP
fn list(maxPages?: number)
List sslCerts resources
| Argument | Type | Description |
|---|---|---|
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
fn create_ephemeral(access_token?: any, public_key?: any)
create ephemeral
| Argument | Type | Description |
|---|---|---|
| access_token? | any | |
| public_key? | any |
tiers.tsv2026.06.08.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| name | string | Instance name for this resource (used as the unique identifier in the factory pattern) |
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| project? | string | GCP project ID; overrides GCP_PROJECT / GOOGLE_CLOUD_PROJECT environment variables. |
fn get(identifier: string)
Get a tiers
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the tiers |
fn sync()
Sync tiers state from GCP
fn list(maxPages?: number)
List tiers resources
| Argument | Type | Description |
|---|---|---|
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
users.tsv2026.06.10.1
Global Arguments
| Argument | Type | Description |
|---|---|---|
| accessToken? | string | GCP OAuth2 access token; overrides GCP_ACCESS_TOKEN environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| credentialsJson? | string | GCP service account JSON credentials; overrides GOOGLE_APPLICATION_CREDENTIALS_JSON environment variable. Wire with a vault.get(...) expression to source it from a vault. |
| databaseRoles? | array | Optional. Role memberships of the user |
| dualPasswordType? | enum | Dual password status for the user. |
| host? | string | Optional. 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? | string | Optional. The full email for an IAM user. For normal database users, this will not be filled. Only applicable to MySQL database users. |
| iamStatus? | enum | Indicates if a group is active or inactive for IAM database authentication. |
| instance? | string | The 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? | string | The name of the user in the Cloud SQL instance. Can be omitted for `update` because it is already specified in the URL. |
| password? | string | The password for the user. |
| passwordPolicy? | object | Number of failed login attempts allowed before user get locked. |
| project? | string | The 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? | object | If the user has been disabled |
| type? | enum | The user type. It determines the method to authenticate the user during login. The default is the database's built-in user type. |
fn create()
Create a users
fn get(identifier: string)
Get a users
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the users |
fn update()
Update users attributes
fn delete(identifier: string)
Delete the users
| Argument | Type | Description |
|---|---|---|
| identifier | string | The name of the users |
fn sync()
Sync users state from GCP
fn list(maxPages?: number)
List users resources
| Argument | Type | Description |
|---|---|---|
| maxPages? | number | Maximum number of pages to fetch (default: 10) |
04Previous Versions
2026.06.08.2Jun 8, 2026
- Updated: backupruns, connect, databases, flags, instances, sslcerts, tiers, users
2026.06.07.1Jun 7, 2026
- Updated: backupruns, connect, databases, flags, instances, sslcerts, tiers, users
2026.05.26.1May 26, 2026
- Updated: instances
2026.05.25.3May 25, 2026
- Updated: databases, sslcerts, tiers, users
Modified 1 models
2026.05.24.1May 24, 2026
- Updated: backupruns, connect, databases, flags, instances, sslcerts, tiers, users
2026.05.21.2May 21, 2026
- Updated: backupruns, connect, databases, flags, instances, sslcerts, tiers, users
2026.05.21.1May 21, 2026
2026.05.20.1May 20, 2026
- Updated: instances
2026.05.19.3May 19, 2026
2026.05.19.2May 19, 2026
2026.05.19.1May 19, 2026
- Updated: instances
2026.05.18.2May 18, 2026
2026.05.15.1May 15, 2026
- Updated: instances
2026.05.12.1May 12, 2026
- Updated: instances
2026.05.09.1May 10, 2026
- Updated: instances
2026.05.06.1May 6, 2026
- Updated: instances
Modified 1 models
2026.04.23.1Apr 23, 2026
Modified 1 models
2026.04.04.1Apr 4, 2026
- Updated: instances
2026.04.03.3Apr 3, 2026
- Updated: backupruns, connect, databases, flags, instances, sslcerts, tiers, users
05Stats
A
100 / 100
Downloads
3
Archive size
141.3 KB
Verified by Swamp
- Has README or module doc2/2earned
- README has a code example1/1earned
- README is substantive1/1earned
- Most symbols documented1/1earned
- No slow types (deprecated)1/1earned
- Dependencies pass trust audit2/2earned
- Has description1/1earned
- Platform support declared (or universal)2/2earned
- License declared1/1earned
- Verified public repository2/2earned
06Platforms
07Labels