koa-bookshelf

const Koa = require('koa');
const bookshelf = require('koa-bookshelf');

const app = new Koa();

app.use(bookshelf('/app/models', {
  client: 'mysql',
  connection: {
    host : 'localhost',
    user : 'root',
    password : '',
    database : 'blog'
  }
}));

app.use(async function (ctx, next) {
  const User = ctx.models.User;
  var users = await User.where({}).fetchAll();

  ctx.body = users;
});

app.listen(3000);