Create a TCP connection when using Node.js

Demonstrates opening a TCP connection to Cloud SQL for SQL Server using the Node.js mssql module.

Explore further

For detailed documentation that includes this code sample, see the following:

• About connection options
• Connect from App Engine flexible environment
• Connect from App Engine standard environment
• Connect from Cloud Build
• Connect from Cloud Functions
• Connect from Cloud Run
• Connect using the Cloud SQL Auth proxy

Code sample

Node.js

To authenticate to Cloud SQL for SQL Server, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.

const mssql = require('mssql');

// createTcpPool initializes a TCP connection pool for a Cloud SQL
// instance of SQL Server.
const createTcpPool = async config => {
  // Note: Saving credentials in environment variables is convenient, but not
  // secure - consider a more secure solution such as
  // Cloud Secret Manager (https://cloud.google.com/secret-manager) to help
  // keep secrets safe.
  const dbConfig = {
    server: process.env.INSTANCE_HOST, // e.g. '127.0.0.1'
    port: parseInt(process.env.DB_PORT), // e.g. 1433
    user: process.env.DB_USER, // e.g. 'my-db-user'
    password: process.env.DB_PASS, // e.g. 'my-db-password'
    database: process.env.DB_NAME, // e.g. 'my-database'
    options: {
      trustServerCertificate: true,
    },
    // ... Specify additional properties here.
    ...config,
  };
  // Establish a connection to the database.
  return mssql.connect(dbConfig);
};

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.