Cloud SQL Admin API: Node.js Client

release level npm version

Sql client for Node.js

A comprehensive list of changes in each version may be found in the CHANGELOG .

Read more about the client libraries for Cloud APIs, including the older Google APIs Client Libraries, in Client Libraries Explained .

Table of contents:

Quickstart

Before you begin

  1. Select or create a Cloud Platform project .
  2. Enable billing for your project .
  3. Enable the Cloud SQL Admin API API .
  4. Set up authentication so you can access the API from your local workstation.

Installing the client library

 npm install @google-cloud/sql 

Using the client library

 // Imports the Sql library
const sqladmin = require(' @google-cloud/sql 
').v1;

// Instantiates a client. Use HTTP/1.1 fallback mode instead of gRPC.
const instancesClient = new sqladmin. SqlInstancesServiceClient 
({
  fallback: 'rest',
});

async function callList() {
  // Get project ID
  const project = await instancesClient.getProjectId();

  // Construct request
  const request = {
    project: project,
  };

  // Run request
  const response = await instancesClient.list(request);
  console.log(response);
}

callList(); 

Samples

Samples are in the samples/ directory. Each sample's README.md has instructions for running its sample.

Sample Source Code Try it
Sql_backup_runs_service.delete
source code Open in Cloud Shell
Sql_backup_runs_service.get
source code Open in Cloud Shell
Sql_backup_runs_service.insert
source code Open in Cloud Shell
Sql_backup_runs_service.list
source code Open in Cloud Shell
Sql_connect_service.generate_ephemeral_cert
source code Open in Cloud Shell
Sql_connect_service.get_connect_settings
source code Open in Cloud Shell
Sql_databases_service.delete
source code Open in Cloud Shell
Sql_databases_service.get
source code Open in Cloud Shell
Sql_databases_service.insert
source code Open in Cloud Shell
Sql_databases_service.list
source code Open in Cloud Shell
Sql_databases_service.patch
source code Open in Cloud Shell
Sql_databases_service.update
source code Open in Cloud Shell
Sql_flags_service.list
source code Open in Cloud Shell
Sql_instances_service.acquire_ssrs_lease
source code Open in Cloud Shell
Sql_instances_service.add_server_ca
source code Open in Cloud Shell
Sql_instances_service.clone
source code Open in Cloud Shell
Sql_instances_service.create_ephemeral
source code Open in Cloud Shell
Sql_instances_service.delete
source code Open in Cloud Shell
Sql_instances_service.demote
source code Open in Cloud Shell
Sql_instances_service.demote_master
source code Open in Cloud Shell
Sql_instances_service.export
source code Open in Cloud Shell
Sql_instances_service.failover
source code Open in Cloud Shell
Sql_instances_service.get
source code Open in Cloud Shell
Sql_instances_service.get_disk_shrink_config
source code Open in Cloud Shell
Sql_instances_service.get_latest_recovery_time
source code Open in Cloud Shell
Sql_instances_service.import
source code Open in Cloud Shell
Sql_instances_service.insert
source code Open in Cloud Shell
Sql_instances_service.list
source code Open in Cloud Shell
Sql_instances_service.list_server_cas
source code Open in Cloud Shell
Sql_instances_service.patch
source code Open in Cloud Shell
Sql_instances_service.perform_disk_shrink
source code Open in Cloud Shell
Sql_instances_service.promote_replica
source code Open in Cloud Shell
Sql_instances_service.reencrypt
source code Open in Cloud Shell
Sql_instances_service.release_ssrs_lease
source code Open in Cloud Shell
Sql_instances_service.reschedule_maintenance
source code Open in Cloud Shell
Sql_instances_service.reset_replica_size
source code Open in Cloud Shell
Sql_instances_service.reset_ssl_config
source code Open in Cloud Shell
Sql_instances_service.restart
source code Open in Cloud Shell
Sql_instances_service.restore_backup
source code Open in Cloud Shell
Sql_instances_service.rotate_server_ca
source code Open in Cloud Shell
Sql_instances_service.start_external_sync
source code Open in Cloud Shell
Sql_instances_service.start_replica
source code Open in Cloud Shell
Sql_instances_service.stop_replica
source code Open in Cloud Shell
Sql_instances_service.switchover
source code Open in Cloud Shell
Sql_instances_service.truncate_log
source code Open in Cloud Shell
Sql_instances_service.update
source code Open in Cloud Shell
Sql_instances_service.verify_external_sync_settings
source code Open in Cloud Shell
Sql_operations_service.cancel
source code Open in Cloud Shell
Sql_operations_service.get
source code Open in Cloud Shell
Sql_operations_service.list
source code Open in Cloud Shell
Sql_ssl_certs_service.delete
source code Open in Cloud Shell
Sql_ssl_certs_service.get
source code Open in Cloud Shell
Sql_ssl_certs_service.insert
source code Open in Cloud Shell
Sql_ssl_certs_service.list
source code Open in Cloud Shell
Sql_tiers_service.list
source code Open in Cloud Shell
Sql_users_service.delete
source code Open in Cloud Shell
Sql_users_service.get
source code Open in Cloud Shell
Sql_users_service.insert
source code Open in Cloud Shell
Sql_users_service.list
source code Open in Cloud Shell
Sql_users_service.update
source code Open in Cloud Shell
Sql_backup_runs_service.delete
source code Open in Cloud Shell
Sql_backup_runs_service.get
source code Open in Cloud Shell
Sql_backup_runs_service.insert
source code Open in Cloud Shell
Sql_backup_runs_service.list
source code Open in Cloud Shell
Sql_connect_service.generate_ephemeral_cert
source code Open in Cloud Shell
Sql_connect_service.get_connect_settings
source code Open in Cloud Shell
Sql_databases_service.delete
source code Open in Cloud Shell
Sql_databases_service.get
source code Open in Cloud Shell
Sql_databases_service.insert
source code Open in Cloud Shell
Sql_databases_service.list
source code Open in Cloud Shell
Sql_databases_service.patch
source code Open in Cloud Shell
Sql_databases_service.update
source code Open in Cloud Shell
Sql_flags_service.list
source code Open in Cloud Shell
Sql_instances_service.acquire_ssrs_lease
source code Open in Cloud Shell
Sql_instances_service.add_server_ca
source code Open in Cloud Shell
Sql_instances_service.clone
source code Open in Cloud Shell
Sql_instances_service.create_ephemeral
source code Open in Cloud Shell
Sql_instances_service.delete
source code Open in Cloud Shell
Sql_instances_service.demote
source code Open in Cloud Shell
Sql_instances_service.demote_master
source code Open in Cloud Shell
Sql_instances_service.export
source code Open in Cloud Shell
Sql_instances_service.failover
source code Open in Cloud Shell
Sql_instances_service.get
source code Open in Cloud Shell
Sql_instances_service.get_disk_shrink_config
source code Open in Cloud Shell
Sql_instances_service.get_latest_recovery_time
source code Open in Cloud Shell
Sql_instances_service.import
source code Open in Cloud Shell
Sql_instances_service.insert
source code Open in Cloud Shell
Sql_instances_service.list
source code Open in Cloud Shell
Sql_instances_service.list_server_cas
source code Open in Cloud Shell
Sql_instances_service.patch
source code Open in Cloud Shell
Sql_instances_service.perform_disk_shrink
source code Open in Cloud Shell
Sql_instances_service.promote_replica
source code Open in Cloud Shell
Sql_instances_service.reencrypt
source code Open in Cloud Shell
Sql_instances_service.release_ssrs_lease
source code Open in Cloud Shell
Sql_instances_service.reschedule_maintenance
source code Open in Cloud Shell
Sql_instances_service.reset_replica_size
source code Open in Cloud Shell
Sql_instances_service.reset_ssl_config
source code Open in Cloud Shell
Sql_instances_service.restart
source code Open in Cloud Shell
Sql_instances_service.restore_backup
source code Open in Cloud Shell
Sql_instances_service.rotate_server_ca
source code Open in Cloud Shell
Sql_instances_service.start_external_sync
source code Open in Cloud Shell
Sql_instances_service.start_replica
source code Open in Cloud Shell
Sql_instances_service.stop_replica
source code Open in Cloud Shell
Sql_instances_service.switchover
source code Open in Cloud Shell
Sql_instances_service.truncate_log
source code Open in Cloud Shell
Sql_instances_service.update
source code Open in Cloud Shell
Sql_instances_service.verify_external_sync_settings
source code Open in Cloud Shell
Sql_operations_service.cancel
source code Open in Cloud Shell
Sql_operations_service.get
source code Open in Cloud Shell
Sql_operations_service.list
source code Open in Cloud Shell
Sql_ssl_certs_service.delete
source code Open in Cloud Shell
Sql_ssl_certs_service.get
source code Open in Cloud Shell
Sql_ssl_certs_service.insert
source code Open in Cloud Shell
Sql_ssl_certs_service.list
source code Open in Cloud Shell
Sql_tiers_service.list
source code Open in Cloud Shell
Sql_users_service.delete
source code Open in Cloud Shell
Sql_users_service.get
source code Open in Cloud Shell
Sql_users_service.insert
source code Open in Cloud Shell
Sql_users_service.list
source code Open in Cloud Shell
Sql_users_service.update
source code Open in Cloud Shell
Quickstart
source code Open in Cloud Shell

The Cloud SQL Admin API Node.js Client API Reference documentation also contains samples.

Supported Node.js Versions

Our client libraries follow the Node.js release schedule . Libraries are compatible with all current active and maintenance versions of Node.js. If you are using an end-of-life version of Node.js, we recommend that you update as soon as possible to an actively supported LTS version.

Google's client libraries support legacy versions of Node.js runtimes on a best-efforts basis with the following warnings:

  • Legacy versions are not tested in continuous integration.
  • Some security patches and features cannot be backported.
  • Dependencies cannot be kept up-to-date.

Client libraries targeting some end-of-life versions of Node.js are available, and can be installed through npm dist-tags . The dist-tags follow the naming convention legacy-(version) . For example, npm install @google-cloud/sql@legacy-8 installs client libraries for versions compatible with Node.js 8.

Versioning

This library follows Semantic Versioning .

This library is considered to be stable. The code surface will not change in backwards-incompatible ways unless absolutely necessary (e.g. because of critical security issues) or with an extensive deprecation period. Issues and requests against stablelibraries are addressed with the highest priority.

More Information: Google Cloud Platform Launch Stages

Contributing

Contributions welcome! See the Contributing Guide .

Please note that this README.md , the samples/README.md , and a variety of configuration files in this repository (including .nycrc and tsconfig.json ) are generated from a central template. To edit one of these files, make an edit to its templates in directory .

License

Apache Version 2.0

See LICENSE

Design a Mobile Site
View Site in Mobile | Classic
Share by: