Create a socket connection when using Node.js

Open a Unix socket connection to Cloud SQL for MySQL by using the Node.js npm mysql module.

Explore further

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

• About Cloud SQL connections
• 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
• Manage database connections

Code sample

Node.js

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

const mysql = require('promise-mysql');

// createUnixSocketPool initializes a Unix socket connection pool for
// a Cloud SQL instance of MySQL.
const createUnixSocketPool = 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.
  return mysql.createPool({
    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'
    socketPath: process.env.INSTANCE_UNIX_SOCKET, // e.g. '/cloudsql/project:region:instance'
    // Specify additional properties here.
    ...config,
  });
};

What's next

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