Simple example of wrapping mysql functionalities on Promises and calling them with async/await interfaces.

mysql-async-example.js

// conn.js

const mysql = require('mysql');

exports.openConnectionAsync = function openConnectionAsync() {
  const conn = mysql.createConnection({
    // ... config
  });

  return new Promise((resolve, reject) => {
    conn.connect(err => {
      if (err) return reject(err);
      return resolve(conn);
    });
  });
};

// user-repository.js

const { openConnectionAsync } = require('./conn');

exports.createUserAsync = async function createUserAsync(user) {
  const conn = await openConnectionAsync();
  conn.query('insert into users set ?', user);

  conn.end();
};