Cloud SQL Admin API: Node.js Client

release levelnpm version

Sql client for Node.js

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

Read more about the client libraries for Cloud APIs, including the olderGoogle APIs Client Libraries, inClient 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 with a service account so you can access theAPI from your local workstation.

Installing the client library

npm install @google-cloud/sql

Using the client library

// Imports the Sql libraryconst 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 thesamples/ directory. Each sample'sREADME.md has instructions for running its sample.

SampleSource CodeTry it
Sql_backup_runs_service.deletesource codeOpen in Cloud Shell
Sql_backup_runs_service.getsource codeOpen in Cloud Shell
Sql_backup_runs_service.insertsource codeOpen in Cloud Shell
Sql_backup_runs_service.listsource codeOpen in Cloud Shell
Sql_connect_service.generate_ephemeral_certsource codeOpen in Cloud Shell
Sql_connect_service.get_connect_settingssource codeOpen in Cloud Shell
Sql_databases_service.deletesource codeOpen in Cloud Shell
Sql_databases_service.getsource codeOpen in Cloud Shell
Sql_databases_service.insertsource codeOpen in Cloud Shell
Sql_databases_service.listsource codeOpen in Cloud Shell
Sql_databases_service.patchsource codeOpen in Cloud Shell
Sql_databases_service.updatesource codeOpen in Cloud Shell
Sql_flags_service.listsource codeOpen in Cloud Shell
Sql_instances_service.acquire_ssrs_leasesource codeOpen in Cloud Shell
Sql_instances_service.add_server_casource codeOpen in Cloud Shell
Sql_instances_service.clonesource codeOpen in Cloud Shell
Sql_instances_service.create_ephemeralsource codeOpen in Cloud Shell
Sql_instances_service.deletesource codeOpen in Cloud Shell
Sql_instances_service.demotesource codeOpen in Cloud Shell
Sql_instances_service.demote_mastersource codeOpen in Cloud Shell
Sql_instances_service.exportsource codeOpen in Cloud Shell
Sql_instances_service.failoversource codeOpen in Cloud Shell
Sql_instances_service.getsource codeOpen in Cloud Shell
Sql_instances_service.get_disk_shrink_configsource codeOpen in Cloud Shell
Sql_instances_service.get_latest_recovery_timesource codeOpen in Cloud Shell
Sql_instances_service.importsource codeOpen in Cloud Shell
Sql_instances_service.insertsource codeOpen in Cloud Shell
Sql_instances_service.listsource codeOpen in Cloud Shell
Sql_instances_service.list_server_cassource codeOpen in Cloud Shell
Sql_instances_service.patchsource codeOpen in Cloud Shell
Sql_instances_service.perform_disk_shrinksource codeOpen in Cloud Shell
Sql_instances_service.promote_replicasource codeOpen in Cloud Shell
Sql_instances_service.reencryptsource codeOpen in Cloud Shell
Sql_instances_service.release_ssrs_leasesource codeOpen in Cloud Shell
Sql_instances_service.reschedule_maintenancesource codeOpen in Cloud Shell
Sql_instances_service.reset_replica_sizesource codeOpen in Cloud Shell
Sql_instances_service.reset_ssl_configsource codeOpen in Cloud Shell
Sql_instances_service.restartsource codeOpen in Cloud Shell
Sql_instances_service.restore_backupsource codeOpen in Cloud Shell
Sql_instances_service.rotate_server_casource codeOpen in Cloud Shell
Sql_instances_service.start_external_syncsource codeOpen in Cloud Shell
Sql_instances_service.start_replicasource codeOpen in Cloud Shell
Sql_instances_service.stop_replicasource codeOpen in Cloud Shell
Sql_instances_service.switchoversource codeOpen in Cloud Shell
Sql_instances_service.truncate_logsource codeOpen in Cloud Shell
Sql_instances_service.updatesource codeOpen in Cloud Shell
Sql_instances_service.verify_external_sync_settingssource codeOpen in Cloud Shell
Sql_operations_service.cancelsource codeOpen in Cloud Shell
Sql_operations_service.getsource codeOpen in Cloud Shell
Sql_operations_service.listsource codeOpen in Cloud Shell
Sql_ssl_certs_service.deletesource codeOpen in Cloud Shell
Sql_ssl_certs_service.getsource codeOpen in Cloud Shell
Sql_ssl_certs_service.insertsource codeOpen in Cloud Shell
Sql_ssl_certs_service.listsource codeOpen in Cloud Shell
Sql_tiers_service.listsource codeOpen in Cloud Shell
Sql_users_service.deletesource codeOpen in Cloud Shell
Sql_users_service.getsource codeOpen in Cloud Shell
Sql_users_service.insertsource codeOpen in Cloud Shell
Sql_users_service.listsource codeOpen in Cloud Shell
Sql_users_service.updatesource codeOpen in Cloud Shell
Sql_backup_runs_service.deletesource codeOpen in Cloud Shell
Sql_backup_runs_service.getsource codeOpen in Cloud Shell
Sql_backup_runs_service.insertsource codeOpen in Cloud Shell
Sql_backup_runs_service.listsource codeOpen in Cloud Shell
Sql_connect_service.generate_ephemeral_certsource codeOpen in Cloud Shell
Sql_connect_service.get_connect_settingssource codeOpen in Cloud Shell
Sql_databases_service.deletesource codeOpen in Cloud Shell
Sql_databases_service.getsource codeOpen in Cloud Shell
Sql_databases_service.insertsource codeOpen in Cloud Shell
Sql_databases_service.listsource codeOpen in Cloud Shell
Sql_databases_service.patchsource codeOpen in Cloud Shell
Sql_databases_service.updatesource codeOpen in Cloud Shell
Sql_flags_service.listsource codeOpen in Cloud Shell
Sql_instances_service.acquire_ssrs_leasesource codeOpen in Cloud Shell
Sql_instances_service.add_server_casource codeOpen in Cloud Shell
Sql_instances_service.clonesource codeOpen in Cloud Shell
Sql_instances_service.create_ephemeralsource codeOpen in Cloud Shell
Sql_instances_service.deletesource codeOpen in Cloud Shell
Sql_instances_service.demotesource codeOpen in Cloud Shell
Sql_instances_service.demote_mastersource codeOpen in Cloud Shell
Sql_instances_service.exportsource codeOpen in Cloud Shell
Sql_instances_service.failoversource codeOpen in Cloud Shell
Sql_instances_service.getsource codeOpen in Cloud Shell
Sql_instances_service.get_disk_shrink_configsource codeOpen in Cloud Shell
Sql_instances_service.get_latest_recovery_timesource codeOpen in Cloud Shell
Sql_instances_service.importsource codeOpen in Cloud Shell
Sql_instances_service.insertsource codeOpen in Cloud Shell
Sql_instances_service.listsource codeOpen in Cloud Shell
Sql_instances_service.list_server_cassource codeOpen in Cloud Shell
Sql_instances_service.patchsource codeOpen in Cloud Shell
Sql_instances_service.perform_disk_shrinksource codeOpen in Cloud Shell
Sql_instances_service.promote_replicasource codeOpen in Cloud Shell
Sql_instances_service.reencryptsource codeOpen in Cloud Shell
Sql_instances_service.release_ssrs_leasesource codeOpen in Cloud Shell
Sql_instances_service.reschedule_maintenancesource codeOpen in Cloud Shell
Sql_instances_service.reset_replica_sizesource codeOpen in Cloud Shell
Sql_instances_service.reset_ssl_configsource codeOpen in Cloud Shell
Sql_instances_service.restartsource codeOpen in Cloud Shell
Sql_instances_service.restore_backupsource codeOpen in Cloud Shell
Sql_instances_service.rotate_server_casource codeOpen in Cloud Shell
Sql_instances_service.start_external_syncsource codeOpen in Cloud Shell
Sql_instances_service.start_replicasource codeOpen in Cloud Shell
Sql_instances_service.stop_replicasource codeOpen in Cloud Shell
Sql_instances_service.switchoversource codeOpen in Cloud Shell
Sql_instances_service.truncate_logsource codeOpen in Cloud Shell
Sql_instances_service.updatesource codeOpen in Cloud Shell
Sql_instances_service.verify_external_sync_settingssource codeOpen in Cloud Shell
Sql_operations_service.cancelsource codeOpen in Cloud Shell
Sql_operations_service.getsource codeOpen in Cloud Shell
Sql_operations_service.listsource codeOpen in Cloud Shell
Sql_ssl_certs_service.deletesource codeOpen in Cloud Shell
Sql_ssl_certs_service.getsource codeOpen in Cloud Shell
Sql_ssl_certs_service.insertsource codeOpen in Cloud Shell
Sql_ssl_certs_service.listsource codeOpen in Cloud Shell
Sql_tiers_service.listsource codeOpen in Cloud Shell
Sql_users_service.deletesource codeOpen in Cloud Shell
Sql_users_service.getsource codeOpen in Cloud Shell
Sql_users_service.insertsource codeOpen in Cloud Shell
Sql_users_service.listsource codeOpen in Cloud Shell
Sql_users_service.updatesource codeOpen in Cloud Shell
Quickstartsource codeOpen in Cloud Shell

TheCloud SQL Admin API Node.js Client API Reference documentationalso contains samples.

Supported Node.js Versions

Our client libraries follow theNode.js release schedule.Libraries are compatible with all currentactive andmaintenance versions ofNode.js.If you are using an end-of-life version of Node.js, we recommend that you updateas soon as possible to an actively supported LTS version.

Google's client libraries support legacy versions of Node.js runtimes on abest-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, andcan be installed through npmdist-tags.The dist-tags follow the naming conventionlegacy-(version).For example,npm install @google-cloud/sql@legacy-8 installs client librariesfor versions compatible with Node.js 8.

Versioning

This library followsSemantic Versioning.

This library is considered to bestable. The code surface will not change in backwards-incompatible waysunless absolutely necessary (e.g. because of critical security issues) or withan extensive deprecation period. Issues and requests againststable librariesare addressed with the highest priority.

More Information:Google Cloud Platform Launch Stages

Contributing

Contributions welcome! See theContributing Guide.

Please note that thisREADME.md, thesamples/README.md,and a variety of configuration files in this repository (including.nycrc andtsconfig.json)are generated from a central template. To edit one of these files, make an editto its templates indirectory.

License

Apache Version 2.0

SeeLICENSE

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-03 UTC.