Knex.js

/**
 * DB Connection
 * @type {{host, user, password, database}}
 */
var params = (function(){
  if(sails.config.environment == 'production'){
    return {
      host: sails.config.connections.prodMysqlServer.host,
      user: sails.config.connections.prodMysqlServer.user,
      password: sails.config.connections.prodMysqlServer.password,
      database: sails.config.connections.prodMysqlServer.database
    };
  }else{
    return {
      host: sails.config.connections.someMysqlServer.host,
      user: sails.config.connections.someMysqlServer.user,
      password: sails.config.connections.someMysqlServer.password,
      database: sails.config.connections.someMysqlServer.database
    };
  }
})();

//sails.config.enums.
var knex = require('knex')({
  client: 'mysql',
  connection: params
});

module.exports = knex;