mysql-promise.js

var mysql = require("mysql");
var Promise = require("bluebird");
Promise.promisifyAll(mysql);
Promise.promisifyAll(require("mysql/lib/Connection").prototype);
Promise.promisifyAll(require("mysql/lib/Pool").prototype);

var getConnection = exports.getConnection = function() {
    return pool.getConnectionAsync().disposer(function(connection) {
        try {
            connection.release();
        } catch(e) {};
    });
}
var pool;
var initialize = exports.initialize = function(opt){
    pool = mysql.createPool(opt);
}
var finalize = exports.finalize = function(){
    pool.end();
}

initialize({
    connectionLimit: 10,
    host: 'localhost',
    user: 'root',
    password: '',
    database:'mysql'
});
var using = Promise.using;
using(getConnection(), function(connection) {
   return connection.queryAsync("SELECT * FROM user");
}).then(function(rows) {
    console.log(rows);
    finalize();
});